LU04.S03 - ERM: SchoolGrades_DB

For this scenario, the following entity-types are identified:

1. Grad

• Attributes
  • grade_id: INT
  • grade_Value: INT

2. Student

• Attributes
  • student_id (PK)
  • name: VARCHAR(50)

3. Subject

• Attributes:
  • subject_id (PK) - INT
  • title: VARCHAR(50)

4. 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.

Volkan Demir