State any justifications or assumptions you make.

Given the above information:
(a) Develop an Entity–Relationship model to illustrate the logical database design.
(b) Produce a set of tables from your Entity–Relationship model, clearly identifying the primary keys.

For the diagram, four entities can be determined: Tutor, Course, Student, and Offering. Course to Offering and Tutor to Offering are both 1:*, but Student to Offering is *:*.


The tables should be derived relatively easily from the model, the most tricky one being Offering. There also needs to be a table to represent the relationship between Student and Offering, which will also contain the courseFee attribute.
Student (matricNo, studentFName, studentLName, street, city, postcode,
telNo)
Primary Key matricNo

Course (courseNo, courseName, courseDescription)
Primary Key courseNo

Offering (courseNo, tutorNo, startDate, startTime, endDate, endTime,
maxStudents)
Primary Key courseNo, matricNo
Foreign Key courseNo references Course(courseNo)
Foreign Key tutorNo references Tutor (tutorNo)

Registration (courseNo, tutorNo, matricNo, registrationDate, courseFee)
Primary Key courseNo, tutorNo, matricNo
Foreign Key (courseNo, tutorNo) references Offering(courseNo, tutorNo)
Foreign Key matricNo references Student(matricNo)