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. 2 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 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.
2
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
Meaning of Entity Relationship Diagram (ER):-
It is a type of graphical technique which is used to frame and illustrate data modeling with entities relationships and their information system. ERD is used to represent framework of infrastructure with the help of conceptual modelling of data.
The elements of Entity-Relationship Diagram are as follows:-
- Attributes
- Entities
- Relationships
The steps for creating an Entity-Relationship Diagram are as follows:-
- Explaining and pinpointing the entities
- Regulating the interconnections between the entities
- Inspecting the nature of the interconnections or regulating the number of relationships.
- Generating the ERD or Entity-relationship diagram
Step by step
Solved in 2 steps with 1 images
