Create and populate a small normalized database in MS-Access that will schedule

Question

Create and populate a small normalized database in MS-Access that will schedule and track payments for a small inn.  You have eight rooms in the inn. Two have two double beds, five have two queen beds, and the suite has a king bed with sleeper sofa in the living room. You have two cots that can be added to any of the rooms for a maximum of five occupants per room. The cost for the rooms are: $95/night for the doubles, $105/night for the queens, and $125/night for the suite. There is a $25/night additional charge for the cots. Develop a database that will maintain a customer list, a room/feature list, and rental information.

Create and print at least one report showing the customers and rooms for any given month.

You will need at least three normalized tables and ten or more customers.

Explanation / Answer

Name of the Customer        Phone        Address       Remarks.

Total Rooms 8 in the Inn

2 have 2 double beds, 5 have two queen beds, Suite has King bed with Sofa, 2 beds can be added to any of the rooms.

5 occupants in a room can be put at the maximum.

Room cost $95 for the doubles for a night,$105 per night for the queens and $125/night for the Suite.

$25 extra for the aditional cots.

Name of the customer     Room Nos    Key nos      additional cot if any    Date of arrival     Time of Arrival (Check in) Date of Departure (Check Out )Signature   Remark

The dark text needs to be put in the excel sheet in the rows and columns and then border the table this will have a designed template ready.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.