LU04.A05 - ERD: SchoolGrades DB

After developing our conceptional data model, the next step to establish a physical data base is shape a ERD, the Entity Relationship Diagram.

• Work type: Peer
• Means of aid: only teaching materials, no use of ai.
• Timeframe: 10 Minutes
• Expected result: A Word/PDF file with an ERD that visualises the given business case.

Create an ERD to the given ERM in the Crow's Foot Notation.

• Identify additional attributes
• Establish relation with inkl. the primary keys and foreign keys
• Connect the tables and finish your work by fixing the entities (1:1, 1:n, n:m)

1. Relationships:

• 0-to-1:
  • A student habe 0 to at the most 1 grade in each subject.
• 0-to-many
  • A subject can be attended by many students.

2. ERM visualisation

Lösung

Volkan Demir