Question

Draw an EERD for the following situation. Students are required to turn in assignments. Attributes of STUDENT include StudentID (identifier), Name, and Major. Attributes of ASSIGNMENT include AssignmentNo (identifier) and DueDate. The grade obtained by each student for each assignment is recorded.

Assignments may be either modeling or computer assignments. Computer assignments have an additional attribute, PlatformUsed. Modeling assignments are based on cases. A case may be used in one or more modeling assignments, and a given modeling assignment is associated with exactly a case. Attributes of CASE include CaseNo (identifier) and Author.

[Note: M:N relationships need to be converted to associative entities.]

Answer 1

Enhanced Entity Relationship diagram:

The Enhanced entity relationship diagrams are a representation for the interactions between the entities.

These avdanced database diagrams are similar to the Er diagrams with advanced properties in it.

The entities have attributes which are of various types.

These attributes are mentioned in the diagram below.

EER diagram:

The EER diagram is represented as shown below.