Project: Logical Design (Entity Relationship Diagram)

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.