Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

WORKS_ON ... Essn Pno Hours PROJECT 123456789 1 32.5 Pname Pnumber Plocation Dnum 123456789 2 7.5 1 Bellaire 5 666884444 3 40.0 ProductX ProductY 2

image text in transcribed

WORKS_ON ... Essn Pno Hours PROJECT 123456789 1 32.5 Pname Pnumber Plocation Dnum 123456789 2 7.5 1 Bellaire 5 666884444 3 40.0 ProductX ProductY 2 5 453453453 1 20.0 Sugarland Houston 453453453 2 20.0 Productz 3 5 333445555 2 10.0 10 Stafford 4 333445555 3 10.0 Computerization Reorganization Newbenefits 20 Houston 1 333445555 10 10.0 30 Stafford 4 333445555 20 10.0 999887777 30 30.0 EMPLOYEE Fname Minit Dno John B 5 Franklin T Alicia J 4 Jennifer S Lname Ssn Bdate Address Sex Salary Super_ssn Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 4 ||0 K Ramesh Joyce Ahmad 5 A 5 V 4 James E 1 1. Make query of all employees working project 5. 2. Make query of all projects belonging to department number 5. 3. delete the table project

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

Oracle Database 10g Insider Solutions

Authors: Arun R. Kumar, John Kanagaraj, Richard Stroupe

1st Edition

0672327910, 978-0672327919

More Books

Students also viewed these Databases questions