Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE DONT USE steps solve normal Question 38 10 Points .. Pro WORKS ON Essn 123456789 123456789 666884444 1 Hours 32.5 7.5 2 3 40.0

PLEASE DONT USE steps solve normal

image text in transcribed

Question 38 10 Points .. Pro WORKS ON Essn 123456789 123456789 666884444 1 Hours 32.5 7.5 2 3 40.0 1 453453453 453453453 333445555 PROJECT Pname ProductX ProductY Productz Computerization Reorganization Newbenefits Dnum 5 5 5 20.0 20.0 Pnumber 1 2 3 10 20 30 2 Plocation Bellaire Sugarland Houston Stafford Houston Stafford 2 10.0 4 3 10.0 1 10 10.0 333445555 333445555 333445555 999887777 4 20 10.0 30 30.0 EMPLOYEE Fname Minit Lname San Bdate Address Sex Salary Super_ssn Dno John B Smith 123456789 1965-01-09 731 Fondren. Houston, TX M 30000 333445555 Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 Joyce English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Ahmad Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL Ano 4 4 5 5 5 m 4 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. Use the editor to format 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

Modern Database Management

Authors: Fred R. McFadden, Jeffrey Slater, Mary B. Prescott

5th Edition

0805360549, 978-0805360547

More Books

Students also viewed these Databases questions