Create the Entity Relationship (ER) Diagram for the following scenario. We want to maintain a database for a Faculty within a multi-campus regional university. The faculty has a number of schools and each school is characterized by its school-code which is unique, name and campus location. Schools employ professors who are characterized by their unique staff-id, name and the school they work for. A school offers courses that are characterized by their course-code which is unique, course name and the school. There are subjects offered within the faculty and these are characterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id which is unique, name, address and phone. The following business rules apply • A course must belong to only one school, but a school may have many courses • A student must be enrolled in a course, but a course may have 0 or more students • A course must have one or more subjects, but a subject may be taught as part of many courses • A student may be enrolled in many subjects, and a subject may have many students enrolled in it • A subject must be taught by a professor, and a processor may teach many subjects • A professor is employed by only one school, and a school may employ many professors
Create the Entity Relationship (ER) Diagram for the following scenario.
We want to maintain a
characterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id which is unique, name, address and phone.
The following business rules apply
• A course must belong to only one school, but a school may have many courses
• A student must be enrolled in a course, but a course may have 0 or more students
• A course must have one or more subjects, but a subject may be taught as part of many courses
• A student may be enrolled in many subjects, and a subject may have many students enrolled in it
• A subject must be taught by a professor, and a processor may teach many subjects
• A professor is employed by only one school, and a school may employ many professors
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
