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 MP EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB CODE PROJECT 101 News 102 Senior 03 ArboughJune 04 Ramoras Anne 105 Johnson 106 Smithfield William 07 Alonzo 108 WashingtonRalph 109 Smith 110 Olenko 111 Wabash 112 Smithson 113 Joenbrood Delbert 114 Jones 115 Bawangi Travis 116 Pratt 11/8/00 0:00 7/12/89 0:00 12/1/97 0:00 11/15/88 0:00 21/94 0:00 6/22/05 0:00 10/10/94 0:00 501 Evergreen 105 Amber Wave 04 Rolling Tide 113 501 500 500 501 B 8/22/89 0:00 7/18/99 0:00 12/11/96 0:00 4/4/89 0:00 10/23/95 0:00 11/15/94 0:00 8/20/91 0:00 1/25/90 0:00 3/5/95 0:00 6/19/94 0:00 1/4/06 0:00 505 506 M 508 508 ASSIGNMENT 3/4/14 000 34/14 0:00 3/514 0.00 1 3/5/14 0:00 35/14 0:00 /5/14 0:00 3/5/14 000 3/5/14 0.00 25 3/5/14 0:00 15 36/14 0:00 36/14 0:00 22 36/14 0.00 1 3/6/14 0.00 25 3/6/14 0:00 36/14 0:00 38/14 0:00 36/14 0:00 18 36/14 0.00 1 3/6/14 0.00 37/14 0:00 38/14 0:00 510 WilliamsonAngie 118 Frommer JOB 35.75 96.75 Systems Analyst Database Designer 105 Electrical Engineer 84.5 Mechanical Engineer67.9 Civil Engineer Clerical Support DSS Analyst Applications Designer 48.1 Bio Technician 501 015 505 506 507 55.78 26.87 45.95 509 510 34.55 18.36 . 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

Explanation / Answer

Table name referential integrity reason Employee NO the foreign key Job_code has values =511 that is not present in the JOB table. Project YES emp_num is a foreign key with same values as in table employee Assignment YES both proj_num and emp_num are foreign keys that have same values in tables Porject and employee respectively. Job code NA NA

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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