Question $1$: Create an Enhanced Entity$-$Relationship $($EER$)$

Diagram

$(35$ Points$)$

Using the following case, draw an Enhanced Entity$-$Relationship

$($EER$)$ Diagram:

Case Overview: A university wants to implement a system to manage students, courses, instructors, and enrollments. The system needs to store detailed information about each of these entities and their relationships. The requirements are as follows:

You are tasked with designing an Enhanced Entity$-$Relationship $($EER$)$ Diagram for a university system to manage students, courses, instructors, and enrollments. The requirements are as follows:

Entities and Relationships:

Each student has a unique Student ID $($simple identifier$),$ along with their name, email, phone number, and a composite attribute for address $($including street, city, and postal code$).$

A course has a unique Course Code and a composite identifier made up of the Course Code and Semester.

An instructor has a unique Instructor ID $($simple identifier$),$ name, email, and phone number. The total years of service for an instructor is a derived attribute.

Each department has a Department ID $($simple identifier$),$ a name, and multivalued attributes for contact numbers.

A student enrolls in multiple courses, and each course can have multiple students. The system tracks the enrollment date and final grade. The enrollment entity is an associative entity connecting students and courses.

Some courses have a prerequisite relationship with other courses. This represents a unary relationship.

A department offers multiple courses and is managed by a department head.

There is a generalization and specialization hierarchy for courses, with subtypes for Theory$-$based Courses and Practicalbased Courses.

Constraints and Special Rules:

Use a total specialization rule if all courses fall under either theory$-$based or practical$-$based categories.

Use a disjoint rule to indicate that a course can only be either theory$-$based or practical$-$based, not both.

Weak Entities:

Include at least one weak entity, such as Scholarship, that is associated with a student.

Task Instructions:

Clearly depict each entity type, its attributes, and its identifier$($s$).$ You must include at least $3$ simple identifiers and $1$ composite identifier.

Ensure that your diagram includes at least $1$ composite attribute, $1$ multivalued attribute, and $1$ derived attribute.

Indicate the cardinalities for each relationship between entities. Include at least $1$ unary relationship and $3$ binary relationships. $($Bonus: Include a ternary relationship if applicable$).$ How to solve