Description

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