Reserves - PowerPoint PPT Presentation

1 / 1
About This Presentation
Title:

Reserves

Description:

... defining keys/foreign keys, with a constraint that age is between 16 and 110. ... sailor's name, along with the number of reservations made by that sailor. ... – PowerPoint PPT presentation

Number of Views:30
Avg rating:3.0/5.0
Slides: 2
Provided by: eben
Category:
Tags: keys | reserves

less

Transcript and Presenter's Notes

Title: Reserves


1
In-Class SQL Exercise
Reserves
Sailors
Boats
Use the DDL to define relations for Reserves and
Sailors, defining keys/foreign keys, with a
constraint that age is between 16 and 110. Find
boats which have never been reserved Find
sailors sorted by their earliest reservation
date. Change all sailors named Bob to have
the name Robert List each sailors name,
along with the number of reservations made by
that sailor.
Write a Comment
User Comments (0)
About PowerShow.com