create and populate a small normalized database in MS-Access that will schedule
ID: 460216 • Letter: C
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.
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
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.