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 Systems please help me answer this question I will give you a good rating Thank you!

Write an SQL query to fetch the different projects available from the EmployeeSalary table.

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)