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.