i am making the hotel reservation system database.cosidering the following
customer(name,phone,address,city,creditcard no,etc)
reservation(check in date, check out date, price, customer name, no of rooms)
room (room no,room type, price)'

but i am not satisfied with it.i have to keep record of hall and table reservation as well .
i want to differentiate b/w resident customer and non resident customer .
plz any one guide me to build the complete ERD for my database i will be very thankful

plz help me as i have just started database

10 Years
Discussion Span
Last Post by acidutzu

i have collected some information like

company information is added for corporate customer nad customer type will identify wether
the customer is resident or non resident.

this approach for cutomer is correct or else i have to use the supertype/subtype concept
basically i want to distinguish b/w resident or non resident and corporate customer and non corporate

plz guide me


Hello ...
I recommend you our hotel reservation script:
We will give you a good discount if you contact us via this forum.
also if you're not interested in buying you could take a look at our online demo ... it will help you to make yourself a better idea about the database we use.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.