Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EMPLOYEE DEPARTMENT DEPT _ LOCATIONSWORKS _ ON table [ [ Essn , Pno,Hours ] , [ 1 2 3 4 5 6 7 8

EMPLOYEE
DEPARTMENT
DEPT_LOCATIONSWORKS_ON
\table[[Essn,Pno,Hours],[123456789,1,32.5],[123456789,2,7.5],[666884444,3,40.0],[453453453,1,20.0],[453453453,2,20.0],[333445555,2,10.0],[333445555,3,10.0],[333445555,10,10.0],[333445555,20,10.0],[999887777,30,30.0],[999887777,10,10.0],[987987987,10,35.0],[987987987,30,5.0],[987654321,30,20.0],[987654321,20,15.0],[888665555,20,NULL]]
PROJECT
\table[[Pname,Pnumber,Plocation,Dnum],[ProductX,1,Bellaire,5],[ProductY,2,Sugarland,5],[ProductZ,3,Houston,5],[Computerization,10,Stafford,4],[Reorganization,20,Houston,1],[Newbenefits,30,Stafford,4]]
DEPENDENT
\table[[Essn,Dependent_name,Sex,Bdate,Relationship],[333445555,Alice,F,1986-04-05,Daughter],[333445555,Theodore,M,1983-10-25,Son],[333445555,Joy,F,1958-05-03,Spouse],[987654321,Abner,M,1942-02-28,Spouse],[123456789,Michael,M,1988-01-04,Son],[123456789,Alice,F,1988-12-30,Daughter],[123456789,Elizabeth,F,1967-05-05,Spouse]]
image text in transcribed

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

Deductive And Object Oriented Databases Second International Conference Dood 91 Munich Germany December 18 1991 Proceedings Lncs 566

Authors: Claude Delobel ,Michael Kifer ,Yoshifumi Masunaga

1st Edition

3540550151, 978-3540550150

More Books

Students also viewed these Databases questions

Question

Show that if e N 0, I n2 and H0H I n then u H0e N 0, I n2 .

Answered: 1 week ago