consider a Database System:

A university is developing a database to manage its academic departments, courses, students, and faculty members.

$-$The university has a unique University$\_$ID$,$ a name, and an address.

$-$The university owns several academic departments, each with a unique Dept$\_$ID$,$

name, and head of department.

$-$Each department offers multiple courses, and each course has a unique

Course$\_$ID$,$ title, and is taught by a faculty member.

$-$Each department has many students and faculty members, and a student$/$ faculty

member belongs to one department only.

$-$A faculty member has a unique Faculty$\_$ID$,$ name, email, and works for a

department.

$-$Students are enrolled in courses and have a unique Student$\_$ID$,$ name, and major. $-$Students can take multiple courses, and courses can have multiple students

enrolled.

$-$Faculty members can teach multiple courses.

$1)$ Design an ER diagram for this application, stating any assumptions you make

$($e$.$g$.,$ a faculty member can teach multiple courses$).($Note: In your design, please

consider a general setting that can be commonly observed in our everyday lives. If

you consider a special setting, you need to state your assumptions clearly.$)$

$2)$ Based on your ER diagram, convert it into a relational schema using the mapping

guidelines discussed in the lecture. For each relation $($table$)$ obtained, specify the

name and its attributes, as well as the primary key.