I am supposed to create a hotel reservation system that allows you to make a reservation either with a hotel package or without and calculate billing. However I am at lost for where to begin. I have made a couple of sorry attempts but I am having problems identifyind the tables that are needed and getting them related. Since this is supposed to be generic, general design suggestion would be greatly appreciated heres what i have come up with so far.I think I have the basic concept but wil I be ale to query for available room easily which this approach?

Agent
Agent_Id Pk
Agent_Fname
Agent_Lname

Rooms
Room_Id Pk
Room_Num
Room_Type

Room_Rates
Room_Num Pk
Room_Rates Pk
Room_Type

Reservations
Reservation_Id Pk
Guest_Id
Agent_Id
Room_Num
Package_Id
Arrival
Checkout

Package
Package_Id Pk
Package_Type

Guests
Guest_Id Pk
GuestFName
GuestLName
Guest_Address

Facility Charges
Reservation_Id Pk
ChargeDate Pk
Facility_Id
Charge_Amt

Bill
Bill_Id Pk
Guest_Id
Reservation_Id
Subtotal
Finaltotal
Payment Method
Expiration Date