Scribd
Upload
11 views2 pages

University Database ERD and Relationships

The document outlines the hierarchical structure of a university, detailing the relationships between various entities such as Faculties, Schools, Programs, Courses, Lecturers, and Students. It specifies that a university has multiple faculties, each divided into schools that offer programs containing courses. Additionally, it describes the enrollment relationships between students and programs, as well as the teaching relationships between lecturers and courses.

Uploaded by

Keketso Qhomane
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views2 pages

University Database ERD and Relationships

The document outlines the hierarchical structure of a university, detailing the relationships between various entities such as Faculties, Schools, Programs, Courses, Lecturers, and Students. It specifies that a university has multiple faculties, each divided into schools that offer programs containing courses. Additionally, it describes the enrollment relationships between students and programs, as well as the teaching relationships between lecturers and courses.

Uploaded by

Keketso Qhomane
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

In class, read the following business rules, then answer the following questions:

• A University contains many Faculties.


• The Faculties in turn are divided into several Schools.
• Each School offers numerous programs and each program contains many courses.
• Lecturers can teach many different courses and even the same course numerous times.
• Courses can also be taught by many lecturers.
• A student is enrolled in only one program but a program can contain many students.
• Students can be enrolled in many courses at the same time and the courses have many students
enrolled.

Question 1. Identify all the tables/entities.

Question 2.1. Find the relationships:

Page 1 of 2
Homework – Individual submission

Question 2.2. Identify the cardinality of the different relationships (1:1; 1:M; M:M).

Question 3. Draw the rough ERD below, both in Crow’s Foot and UML notation.

Page 2 of 2

You might also like