homework for HCA537

HCA-537: Introduction to Health Database and Technologies Instructor: Wu,M

Project: Logical Design (Entity Relationship Diagram)

To develop a database for a system, we should create an ER diagram, which is a logic data model for that system. Firstly, you have to choose a system of interests. A short description of the system is required. You should define mission statement and mission objectives for the database system. Secondly, you’ll analyze this system to identify a list of entities with attributes in that system. Finally, you should identify relationships among entities and draw an ER diagram for that system. There should be more than 5 tables (including data and linking tables) in your final ER diagram. This is a group project, and each group has to submit a report (Total: 50 points), which should include A short description of the system (10 points),

Mission Statement and objectives (10 points),

A list of entities with attributes (10 points)

and an ER diagram (20 points).

** Using your imagination, you are strongly encouraged to choose a system of interests by your own for this project.

Helping Line

 Tips: (1) To identify the important objects (entities) that need to be represented in the database and create a primary key for each entity. (2) To analysis the relationships between these objects. (One-to-One, One-to-Many, or Many-to-Many). (3) To draw rectangles (data tables) for entities including Table Name and Primary Key. (4) To implement relationships by adding foreign keys and draw line between the tables. If necessary, to create linking tables to implement Many-to-Many relationships between data tables (entities). (5) To label the relationship types (such as, 1-to-M) and participation types (such as, optional).