Design a Relational Database using Entity-Relationship Diagram (ER-D)
Design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models.
Apply Normalization to the database design.
Apply Relational Algebra operations on real database.
Create and manipulate relational database systems using SQL.
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
