Database Question Based on the given database, answer the following questions EM

Question

Database Question Based on the given database, answer the following questions EMPLOYEE EM.LNAME EMP ENAME EMP-INITIAL ga cooE EMp HIREDATE 11/8/00 0:00 7/1289 0:00 12/1/97 0:00 11/15/88 0:00 2/1/94 0:00 622/05 0:00 10/10/94 0:00 PROJECT 101 News 102 Senior 03 ArboughJune 104 Ramoras Anne 105 Johnson 106 Smithfield Williamm 07 Alonzo 108 Washington Ralph 109 Smith 110 Olenko 111 Wabash 112 Smithson Darlene 113 Joenbrood Delbert 114 Jones 115 Bawang Travis 116 Pratt 17 WilliamsonAngie 118 Frommer 501 503 Evergreen105 Amber Wave Roling Tide 113 8 8/22/89 0:00 501 511 7/18/99 0:00 2/1196 0:00 4/4/89 0:00 10/2395 0:00 11/15/94 0:00 8/20/91 0:00 1/25/90 000 3/5/95 0:00 ASSIGNMENT 511 510 26 34/14 000 34 40:00 19/94 0:00 114/06 0:00 510 113 25 5/14 000 5/14 000 14 000 25 5/14 000 3S/14 000 25 1.7 35.75 96.75 5/14 000 14 000 14 000 Systems Analyst Database Designer 105 Electrical Engineer 84.5 Mechanical Engineer 67.9 Civil Engineer Clerical Support DSS Analyst Applications Designer 48.1 Bio Technician 26 36/14 0:00 5 3614 000 25 3614 000 55.78 25.87 45.95 112 14 000 14 0:00 /14 0008 316/14 0:00 15 34.55 18.36 3/7114 000 814 000 27 42 510 Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key Describe the type(s) of relationship(s) between EMPLOYEE and JOB

Explanation / Answer

From the given tables it is clear that

EMPLOYEE table has a primary key EMP_NUM

JOB table has a primary key JOB_CODE

ASSIGNMENT table has primary key ASSIGN_NUM

PROJECT table has primary key PROJ_NUM

There is a referential integrity exists between EMPLOYEE table and project table

There is a referential integrity exists between EMPLOYEE table and ASSIGNMENT table

There is a referential integrity exists between EMPLOYEE tale and JOB table

There is no relationship between JOB table and PROJECT table

We cannot define the relationship between PROJECT and ASSIGNMENT as some PROJ_NUM pointing to different EMP_NUM values..

There exists a foreigh key relation ship between EMPLOYEE table and PROJECT table

In PROJECT table EMP_NUM is a normal attribute but EMP_NUM in EMPLOYEE table is primary key

i.e., EMP_NUM in PROJECT table is Foregin key referencing Primary key EMP_NUM in EMPLOYEE table

There exists a foreign key relation ship between EMPLOYEE table and ASSIGNMENT table

In ASSIGNMENT table EMP_NUM is a normal attribute but EMP_NUM in EMPLOYEE table is Primary key

i.e., EMP_NUM in ASSIGNMENT table is Foregin key referencing Primary key EMP_NUM in EMPLOYEE table

There exists a foreign key relation ship between EMPLOYEE table and JOB table

In EMPLOYEE table JOB_CODE is a normal attribute but JOB_CODE is a Primary key in JOB table

i.e., JOB_CODE in EMPLOYEE table is a Foreign key referening Primary key JOB_CODE in JOB table.

In EMPLOYEE table JOB_CODE is a Foreign key which referencing a Primary key JOB_CODE in JOB table

So there is a foreign key relationship between EMPLOYEE table and JOB table

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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