Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started