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 or more prerequisitesStudents 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 certain semestersWhen offered a course can have multiple sections. Students can take any of the offered sections of a courseIf a student does not pass a course, they have to take it again in a future semester Students can graduate when they pass 220 credits from the list of approved coursesThe classrooms where courses are offered are located in a university building The academic status of a student is determined by the number of credits they have passed. For example, a student may be a junior in terms of when s /he was admitted to the university, but may be a sophomore academically . Generally, below 30 credits is considered 'freshman' below Broadly , the college has two group of employees : Professors and StatlProfessors are affiliated with a department , and each department has a chair who is one of the professors working for the department . A 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 given a unique !D and an email address the university upon their employment or registration . Usual demographic information is also collected from them , full name , address , date of birth, etc. )Information on dependents of employees is also collected (for benefits ). Design and implement an ERD for the scenario.