Computers and Technology, 03.05.2021 14:00 tsdean21

Create a new database as test. db. Create the tables with the following schema using (7) DDL commands. Sailors (sid: PK, sname: must be unique, rating: Between 0 and 5, age) Boats (bid: PK, bname, color (Must be blue or black only) Reserves (rid: PK , sid: FK, bid: FK, date: Default value: current date.) Note: If the record from boats is updated, its value should be set null in Reserves. b) Apply following queries. (16) 1) A new reservation of boat with id 208 and sailor with id S03 has been done on 2019-12-26. Store this data. 2) Find all the sailors with a rating below 3. 3) Create a view that will display the names of sailors who have reserved boat with id 109. 4) Find the boat ids that are not reserved. 5) Add a new column design to the Boat table. 6) Show the names of sailor and color of boat who have reserved black color boat. 7) Delete the reservations made on date 2019-10-12. 8) Find the average age of all sailors.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 21.06.2019 17:20

Find the inverse function of f(x)= 1+squareroot of 1+2x

Answers: 2

Answer

Computers and Technology, 22.06.2019 12:40

In a response of approximately 50 words, explain why it would be essential for the successful a/v technician to participate in additional coursework, presentations and seminars offered by equipment manufacturers as well as annual conferences attended by colleagues in the industry.

Answers: 1

Answer

Computers and Technology, 23.06.2019 09:50

Allison and her group have completed the data entry for their spreadsheet project. they are in the process of formatting the data to make it easier to read and understand. the title is located in cell a5. the group has decided to merge cells a3: a7 to attempt to center the title over the data. after the merge, allison points out that it is not centered and looks bad. where would the title appear if allison unmerged the cells in an attempt to fix the title problem?

Answers: 2

Answer

Computers and Technology, 23.06.2019 22:30

Lakendra finished working on her monthly report. in looking it over, she saw that it had large blocks of white space. what steps could lakendra take to reduce the amount of white space?

Answers: 3

Answer

You know the right answer?

Create a new database as test. db. Create the tables with the following schema using (7) DDL command...

Questions