Question: need code in live sql Create the following tables, Sailors, Reserves and Boats. Include Query and the output of Query (HRows updated) as part of

need code in live sql need code in live sql Create the following tables, Sailors, Reserves

Create the following tables, Sailors, Reserves and Boats. Include Query and the output of Query (HRows updated) as part of your solution. Primary Keys; Sailors (Sid) Reserves (Sid and Bid) Boats (Bid) Sailors Reserves Using the Sailors, Boats and Reserves tables, Issue the following queries ( 100 Points): 1. Find the name and the age of sailors who have reserved a Red boat. 2. Change the Reserve day of boat with Red color to 3/2/23 if reserve day is 10/10/96. 3. Select all sailors (namc, rating and age) if their matings are greater than or equal to the average of ratings and their ages are greater than or equal to the minimum of all ages. 4. Change the Sailor name to your last name if be has reserved boat 103 and the reserve day is 11/1296. 5. Change the color of boat to White if the reserve day of boat is 3/2/23, 6. Inerease the age of the sailor by 12 if the sailors' reserve day of sailor is 3/2/23 and sailors' ratings is less than or equal to minimum of ratings. 7. Increase the rating of yourself as sailor by 5 if you have reserved a boat for other day than 3/2/23 8. Inerease the age of sailor by 8 if the sailor has reserved a Green boat and the reserve day is 11/12/96. 9. Display all three tables

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!

Please someone should help with solution to this question. And please if you do. Give me a proof that its correct. Thank you. SET DEFINE OFF; --Delete preexisting tables DROP TABLE boats cascade...

25. What does the following query compute? 16- Following ER diagram is given to you. There is a 1:1 relationship between Professor and Department entities. Which of the following options are correct...

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

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

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

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

Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for your project. Your script must also...

Assignment2.java ----------------------------------------------------------------------------------------------- import java.sql.*; public class Assignment2 { // A connection to the database...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Use Greens theorem to find the work done by the vector filed F = (4y 3x)i + (x 4y)j On a particle as the particle moves counterclockwise once around the ellipse x 2 + 4y 2 = 4.

Given the data flow diagram shown in Figure and using transform analysis, develop a structurechart. Order information Approved orders Order information Validated order information 1.2 1.3 1.5 Update...

4. Create a single integer expression that uses all the operators from Section 3.1.2. Calculate the value of the expression.

please dont use chat gpt 6 6 4 .

4. Does cultural aptitude impact ones emotional intelligence?

7. Do the organizations social activities reflect diversity?

If you had to find someone to replace you, on what key abilities would you focus?