Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the chart, please answer question 3 Figure 3.6 One possible database state for the COMPANY relational database schema EMPLOYEE Frame MinitLname Bdate Addrens Sex

image text in transcribed
image text in transcribedUsing the chart, please answer question 3
Figure 3.6 One possible database state for the COMPANY relational database schema EMPLOYEE Frame MinitLname Bdate Addrens Sex Salary Supe.son Dno Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 FrarklinT Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 Zobys 999897777 1968-01-10 3321 Caste Spring TXF 25000 Jennifer S Walace 987654321 1941-06-20 201 Berry, Bellaire, TX F 43000 8886655554 Ramesh K Narayan 668884444 1962-09-15 975 Fire Oak, Humbie, TX M 38000 333445555 5 Ahmad V labbar ?87087987 1960-03-29 | 980 Dilas, Houston, TX | M 25000 ames E Borg 888665555 1937-11-10 450 Stone, Houston, TX M55000 NULL DEPARTMENT A Engish 453463453 1972-07-31 5631 Rice,Houstion, TX F 25000 333445565 DEPT LOCATIONS Dname 333445555 1968-06-22 1995-01-01 1991-06-10 98765432 Bellaire WORKS ON Hees Essn 325 75 400 200 200 100 10.0 10 10.0 123456789 Productz Nowbenefits 30 Staford 33445555 20 Sex 0998877 30 300 10 10.0 10 35.0 5.0 987654321 30 20.0 987654321 20 15.0 888665555 20 NULL 333445656 Aloe F 1986-04-05 Daughter M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spoute 087654321 Abner 23456789 Michae 123456789 Ace 23456789 Elizabeth M 198801-04 Son F 1988-12-30 Daughter F 1967-05-06 Spouse

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

Professional SQL Server 2012 Internals And Troubleshooting

Authors: Christian Bolton, Justin Langford

1st Edition

1118177657, 9781118177655

More Books

Students also viewed these Databases questions

Question

Be familiar with the five basic ways to manage demand.

Answered: 1 week ago