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 *:*.


![15247|573x236](upload://ugaY78bfOFPOWhfYGPj6g5Mp20N.png)

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)

Computer Science & Information Technology

You might also like to view...

Match each term with the correct statement below.

A. A measurement process that produces discrete objective data B. The specific framework of controls used by an organization C. A response in advance of a potential incident D. The present status of the elements of an operating environment E. A collection of explicit controls designed to accomplish a purpose F. Additional work required to finalize a solution; usually results from a review G. Large-scale process designed to ensure management control H. Formal process used to identify and characterize threats I. A response that takes place after an incident has occurred

Computer Science & Information Technology

By default, the text in merged cells is centered.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Consider the following list.list = {5, 11, 25, 28, 45, 78, 100, 120, 125};Suppose that binary search as discussed in the book is used to determine whether 110 is in list. Exactly how many key comparisons are executed by binary search?

A. 3 B. 5 C. 8 D. 12

Computer Science & Information Technology

The formatting Word uses to show a document's revisions visually is termed ________

A) balloon B) comment C) markup D) strikeout

Computer Science & Information Technology