We would like to develop a database that captures the following requirements. A University student can enrol in a course and at least in one major. In fact, a student can enrol in many majors within...

We would like to develop a database that captures the following requirements.

A University student can enrol in a course and at least in one major. In fact, a student can enrol in many majors within that course. During the semesters, a student can enrol in units. We want to capture in which year and in which semester a student enrolled in each unit. We have two semesters: Semester 1 and Semester 2. A unit has a code, a title and the number of credit points. We would like also to record the student’s GPA. A course has a code and a name. A major has a code and a name. Also, a major belongs to a course. A unit can be part of either a course or a major. A unit can also be shared across different courses and different majors.

Important to note:

• Provide your design in a textual form, i.e. Entity(Attribute1, Attribute2,
  Attribute3, …).

• Make sure that the primary keys of each entity are underlined (Attribute1 in the example above) and foreign keys are indictated in bold (Attribute3 in the example above).


• The database should be properly normalised.