Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

Students also viewed these Databases questions