Database Normalization

Question

1.00/5 (1 vote)

See more:

Hi guys

Basically I am new to databases and I need to make sure that the db is in 3rd normal form.
The task is as follows:

Design a relational database to hold the following information:
1. Name
2. Surname
3. Phone No
4. Phone No type (home, mobile, work, fax, other)

Make sure that the database is in 3rd normal form.

I have a working database but I wanted to know if I have done it correctly so solutions to the above would be greatly appreciated.

Basically Table1 has PersonID - primary key, Name and Surname
Table2 has NumberID - primary key, PersonID - foreign key, PhoneNumber and Type

Thanks

Posted 3-Dec-10 23:50pm

brendan8909

Updated 4-Dec-10 0:27am

v3

Add a Solution

Comments

Keith Barrow 4-Dec-10 6:13am

Well, provide us with your table structure, and we'll critique it for you.

Abhinav S 4-Dec-10 6:28am

You have not posted the structure you have created.

brendan8909 4-Dec-10 8:05am

It is now, please guys just let me know if I have gone about it the right way

Sandeep Mewara 4-Dec-10 9:18am

Share/update the question with what you say as 'working db'. After which we will comment. Just saying tried and asking for a design would not do. show your effort.

2 solutions

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)

fjdiewornncalwe · Answer 1 · 2010-12-04T07:44:00

You need to ask yourself a question about each field/group of fields.
Your "Table1" is a gimme', no one will argue with that as not being normalized.
In your other tables you need to ask yourself certain questions regarding each of the data fields that are relevant.
Can the data value be used multiple times?
If yes, then is it valid for the data value to be physically duplicated, or is a lookup table in order for this value?
I don't want to lay everything out for you. I want you to do the thinking and this is just to point you in the general direction. If you have any other specific questions, use the "Improve question" link above and then I'll gladly be more specific to those improvements by updating my answer here.

Cheers.

TweakBird · Answer 2 · 2010-12-04T09:13:00

Solution 2

Hi
Have a Look Here Sample[^]
case study with sample[^]
Third_normal_form_concept[^]

Posted 4-Dec-10 9:13am

TweakBird