Answer it
P1 a3 music school design
4 marksYou mark it yourself against the marking points
A music school has drawn an entity relationship design for its lessons. These tables describe it.
| Entity | Attributes |
|---|---|
| Student | student_id (primary key), name |
| Course | course_code (primary key), instrument, grade_level |
| Teacher | teacher_id (primary key), name |
| Relationship | Cardinality |
|---|---|
| Teacher teaches Course | one-to-many (each course has exactly one teacher) |
| Student enrols on Course | many-to-many |
(a) Explain why the relationship between Student and Course cannot be put into tables by adding one foreign key to Student or to Course. [1]
(b) Construct a set of tables that puts this whole design into a relational database. For each table, give its attributes, its primary key and any foreign keys. [3]
[4]