Question: Please read the ER diagram and answer the questions below: 1. Is it possible for a person to be both an employee and a student?

Please read the ER diagram and answer the

Please read the ER diagram and answer the

Please read the ER diagram and answer the questions below: 1. Is it possible for a person to be both an employee and a student? Why or why not? 2. Can you envision what the Person's subtype discriminator would be? 3. Is it possible for an employee to be something other than Faculty or Staff? Why or why not? 4. Is it possible for an employee to be both faculty and staff? 5. Is it possible for a staff member to also be a graduate student? 6. Is it possible for someone to have more than one degree from this university? Please use LucidChart to draw the supertype/subtype relation for Person entity type. Person has two three attributes: ID (Primary Key), Name, Phone A Person can be either Employee or Student or both. There is no other entity type available other than Employee and Student Employee entity type has an attribute which is Employ_Date Student entity type has an attribute which Major Employee can be an Administrator, a Faculty, both or something else which is not listed here. Student can only be either Graduate or Undergraduate. There is no other entity type available other than Graduate or Undergraduate. Administrator has an attribute Admin_Title Faculty has an attribute Prof_Rank Graduate has an attribute Grad_Thesis Undergraduate has an attribute Crds_Hrs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!