Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

0805302441, 978-0805302448

More Books

Students also viewed these Databases questions

Question

3. Is there opportunity to improve current circumstances? How so?

Answered: 1 week ago

Question

2. What do you believe is at the root of the problem?

Answered: 1 week ago