Question: Create tables for following relations and insert tuples into the tables base on following figures. Make screenshot of the tables include tuples on your WAMPserver

Create tables for following relations and insert tuples into the tables base on following figures. Make screenshot of the tables include tuples on your WAMPserver or MAMPserver.

Create tables for following relations and insert tuples into the tables base

Copy and paste at least three Create Table SQL and three Insert SQL here.

Write and execute the SQL to update the project location managed by research department into Jacksonville. Copy and paste your SQL here and make screenshot of the result of project table.

Delete the employee who do not have a supervisor. Copy and paste your SQL here and make screenshot of the result of employee table.

Retrieve the employees Fname, Lname, SSN and working project name who works on the project located in Jacksonville. Copy and paste your SQL here and make screenshot of the result table.

Retrieve the employees dependents names and employees name which the employees salary is less than or equal to 30000. Copy and paste your SQL here and make screenshot of the result table.

Increase the employees salary 10% who has dependents. Copy and paste your SQL here and make screenshot of the result of employee table.

Retrieve the employees Fname, Lname, Ssn, who is a supervisor or manager, order the result by the employees Lname Ascendingly, then Fname Acendingly. Copy and paste your SQL here and make screenshot of the result table.

B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 FranklinT Wong 333445555 1955-12-08 638 Voss, Houston, TXM40000 888665555 5 Alicia JZelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 JenniferS Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 3334455555 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 3334455555 AhmadVJabbar 9879879871969-03-29 980 Dallas, Houston, TX M 25000 987654321 4 James EBorg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 8 DEPARTMENT DEPT LOCATIONS 3 888665555 Dnum 666884444 DEPENDENT 987654321 123456789 Michael M 1988-01-04 Son F 1988-12-30 Daughter 888665555 123456789 Elizabeth

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!

Assignment 1: Setting up Databases (15%) This assignment relates to the following Cowrse Learning Requirements: CLR 1 - Plan, Prepare, Install, Configure, and Use a market-leading Database Management...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

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...

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...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

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...

This uses microsoft SQL management Studio I. OBJECTIVES At the end of this activity, the students will be able to: 1. Create, Alter, and Drop SQL VIEWs. 2. Understand the use of WITH SCHEMABINDING....

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

Research three items and compare them with the risks they pose in case of a derailment in a rural town. Look at the status of fire departments in your current counties. This involves an exercise...

relationship between real GDP and the Okun's law is the A) negative; unemployment rate B) positive; inflation rate C) positive; unemployment rate D) negative; inflation rate

A savior who expects to have a higher tax rate after retirement would prefer a Roth retirement plan traditional retirement plan for 4 K plan 4 0 3 B plan

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

What are the Variable columns settings available in the Mining Models Tab?

What does the Mining Content Viewer in Visual Studio show in terms of Probabilities?

How are continuous variables normally handled in Decision Tree Algorithms?