### SQL Query Instances: An Educational ExerciseThe following SQL queries utilize tables that represent instances of `Reserves`, `Boats`, and `Sailors`. #### Table 1: R1 of ReservesAn instance of the `Reserves` relation:| sid | bid | day ||-----|-----|-----------|| 22 | 101 | 10/10/96 || 58 | 103 | 11/12/96 || 22 | 102 | 10/10/96 || 31 | 101 | 10/10/98 || 31 | 102 | 10/22/98 || 22 | 104 | 10/10/99 || 22 | 102 | 10/11/98 || 22 | 101 | 10/7/99 || 64 | 104 | 10/9/98 || 58 | 102 | 09/05/98 || 64 | 102 | 09/08/98 || 58 | 102 | 09/08/98 || 22 | 102 | 10/11/98 || 31 | 102 | 11/09/98 || 64 | 102 | 09/05/98 || 64 | 103 | 09/08/98 |#### Table 2: B1 of BoatsAn instance of the `Boats` relation:| bid | bname | bcolor ||-----|----------|--------|| 101 | Interlake| blue || 102 | Interlake| red || 103 | Clipper | green || 104 | Marine | red |#### Table 3: S1 of SailorsAn instance of the `Sailors` relation:| sid | sname | rating | age ||-----|-------|--------|-----|| 22 | yuppy | 3 | 35 || 31 | lubber| 8 | 55 || 64 | guppy | 5 | 35 || 58 | rust

Given database consisting data of reserves , boats and sailors. To solve the above given questions…

The following SQL queries use the instances of R1 of "Reserves" the instances of B1 of "Boats", and the instances of S1 of "Sailors" relation. An instance R1 of Reserves bid 101 day 10/10/96 11/12/96 103 10/11/96 12/01/96 12/05/96 10/10/09 10/10/98 10/07/98 RO 22 58 22 31 31 22 22 31 64 64 74 103 104 103 102 104 102 101 102 103 11/10/98 09/08/98 09/05/98 09/08/98 An instance B1 of Boats bid 101 102 103 bname Interlake Interlake Clipper Marine 104 bcolor blue red green red An instance S2 of Sailors Sid 28 31 21 44 58 256 22 22 29 29 32 m 64 21 74 85 95 71 sname yuppy Tubber guppy rusty Dustin Brutus Andy Horatio Horatio Zorba Art Bob Amy rating 81 5 10 711 L & |10|| 21 3 115 age 35 155 135 135 45 $3 25 35 18 25 635 46 1.If we wish to list out only the names and ratings of the sailors, we can write this in SQL statement as 2.Find out only the names and ages of sailors. 3.To find out the names and ratings of sailors with a rating above 8, we can combine two of the preceding queries as: 4.Find the names of sailors who are older than 40.

The following SQL queries use the instances of R1 of "Reserves" the instances of B1 of "Boats", and the instances of S1 of "Sailors" relation. An instance R1 of Reserves bid 101 day 10/10/96 11/12/96 103 10/11/96 12/01/96 12/05/96 10/10/09 10/10/98 10/07/98 RO 22 58 22 31 31 22 22 31 64 64 74 103 104 103 102 104 102 101 102 103 11/10/98 09/08/98 09/05/98 09/08/98 An instance B1 of Boats bid 101 102 103 bname Interlake Interlake Clipper Marine 104 bcolor blue red green red An instance S2 of Sailors Sid 28 31 21 44 58 256 22 22 29 29 32 m 64 21 74 85 95 71 sname yuppy Tubber guppy rusty Dustin Brutus Andy Horatio Horatio Zorba Art Bob Amy rating 81 5 10 711 L & |10|| 21 3 115 age 35 155 135 135 45 $3 25 35 18 25 635 46 1.If we wish to list out only the names and ratings of the sailors, we can write this in SQL statement as 2.Find out only the names and ages of sailors. 3.To find out the names and ratings of sailors with a rating above 8, we can combine two of the preceding queries as: 4.Find the names of sailors who are older than 40.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Below is “Book Order,” the only table in library management system’s database. The design of “Book Order” as you may tell is in the zero normal formal form, you as the database designer want to convert the design into the third normal form. Order ID Special order date Customer ID Customer last name Customer First name Customer birth date Book ISBN1 Book Title 1 Book Author 1 Book publication year 1 Book ISBN2 Book Title 2 Book Author 2 Book publication year 2 Store ID Store name Store location Special order status Book Order(Order ID, Special order date, Customer ID, Customer last name, Customer First name, Customer birth date, Book ISBN1, Book Title 1, Book Author 1, Book publication year 1, Book ISBN2, Book Title 2, Book Author 2, Book publication year 2, Store ID, Store name, Store location, Special order status)
Express the following SQL code in Relational Algebra form.SELECT *FROM COURSEWHERE (COURSE.COLLEGE <> ’Business’OR COURSE.COLLEGE <> ’Engineering’)AND COURSE.CREDIT = ’U’;
Based on the following authorication commands (ordered from 1 to 4), which of the following privileges is true, assuming that Ali is the owner of the database? Order By Ali 1 2 3 4 Select one: Omar Ali Ali Command Grant Select on Employee to Omar with grant option; Grant Select on Employee to Samer with grant option; Grant Update on Employee to Omar with grant option; Revoke Select on Employee From Omar Cascade; a) Ali and Omar have Update privilege on employee Ali has select privilege on employee b) Ali and Omar have Update privilege on employee Omar and Samer have select privilege on employee elect c) Ali and Omar have Update privilege on employee Ali and Omar have select privilege on employee d) Ali and Omar have Update privilege on employee Ali, Omar and Samer have select privilege on employee
Copy all SQL queries to a document and save it as 'yourID_Queries'.
Write an SQL query to fetch the EmpId and FullName of all the employees working under Manager with id – ‘986’.
Given the tables create table T (A int primary key, B int); create table U (C int primary key, A int, foreign key(A) references T(A) ); Table T contains 100 rows and table U contains 200 rows. A common mistake made by students is to do a join and assuming the database will supply the join predicate. A student does the query SELECT T.A, T.B, U.C FROM T, U; The student does not get an error message but gets a large result set. How many rows are in the result set?
Consider the following ERD; consider additional attributes if needed Write relational algebra expressions on following: 1) Find the test details that has performed on patient 'Arisha' 2) Find the total test amount of patient 'Nishant'. a) Find the doctors details with dss='d01' with list of his patients insurance date-admitted name date-checked-out ss# patients test-log Dr-Patient test_id performed by doctors test dss# specialization name test_name date time result
please help me to write the expression for these in access. please.
SQL Database Write PL/SQL or T-SQL procedures to accomplish the following tasks: Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_GUIDE_NUM, I_FIRST_NAME, and I_ LAST_NAME. Obtain the number of persons, customer number, and customer last name for every reservation whose ID currently is stored in I_RESERVATION_ID. Place these values in the variables I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME, respectively. Output the contents of I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME. Add a row to the GUIDE table. Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME. Delete the guide whose number is stored in I_GUIDE_NUM