Intro and System Description
I am currently designing a Database for a Room Booking system in a Hotel.
Client fills a Form / Request with following information about Room:
- amount of people in room
- rating of a room
- check in and check out date
Administrator has a dashboard with list of Forms from Clients, he will assign each Room for every Client manually. After this User gets a Bill.
This is actually a Sketch of my DB. I'll have following tables:
I am not considering table Passwords which contains Password's Hashes.
I would like to hear from you what is missing in my DB Design, what do you think about overall logic and correctness of relations between tables.