6. Please draw an ER Diagram for a University described below: (50 pts)

a. The university has multiple Departments. The attributes of Departments include Department ID and Department Name.

b. The university has employees who are divided into 3 categories: Faculty, Staff, and Administrator. An employee must be assigned to one and only one of these categories. All employees have Employee IDs and Names. Faculty members have an Academic Title attribute. Staff has a PartTime_or_FullTime attribute. And Administrators have a Position attribute.

c. All faculty members work in one and only one department.

d. A department is always managed by a department chair who is a faculty member works in that department.

e. The university offers multiple Courses. Each Course has its own ID and Name.

f. Each course must be taught by one or more Faculty members. Each Faculty member may or may not be teaching courses. And when they do, they may teach multiple courses.