first begin to analysis the er diagram for the hotel:

then start to think about the type of system you want to chose the entities
er diagram can be for management system or reservation system or .....

if reservation system the hotel will have 3 basic tables … Read more