Case 1: Misty Valley Country Inn

Tables:

• Customer


• Reservation


• Rooms

Queries:

• Money Generated by Rooms


• Revenues


• Rooms Booked week of 12/12/05

Reports:

• Customer


• Revenues from Customer of December 2005