Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[20 points] Question 1: Draw an EER diagram for the UNIVERSITY database with the following design requirements: - There are three types of persons: employees,
[20 points] Question 1: Draw an EER diagram for the UNIVERSITY database with the following design requirements: - There are three types of persons: employees, alumni, and students. A person can belong to one, two, or all three of these types. - Each person has a name, SIN, gender, address, and birth date. Every employee has a salary. Each alumnus has a record of the degree or degrees that they earned at the university. Each student has a major department. - There are three types of employees: faculty, staff, and student assistants. Each employee belongs to exactly one of these types. - Students are further classified as either graduate or undergraduate. Each student belongs to exactly one of these types. [10 points] Question 2: For the given EER diagram- - List all is-a relationships. - List all super classes. - List all subclasses. - List all attributes of FACULTY. - List all local attributes of STUDENT
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started