Question: Consider table sailors(sid, sname, rating, age) where sid is the primary key; Reserves (sid, bid, day) where {sid, bid, day} is the primary key. Write

Consider table sailors(sid, sname, rating, age) where sid is the primary key; Reserves (sid, bid, day) where {sid, bid, day} is the primary key. Write SQL query for the following question: Show the information of sailors who has never reserved any boat yet. * (10 Points) sid sname 22 Dustin 29 Brustus 31 Lubber 32 Andy 58 Rusty 64 Horatio 71 Zorba 74 Horatio 85 Art 95 Bob 100 Rusty 101 Bob rating 7 1 8 8 10 7 10 9 3 age 45.0 33.0 55.5 25.5 35.0 35.0 16.0 35.0 25.5 63.5 16.0 45.0 A1 sid bid day 22 101 1998-10-10 22 101 2020-12-18 22 102 1998-10-10 22 103 1998-08-10 22 104 1998-07-10 31 102 1998-10-11 31 103 1998-06-11 31 104 1998-12-11 64 101 1998-05-09 64 102 1998-08-09 74 103 1998-08-09 3 8 5

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!

Workshop Week 8 MySQL Practical Exercise Exercise 1 This exercise is similar to week 5 . Students at this stage should be illustrated how to create tables, alter tables, and write complex SQL...

Consider the following structure and answer the following questions: ----------------------------------------------------------------- sailor (sid, sname, rating, age) boat (bid, bname, color)...

Consider the following structure sailor (sid, sname, rating, age) boat (bid, bname, color) reserves (sid, bid) create database boats; use boats; create table sailor ( sid int auto_increment not null...

This exercise is similar to week 5. Students at this stage should be illustrated how to create tables, alter tables, and write complex SQL queries. Note : Use SQL commands to create the database,...

Question 3. (10pts) Consider the following schema with three tables, namely Sailors, Reserves. Boats, and Sailors (sid, sname, rating) Reserves (sid, bid, day) Boats (bid, bname, color) The key...

This exercise is similar to week 5. Students at this stage should be illustrated how to create tables, alter tables, and write complex SQL queries. Note : Use SQL commands to create the database,...

Tutorial MySQL Practical Exercise-Week 8 This exercise is similar to week 5. Students at this stage should be illustrated how to create tables, alter tables, and write complex SQL queries. Note : Use...

Question Consider the Sailors - Boats - Reserves DB described in the text. s ( sid , sname, rating, age ) b ( bid , bname, color ) r ( sid , bid, date ) Write each of the following queries in SQL . 1...

--create tables CREATE TABLE boats bid integer bname char (20), color char (20) PRIMARY KEY (bid)); CREATE TABLE sailors sid integer, sname char (30), rating INTEGER, age INTEGER, PRIMARY KEY (sid));...

Please answer both questions fully --create tables CREATE TABLE boats ( bid integer, char (20), bname color char (20), PRIMARY KEY (bid)) CREATE TABLE sailors sid integer, sname char (30), rating...

Calculate the molarity of 3.53 10 2 mL of solution containing 16.0 g of potassium iodide.

Prepare a prospectus of your final essay by answering the following essay questions. Briefly explain the problem you have chosen. How does it arise, and what issues does it present? What three...

talent analytics is about making work force decisions based on metrics

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Teamwork. Ethics. Form groups with four or five students in each. Each member of the group will choose a specific cultural dimension from among the following: ethnicity, race, gender, age, or...

Teamwork. Form groups of four to seven people. Discuss the importance of diversity initiatives in businesses. Plan an agenda for a seminar that could help people in a business understand the needs...

Technology. Global. Ethics. Interview a student, a businessperson, or a visiting lecturer who is a native of another country or who has spent extensive time in a particular country other than the...