Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please identify the keys (primary key, candidate key, super key, unique key, foreign key) for each category. I rate if its the answer

Can someone please identify the keys (primary key, candidate key, super key, unique key, foreign key) for each category. I rate if its the answer im looking for. Thank you. image text in transcribed
EMPLOYEE Frame Minit Lame Son Bdate Address Sex Salary Super_san Ono John B Smith 1234567891065-01-09 731 Fonden, Houston, TX M 30000 333445555 5 Franklin T Wong 333445558 1955-12-08 638 Voss, Houlton, TX M 40000 888665555 5 Alicia J Zelaya 999887777 1966-01-10 3321 Castle, Spring, TX F 25000 9876543214 Jennifer S Wallace 9876543211941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445556 5 Joyce A English 453453453 1972-07-31 5631 Rica, Houston, TXF 25000 3334455555 Ahmad V Jabbar 087987987 1980-03-29 980 Dallas, Houston, TXM 25000 987654321 4 James E Borg 888665555 1937-11-10 450 Stone, Houston, TXM 55000 NULL DEPARTMENT Dname Research Administration Headquarters Dnumber 5 4 1 Mgr son 333445555 987654321 888665555 DEPT_LOCATIONS Mgr_start_date Dnumber Dlocation 1988-05-22 Houston 1995-01-01 Stafford 1981-06-19 Bellaire Sugarland Houston PROJECT Pname Pnumber Plocation Dnum ProductX 1 Bellaire 5 ProductY2 Sugarland Productz 3 Houston Computerization 10 Stafford Reorganization 20 Houston Newbenefits 30 Stafford 67892 Hours 32.5 7.5 40.0 20.0 20.0 2 10.0 WORKS ON Essn Pro 123456789 1 123456789 6668844443 4534534531 453453453 2 333445555 333445555 3 333445555 10 333445555 999887777 999887777 10 987987987 987987987 987654321 30 987654321 20 888665555 20 DEPENDENT 10.0 10.0 10.0 30.0 20 Essn Sex 30 10.0 10 Dependent_name Alice Theodore Joy Abner Michael Alice Elizabeth 333445555 333445555 333445555 987654321 123456789 123456789 123456789 35.0 5.0 20.0 15.0 NULL 30 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter 1967-05-05 Spouse M M F F

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

Case Studies In Business Data Bases

Authors: James Bradley

1st Edition

0030141346, 978-0030141348

More Books

Students also viewed these Databases questions

Question

1. Briefly describe the five components of emotions.

Answered: 1 week ago