Case Study 1 - The Misty Valley Country Inn

Here's my case study 1 The Misty Valley Country Inn.
Setting up a relational database to create tables, queries, and reports. In this case, I have created a relational database for a country inn. Then, I have also created three tables and populate them with data. Next, the two queries: a Summation query and a Parameter query. Finally, the report that shows the revenue received from customers.

DELIVERABLES

     1. Printouts of three tables
     2. Query output: Money Generated by Room
     3. Query output: Rooms Booked the Week of 12/12/05
     4. Report: Revenue From Customers—December 2005
     5. Link to the database file

1.Printouts of three tables



2. Query output: Money Generated by Room

3. Query output: Rooms Booked the Week of 12/12/05

4. Report: Revenue From Customers—December 2005

5. Link to the database file

• The Misty Valley Country Inn Databse



• Note: The file will be deleted after 90 days without download.



• Deliverable Soft Copy



• Note: The file will be deleted after 90 days without download.