0

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

3
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by acidutzu
0

i have collected some information like
customer(cutomer_name,address,phone,company_name,company_phone,cutomer_type)

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

0

Hello ...
I recommend you our hotel reservation script:
http://www.softacid.net/scripts
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.