BIT305 Database Management Systems - Emirates College of Technology
LO 1: Explain the Basic Database Concepts
LO 2: Design a Relational Database using Entity-Relationship Diagram (ER-D)
LO 3: Designa Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models
Project topic: Hospital Management system (Sheikh Khalifa Medical City)
The project for this module consists of 3phases;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 summarizing the business rules for the business that you are designing database for.
For example: If the topic aboutGulf Airways. We work ERD or model between employees, aircraft and passengers... Etc means It's a details you talk how each entity has its name and what it contains and with who has a relationship& the relations between them as a whole.
Phase 2: Entity Relationship Diagram (ERD)
Draw an ERD reflecting the elements (entities and attributes) that are described in the scenario. A minimum of 10entities is required.
Phase 3: Mapping
Apply mapping to convert the ERD to a relational Schema.
The requirements above have to be documented in a report.
• Title Page
• Table of Contents (as attached style)
• Database Design for all the phases
Attachment:- Database Management Systems.rar