Question: Write/Run SQL queries for the following use cases a) A new person whose name is Joshua T Miller has been hired. Add this new employed

Write/Run SQL queries for the following use cases

a) A new person whose name is Joshua T Miller has been hired. Add this new employed person to the system along with his following information:

SSN: 456363313

birth date: 1971-10-18

address: 98 Oak Forest, Katy, TX

salary: 37000

superssn: 456363313

dno: 4

b)Joshuas salary has been increased with 10%. Make the required update.

c)Joshua left the company after working 3 years. Delete his personal record from the system.

d)Make a list of all project numbers and project names for projects that involve an employee whose last name is 'Smith', either as a worker or as a manager of the department that controls the project.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

70 pts] Write/Run SQL queries for the following use cases (no screenshots of these queries and their input/output needed). a. [5 pts] Retrieve the name and salary of all employees. b. [5 pts]...

Write/Run SQL queries for the following use cases. 1)List all name of employees, the projects that they have been working on, and the amount of time they spent for those projects. 2) Retrieve all...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

The International Journal of Human Resource Management 10:3 June 1999 488 500 The coffee-machine system: how international selection really works Hilary Harris and Chris Brewster Abstract The...

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

Introduction Welcome to the final project for CS504 Principles of Data Management and Mining. This project aims to test your understanding of the concepts covered throughout the course, such as...

Alexandres Steel Parts produces parts for the automobile industry. The company has monthly fixed expenses of $620,000 and a contribution margin of 90% of revenues. Requirements 1. Compute Alexandres...

NNS Hospitals Ltd. is a publicly owned company that owns a chain of hospitals. The Balance Sheet of NNS as of 31/3/2015 is given below: Liabilities and Owners Equity Accounts Payable 120,000 Salaries...

What does an audit memo look like to an audit committee chair on an upcoming audit that inovles completing the audit involving accounting estimates ISA 5 4 0 , AU 3 4 2 ?

please help with number 9 and 10 SUMMARY PROBLEM 2 Fashion Fabrics makes custom handbags and accessories for high-end clothing boutiques. Re- cord summary journal entries for each of the following...