Database Question Based on the given database, answer the following questions EM
ID: 3876947 • Letter: D
Question
Database Question Based on the given database, answer the following questions EMPLOYEE PROJECT 101 News 102 Senior 03 ArboughJune 104 Ramoras Anne 105 Johnson 106 Smithfield Willam 107 Alonzo 108 Washington Ralph 109 Smith 11/8/00 0:00 7/12/69 0:00 121/97 000 11/15/88 0:00 2/1/94 0:00 6/22/05 0:00 1010/94 0:00 501 Evergreen Amber Wave 10 Rolling Tide 113 502 8 8/22/89 0:00 511 0 Olenko 111 Wabash 112 SmithsonDarlene 113 Joenbrood Delbert 114 Jones 115 Bawang Travis 116 Pratt 17 WilliamsonAngie 118 Frommer 7/18/99 0:00 2/11/96 0:00 4/4/89 0:00 102395 0:00 11/15/94 0:00 8/20/91 0:00 1/25/90 0:00 3/5/95 0:00 ASSIGNMENT 511 510 2.6 34/14 0100 4/1400 514 000 514 000 5/14 000 514 000 2 3514 000 35/14 000 25 35/14 000 19/94 0000 14/06 0:00 3.6 25 510 113 JOB 101 35.75 96.75 38 14 000 614 000 314 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 55.78 28.87 45.95 36/14 000 6/14000 614 000 14 0.00 112 34.55 18.36 2.7 42 510 814 000 For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None Do the tables exhibit entity integrity? Answer yes or no, and then explain your answerExplanation / Answer
Primary Key : It uniquely identifies each record in a table.
Foreign Key : It refers to the primary key of another table.Simply links to tables.
1st Question :
EMPLOYEE Table : EMP_NUM (PRIMARY KEY) uniquely identifies every EMPLOYEE and refers to the JOB_CODE (FOREIGN KEY ) of JOB table.
JOB Table : JOB_CODE(PRIMARY KEY) uniquely identifies every job in JOB table.It not refers to any table's PRIMARY KEY so it's FOREIGN KEY is None
PROJECT Table : PROJ_NUM(PRIMARY KEY) uniquely identifies every project in PROJECT table and refers to the EMP_NUM (FOREIGN KEY ) of EMPLOYEE table.
ASSIGNMENT Table : ASSIGN_NUM(PRIMARY KEY) uniquely identifies every assignment in PROJECT table and refers to the EMP_NUM (FOREIGN KEY ) of EMPLOYEE table and PROJ_NUM(FOREIGN KEY ) of PROJECT table.
2nd Question
Answer : Yes
In Entity Integrity no PRIMARY KEY is allowed to null and PRIMARY KEY is unique for every row.
Tables exhibit entity integrity because all the records can be distinguished from each other no record is duplicated.
Table Name Primary Key Foreign Key EMPLOYEE EMP_NUM JOB_CODE JOB JOB_CODE None PROJECT PROJ_NUM EMP_NUM ASSIGNMENT ASSIGN_NUM PROJ_NUM, EMP_NUMRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.