Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following figure. Select what is true EMPLOYEE PK EMP NUM DEPENDENT PK.FK1 EMP NUM PK DPNT NUM EMP LNAME EMP_FNAME EMP INITIAL EMP_HIRE_DATE
Consider the following figure. Select what is true EMPLOYEE PK EMP NUM DEPENDENT PK.FK1 EMP NUM PK DPNT NUM EMP LNAME EMP_FNAME EMP INITIAL EMP_HIRE_DATE EMP TYPE DPNT FNAM DPNT LNAME DPNT_RELATION Disjoint verlapping constraint (dio) Partial Complete constraint Category symbol EMP_TYPE "P" "M" "A" MECHANIC PKFK1 EMP NUM PILOT PK,FK1 EMP NUM PL LICENSE PIL_RATINGS PIL MED TYPE ACCOUNTANT PK,FK1EMP NUM ACT_TITLE ACT_CPA_DATE MEC TITLE MEC CERT W EMPOYEE is a Subtype EMPLOYEE is a Supertype EMP_TYPE is NOT the Subtype Discriminator There is a disjoint constraint There is an overlapping constraint There is a complete constraint There is a partial constraint Employee is a one to many relationship with Pilot, Mechanic, and Accountant Employee is a one to one relationship with Pilot, Employee, and Accountant The figure depicts an ERD This figure depicts a Specialization Heirarchy/EERD
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