make eer diagrom Guests once checked in may use other services $($not under the booking$)$ and charge them under

the booking. For example, guests may order a bar drink under the booking and pay it at

checkout time. The booking needs to keep track of all charges made under it$.$ If the guest arrives

on a package, services which are not included in the package are billed at the advertised rate

for the period

When checking out, the reservation needs to be fully paid. All payment information in settling

the bill needs to be maintained. The manager and authorized personnel has the ability to

provide a discount on the final bill. If a discount is provided, the discount amount and employee

authorizing the discount is recorded. A discount of more than $25\%$ needs the authorization from

head office. The final bill for a reservation needs to include all charges under each booking,

deposit information and all customer payments. The database should be able to generate this

final bill.

Customer and guest information such as name, address, contact number and email needs to

be maintained. If a reservation or a booking is cancelled after the grace period $25\%$ of the

amount due is charged and all facility bookings for the reservation is removed.