Student Database Management

A college contains many departments and each department can offer any number of courses.

Many instructors work in the department, but instructors can work only in one department.

Each instructor can take any number of courses and a course can be taken by only one instructor.

Students can enroll in any number of courses. However, there is a limit on how many credits a student can take. ERD for the given scenario