Consider a school system in which data is recorded about the movie industry. The data requirements are summarized as follows: Each subject is owned by a department and each department is managed by a teacher, called Head of Department (HOD). Each department has a name and a unique code number. Each subject has a name, unique number and credit value. All teachers have a unique ID. A HOD cannot manage more than one department at a time. Also, a HOD does not teach subjects. A subject cannot be taught by more than one teacher. Finally, the system needs to know each student’s contact details, including, full name, student ID, address, age and gender, as well as date of enrolment in the subject. Design an Entity-Relationship diagram for the movie database
Consider a school system in which data is recorded about the movie industry. The data requirements are summarized as follows:
Each subject is owned by a department and each department is
managed by a teacher, called Head of Department (HOD). Each
department has a name and a unique code number. Each subject
has a name, unique number and credit value. All teachers have a
unique ID. A HOD cannot manage more than one department at a
time. Also, a HOD does not teach subjects. A subject cannot be
taught by more than one teacher. Finally, the system needs to
know each student’s contact details, including, full name, student
ID, address, age and gender, as well as date of enrolment in the
subject.
Design an Entity-Relationship diagram for the movie
Step by step
Solved in 3 steps with 3 images