solving; 2) total time needed: 2 to 3 hours AFTER studies. 1. a. Create ONE E-R diagram for a college, modeling the relationships among DEPARTMENT (Use DEPT for entity name), FACULTY, COURSE, and STUDENT: Please note some Min/Max have specific numbers DEPT has at least four FACULTY members; each faculty member only works for one department; b. DEPT has at least 10 COURSES; a course only belongs to a department; C. A faculty member can be assigned to teach up to four courses, but may not work in the current semester ("on sabbatical leave"); each course may be taught by at least one and up to three faculty members; d. A course may be enrolled by at least 20, up to 50 STUDENTs; a student may be enrolled in not more than 5 courses, but may be enrolled in no course for the current semester. In the E-R diagram, please include the following attributes for the entities involved: DEPT: DeptName, Chair; COURSE: C-ID, Title; STUDENT: S-ID, Major FACULTY: F-ID, Rank. Add proper foreign key(s) as the relationship(s) necessitate(s)