====== LU04.A03 - ERM: SchoolGrades_DB======

===== Prerequisites  =====
  * 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.  

===== Introduction  =====
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. 

===== Given business case =====
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

===== Task: Design a ERM  ====
Analyse the given business cases and design an ERM that meets the requirements of the business cases below.

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

===== Solution =====
[[modul:m290:learningunits:lu03:loesungen:l03|Lösung]]


===== Vocabulary =====
^ English ^ German ^ 
| prerequisite | Grundvoraussetzung |



----
[[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir