Question

(1) Design an Entity-Relationship diagram that models this scenario and takes into account the requirements listed above. That means that you have to identify suitable entity sets, relationship sets, attributes, keys of entity sets (if not specified), and so on. Further add the cardinalities (1:1, 1:m, m:1, m:n) to the relationship sets.

Consider the following requirements about a department management system:

● A user has an email address which is unique, name, date of birth, current address, and age. Age is a derived attribute.

● There are two types of users: students and professors.

● Graduate students are students and have an SSN.

● A professor has a title, tenure status, and an SSN.

● A hometown where users were born has a city name and a state name.

● Graduate students are advised by a professor.

● Students enroll in courses that have a title, a description, year, semester, and credits.

● A professor teaches courses, and an evaluation form is created.

● Students and professors belong to a department that has a unique department ID, name, and office address. The address includes street, city, state, and zip code.

Answer 1