In this exercise we will practise modelling domains through the use of E-R diagrams. Your task is to create a database for scheduling classes. The following attributes should be represented in your tables:
Classes in a particular course are given at the same day and time each week, possibly more than once each week. A teacher can hold several courses, but will only hold classes in the same class room. More than one teacher could have classes in the same class room (though of course not at the same time).
Draw an E-R diagram modelling this domain.
Also do the following exercises from "Database Systems: The Complete Book, 2/E"
If you have the first edition of the textbook, these are exercises:
Translate your E-R diagram to a database schema consisting of relations. Mark all keys and references that exist in and between your relations.
Do your relations suffer from any of the following?
If yes, why, and can you fix it?