Database Management

Mariner’s Inn

The Marino family purchased a small inn along the seashore with 40 rooms and a small restaurant. When they took over, they realized that, while the financial books were in good order, the historical records of guests had been maintained mostly through check-in cards and later a spreadsheet. The Marino’s, aware that publicity and correspondence could bring more people into their location, knew they needed more than cards and a workbook of information. They decided to convert everything to a database.

To accomplish their needs, they wanted to import the data from the worksheet called Guests into an Access table, and create additional tables for the information they wanted to maintain.

The additional tables needed were:

A ROOM ASSIGNED Table which contained information on their name, room number assigned, date registered, date checked out, and room rate

A CREDIT CARD Table which contained Cardholder Name, Type of Credit Card, Credit Card Number, Expiration Date, and amount charged

Once the tables were created, the Marino family needed two simple reports/queries:

A CUSTOMER Report which listed the Customer Last Name, First Name, Date Registered, Date checked out, Room Assigned, and Credit Card Amount.

A CUSTOMER QUERY with the same information as the query, formatted for the screen

Assume all customers paid with credit cards.

Create the database, with tables, query and report.

Submit to the Blackboard