Download SOLUTIONS for Assignment #2

2
Q3 [10]
Build an entity-relationship diagram to declare and structure the data of the systems.
Solution1: UML Based
Entity-Relationship Diagram is UML based version of the entity-relationship diagram. It is easier to
understand and follow as opposed to the one used in databases. This version does not require you to
understand what each shape and symbol means. Also, the UML based version fully labels the diagram
and in my opinion, provides greater detail.
Solution2: Version used in databases
The structure used is the version used in databases. It is easier to read as entities, relationships, and
attributes have different shapes to identify them rather than being crammed together. Also, where
the database version is better is in identifying relationships. Relationships are represented by a
distinct diamond that connects entity sets rather than just a word on a line, the diamond is much
clearer to see that it is a relationship. It is also easier to see the distinction between an entity set
and its attributes in the database version.