Add the following data to the FEE table.

 

Billy Elliot was charged last year on Jan 20th. He is a student at Queens University and paid the student lower rate of $30 per day. Because he is a loyal guest he didn't need to pay a deposit on Jan 20th. (this means you need to store a record showing the guest was charged a deposit of 0.00) Justin Hackman paid last year a discount rate of $35 per day and a deposit of $20 because he is a smoker. He was charged the room rate for Feb 2nd, 8th, 17th, and 28th Deena Donor was charged last year on the 1** of every month from January through to April. Because of her position, she is not charged a deposit or room rate. (this means you need to record the room rate being 0.00 and the deposit being 0.00 for each 1" of the month)