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
This assignment was locked 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

 

 

 

Download Sailor Query DDL and Data- updated 2-21-18.sql

 

 

 

 

 

 

1529639940 06/21/2018 11:59pm