Member Avatar for cpeng

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
  • 113 Views
  • 9 Months Discussion Span
  • Latest Post Latest Post by acidutzu
Member Avatar for debasisdas

Before drawing the ER you need to gather all informations and be sure of all your requirments.

Member Avatar for cpeng

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

Member Avatar for acidutzu

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.