In this project, you will be designing and implementing a database for a business college. The college has several departments, and each department offers various programs. A program offers many courses, where some of these courses are required and some are elective. Some courses have no prerequisites, while others have one more prerequisites . Students may declare more than one major and more than one minor by choosing their desired programs However, each student must declare at least one major , but not all students may double major or declare minors A course has a certain number of credit units and may be offered every semester or in certain semesters. When offereda course can have multiple sections. Students can take any of the offered sections of a course . If student does not pass a course , they have to take it again in a future semester . Students can graduate when they pass 120 credits from the list of approved courses . The classrooms where courses offered are located in a university building The academic status of a student determined by the number of credits they have passed . For example , a student may be a Junior terms of when she was admitted to the university but may be a sophomore academically . Generally , below 30 credits considered freshman ', below 60 credits a'sophomore , below 90 is a , and beyond that is considered Broadly , the college has two group of employees : Professors and Staff Professors are affiliated with a department , and each department has a chair who is one of the professors working for the department . professor may offer zero to five courses every semester . on the other hand , could be advisors of a program (which are offered by departments ), could be departmental support (affiliated with a department ), or administrative support (with an assigned unit) All employees and students are glven a unique ID and an email address by the university upon their employment or registration . Usual demographic Information is also collected from them name , address , date of birth, etc. ). Information on dependents of employees is also collected ( for benefits )

Design and implement an ERD model for the above scenario please