E-R Model
Design an Entity Relationship (ER) model for a University database. Let’s assume that we have the following conditions:
1. A college contains many departments
2. Each department can offer any number of courses
3. Many instructors can work in a department
4. An instructor can work only in one department
5. For each department there is a Head
6. An instructor can be head of only one department
7. Each instructor can take any number of courses
8. A course can be taken by only one instructor
9. A student can enroll for any number of courses
10.Each course can have any number of students
Use the following steps:
Step 1 : Identify the Entities
Step 2 : Identify the relationships Step 3: Identify the key attributes
Step 4: Identify other relevant attributes (whenever possible)
By connecting all these details, draw the ER diagram. Submit ER Diagram
