suggestion reguarding the database design for a hotel management system

Question

5.00/5 (1 vote)

See more:

Hi Every one,

Thank you all for helping me out these days when ever I was stuck while coding!!
however guys I'm a newbee when it comes to database design and I'm very much interested in learning how it is done. I'm planning to design a sample hotel management database. I am planning to have the following tables in my database.

customer(cust_id,name,address,phone number,country)
hotel:(hotl_id,name,Location,Country)
branches:(brn_id,name,hotl_id)
menu:(slno,dish,price)
bills:(bill_no,Cust_id,price,Supp_id)
booking:(cust_id,brn_id,checkin_date.Checkout_date)
staff(Staff_id,name,salary,shift,hid)

The problem that I'm facing is I do not know how to normalize these tables. I do not even know if they are normalized. Could any one help me with this?

I would appreciate if some one could tell me how to draw an ER diagram for this.

I thought to relate customer to hotel and hotel to branch then staff to each hotel and then bills to customers. However I do not know if that is correct.

I also want to know how can one understand if a table is in normalized form(1st 2nd or 3rd etc).

Thanks in Advance

Posted 22-Feb-14 7:23am

shrav007

Updated 22-Feb-14 8:13am

CoderPanda

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CoderPanda · Answer 1 · 2014-02-22T08:44:00

I will try to answer as much as I can. But please know that what you are asking is a huge subject in itself and needs months to study, practice and master. You may want to start by just doing a google and learn about how to design tables, databases and entity relationships. There are plenty of tutorials online for free as well as videos on youtube.

The table schema that you have outlined seem to be normalized enough. You can read about normalization and its advantages online[^]. Again there are plenty of tutorials for free. Please try not to understand every Normal Form straightaway, as they take a bit of time and experience to really make sense. It is okay to learn slowly.

Regarding diagrams: Do not confuse between a Table schema diagram[^] with an ER diagram[^]. They are totally different things and sometimes used synonymously by people who don't understand them. For your purpose a Table Schema diagram is what you are looking for.

Free tools such as Goodle Draw[^], Gliffy[^] and Lucid Chart/[^] can come really handy if you don't have MS Visio.

[Please accept/up-vote answers or solutions that work for you to encourage participation]