Practice Exercise: Multi-Table SQL Script - Sailor Reservation Database

This is one of your first multiple table queries for the semester. Practice using the Boat Reservation SQL script that you were assigned single table queries. You will have to use JOIN clauses or JOIN tables using the WHERE clause in your SELECT Statements to correctly  reply to these requests

This will prepare you for the independent individual multiple table query assignments.

Link to Download ER Diagram 

BoatReservationDatabase Summer 2020.pdf Download BoatReservationDatabase Summer 2020.pdf

Link to Download Metadata / Data Dictionary

Data_Dictionary Boat Reservation Database Summer 2020.pdf Download Data_Dictionary Boat Reservation Database Summer 2020.pdf

Find the Boat ID, Sailor names and sailor ages of the sailor that reserved boat 3   

Find the Boat ID,  Boat Color, names and ages of the sailor that reserved red or green boat

Link to Download Sample Database / AKA Sandbox Database

Boat_Reservation_Summer_2020.sql Download Boat_Reservation_Summer_2020.sql

Submit an SQL Text File for this assignment.  An SQL Text File is a text file with a ".SQL" extension on the file name. 

• The script should be well documented with comments
  
  
• All the script should be placed in one file
  
  
• The script should run continuously without errors