In-Class Exercises-EERs-completed
docx
keyboard_arrow_up
School
Iowa State University *
*We aren’t endorsed by this school
Course
533
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
docx
Pages
5
Uploaded by JudgeFrogPerson938
EER Exercises 1
Complete the above EER by adding the subtype discriminators and answer the following questions.
Question: Note here that a person must be either an employee, alumnus, or student. Is it possible for a person to be both an employee and a student? Why or why not?
A.
Yes, Overlap
Question: is it possible for an employee to be something other than Faculty or Staff? Why or why not?
A.
Yes, Partial Specialization
Question: is it possible for an employee to be both faculty and staff?
A.
No, Disjoint rule
Question: is it possible for a staff member to also be a graduate student?
A.
Yes, Overlap rule
Question: is it possible for someone to have more than one degree from this university?
A.
Yes
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
EER Exercises 2
Draw an EER diagram with correct subtypes for each of the following problems.
A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City/State/Zip, and Telephone (if the person has one). Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and volunteers have a list of Skills. Donors have only a relationship (named donates) with an Item entity type. A donor must have donated one or more items, and an item may have no donors, or one or more donors. There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more of these groups.