LU04.A03 - ERM: SchoolGrades_DB

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

In order to store business data efficiently we need a structure that should match the needs of the requirements. The first step is generally to analyse the business case and build up our data structure.

You are assigned of designing a database to manage the students' grades and the subjects they attend.

• each student is attending several subjects
• for each subject the student receive a grade
• each subject can be attended by several students

Analyse the given business cases and design an ERM that meets the requirements of the business cases below.

1. Identify the entities (tables)
2. Determine the attributes of each table, including the primary keys
3. Connect the base tables by adding ralations to your data model
4. Determin the cardinality of the tables involved.

Lösung

Volkan Demir