Create and manipulate relational database systems using SQL|Management System
Project Task
The project for this module consists of 6 phases, which should be accomplished within 8 weeks. The work of each phase should be documented and submitted to the instructor according to the due date. The tasks for each phase are described below.
Phase 1: Scenario
Write a scenario summarizes the business rules for the business that you are creating database for.
Phase 2: Entity Relationship Diagram (ERD)
Draw an ERD reflects the elements (entities and attributes) that are described in the scenario.
Phase 3: Mapping
Apply mapping to the ERD.
Phase 4: Normalization
Apply normalization and define the final entities and their attributes.
Note: provide justification if normalization is not required for your project.
Phase 5: Database Implementation
– Create the database using SQL. Write all the SQL commands for each table.
– Write at least 3 SQL commands to select, insert, update or delete a specific data in the database.
Phase 6: Presentation & Final Report due date:
Each group members should present their work in front of their classmates.
The evaluation of your presentation will be based on the following criteria:
– Clarity of demonstration
– Utilization of time
– Awareness of the contents being presented and the response to examiners’ questions.
The requirements above have to be documented in a report.
Project Report Includes
Title Page
Table of Contents
Database Design for all the phases
References
Proposed Project topics:
– Course administration System
– Library Management system
– Bus station Management system
– Hospital Management system
