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
Another question on Computers and Technology
Computers and Technology, 21.06.2019 17:30
What is force? what are the types of force ? explain all with suitable examples
Answers: 1
Computers and Technology, 22.06.2019 20:00
What is the worst-case complexity of the maxrepeats function? assume that the longest string in the names array is at most 25 characters wide (i.e., string comparison can be treated as o( class namecounter { private: int* counts; int nc; string* names; int nn; public: namecounter (int ncounts, int nnames); int maxrepeats() const; }; int namecounter: : maxrepeats () { int maxcount = 0; for (int i = 0; i < nc; ++i) { int count = 1; for (int j = i+1; j < nc; ++j) { if (names[i] == names[j]) ++count; } maxcount = max(count, maxcount); } return maxcount; }
Answers: 3
Computers and Technology, 23.06.2019 13:30
Jace needs to answer a question on square roots to win a quiz. how can he use a spreadsheet to find the square root of 786? a. use the functions round and count b. create a table and chart c. use the function sqrt d. use the function now
Answers: 3
Computers and Technology, 23.06.2019 23:30
What can you prevent issues related to downloading content form the internet
Answers: 1
You know the right answer?
Create a new database as test. db. Create the tables with the following schema using (7) DDL command...
Questions
History, 19.09.2019 20:00
Chemistry, 19.09.2019 20:00
