[4] Please find all the candidate keys. [5] Choose a primary key for above table

Question

[4] Please find all the candidate keys.

[5] Choose a primary key for above table.

[6] Find all the functional dependencies. And identify the dependency type (i.e. primary key, partial, or transitive)

(Employee Project Department table) DNAME Research Research Researchh Research SSN FNAME LNAME PN DNUMBER 333445555FranklinWong 333445555FranklinWong 333445555Franklin Wong 333445555 FranklinWong 987654321 JenniferWallace 987654321 JenniferWallace 888665555 James 10 20 30 20 20 Pnamne ProductY Product Z Computerization Reorganizatiorn New Benefits Administration Reorganization Administration ReorganizationHeadquarters 4 4 Borg

Explanation / Answer

1) Please find all the Candidate Keys: This table does not have any direct candidate keys. However we can use a combination on columns to identify the candidate key:- SSN,FNAME,LNAME

2) Choose a primary key for the above table: The table does not have a primary key by itself. We will have to create a new column and define that column as the primary key. Eg. EPD_ID (employee project department id)

3) Functional Dependencies:

i could fine 3 functional dependencies -

SSN -> FNAME and LNAME

PNO ->Pname

DNUMBER -> DNAME

all these are transitive dependencies.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.