Practice Assignment: UPDATE and DELETE Statements for Sailor Boat Reservation Database
- Due Jun 21, 2018 by 11:59pm
- Points 100
- Submitting a text entry box or a file upload
- Available until Jun 22, 2018 at 11:59am
In the class assignment, we will writes UPDATE and DELETE Statements for tables in the Sailor Boat Reservation Database . The exact criteria for these statements will be determined during class time. If you are not able to attend class and would like to participate in the assignment, A list of the requirements for the statements will be posted to this link after class.
Update the rating of a Sailor
Update the rating of a group of Sailors
Update the age of a sailor
Update the age of a group of sailors
Update the color of a boat
Delete A sailor based on a condition
Delete a Reservation based on a condition
Sailor Query DDL and Data- updated 2-21-18.sql Download Sailor Query DDL and Data- updated 2-21-18.sql