Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. Create a new table structure named dept_Locations with dept_no and location fields. You also have to put primary and foreign key constraints so that

image text in transcribed

8. Create a new table structure named dept_Locations with dept_no and location fields. You also have to put primary and foreign key constraints so that this table is connected to department table.

MSU Cergeration Databne St. Louis MO 63121 0000 542 M 999444444 99222222AminHyder Saside MarinaCA 9941 999555555 999444444 M |71900666666 03-29 2000422M Collinsville IL 66234 015 3800 332M 1975 43000 99444444 hu huWaiman Lindber SL Louis MO 63121 43000 3 62025 14 MontereyCA 93940 IL 6202s 5000 25000 402 25000 26F 999887777 Markis Marcia 1999555555 999888888 Prescl Shem 999444444 Project Pro Number Pro Name Location St. Louis Marina Collinsville 7 Edwardsville 1 Dept No Order Personnel Receivables Edwardsville7 Pay Benefits Marina 30 EMP SSN Dep Name Gender Date of Birth Relationship 9991111 Deanna 991 Jeff 1978-12-3 DAUGHTER 1978-01-01 SON 1957-05-05 SPOUSE 1998-10-25 SON 1996-04-05 DAUGHTER 1975-05-03 SPOUSE 1968-02-29 SPOUSE Ellen F 999444444 Jo Ellen 999555555 Allen

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_2

Step: 3

blur-text-image_3

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

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

What has been the evolution of HRM?

Answered: 1 week ago