Given the following data 1. give the relationship/ internal relation for each ta

Question

Given the following data

1. give the relationship/ internal relation for each table(one to another) so when the database is populated with the following information it can be retrived correctly. Also show any keys (primary, composite, foreign,etc).

EMPLOYEE FNAME MINIT LNAME SSN SEX SALARYSUPERSSN DNO BDATE 123456789 1965 01-09 333445555 1955-12-08 Zelaya999887777 1968-01-19 Walace 987654321 1941-06-20 Narayan 666884444 1962-09-15 453453453 1972-07-31 Jabbar 9879879871969-03-29 888665555 1937-11-10 ADDRESS 731 Fondren, Houston, TX 638 Voss, Houston, TX 3321 Castle, Spring, TX 291 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dalas, Houston, TX 450 Stone, Houston, TX Franklin Alicia 333445555 888665555 997654321 5 5 enniter Bellaire, TX Ramesh 3334455555 987654321 4 Ahmad E Borg 55000 DEPT LOCATIONS DNUMBE Stafford DEPARTMENT DNUMBER MGRSSN 333445555 987654321 888665555 DNAME 5 1995-01-01 1981-06-19 Administration Headquarters

Explanation / Answer

EMPLOYEE:
PRIMARY KEY = SSN

DEPARTMENT:
PRIMARY KEY = DNUMBER

DEPT_LOCATIONS:
FOREGIN KEY = DNUMBER

PROJECT:
PRIMARY KEY = PNUMBER

WORKS_ON:
FOREGIN KEY = PNO

DEPENDENT:
COMPOSITE KEY= ESSN+DEPENDENT_NAME

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

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