A many-to-one relationship must be made between the Session table ( a group of the Lecture table and the Practical table) and the Module table. The Lecture table and the Practical table are both join tables which allow the necessary one to many relationship with the Tutor table and the Session table and the many-to-many relationship between Tutor and Session table. A one-to-many relationship should be constructed between the Tutor table and the Lecture table. Finally, a many-to-many relationship between the table Tutor and the table Practical must be created. The versions of MySQL used for this exercise the relationship of many entities to many must be made through an outer join, represented by the join table. This is displayed in the figure below in paragraph 2.b. These specifications have been duplicated in the attached appendices with the required SQL code.
a. The schematic describing the logical data model is illustrated in paragraph 2. b. below. ...Show more