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.$)[25$

marks$]$

$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. $[25$ marks$]$