Reference no: EM13761608

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