creating a 1NF, 2NF and 3NF

Iola1981
Iola1981 used Ask the Experts™
on
how do i create the 2NF and 3NF?
the un-normalised form i was givien to work with has repetitions in its colums...

Please help!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
see this link

Description of the database normalization basics

http://support.microsoft.com/?kbid=283878





MIS Liason
Most Valuable Expert 2012
Commented:
Yes, each successive Normal Form is dependent on all the preceding Normal Form's criteria already being met.

ex: You can be in 3nf unless all 2nf conditions are satisfied.

The link capricon1 posted is a great starting point, here are a few more:
http://databases.about.com/od/specificproducts/a/normalization.htm
http://databases.about.com/od/specificproducts/l/aa1nf.htm
http://databases.about.com/od/specificproducts/a/2nf.htm
http://databases.about.com/od/specificproducts/l/aa3nf.htm

There are others too, some with graphics of tables illustrating the principles, ...you can Google:
    Database Normal Forms Normalization
...for more hits

Sorry, there is no simple "Make 3NF" tutorial.
;-)

Remember that there are entire books and College level course on Normalization.

Finally, at the higher levels, you may find that DB design is part Science and part Art.

;-)

JeffCoachman
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
oops!

<ex: You can be in 3nf unless all 2nf conditions are satisfied.>
Should read:
<ex: You *can't* be in 3nf unless all 2nf conditions are satisfied.>
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2012
Top Expert 2014

Commented:
Is this an academic assignment?

Author

Commented:
yes it is @ lsmcONSULTING
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Though a very broadly defined restriction, we cannot provide direct answers to academic questions.

Besides, what you posted is not really a single, direct question.

Your question is basically:
  "How do I normalize a DB to 3NF?"

Without an intimate knowledge of the Data involved, this is near impossible to answer anyway.

As I stated, there are entire Books written on this subject.

But to zero in on your specific concern...
   "the un-normalised form i was givien to work with has repetitions in its columns..."

Then you must create a new table in which these "repetitive" columns are instead, converted to a common "Field".

To quote an old Database design adag:
   "Columns (fields) are expensive, ...Row (records) are cheap.

;-)

JeffCoachman

Author

Commented:
HI! boag2000, is an attachment of the DB im working with, the table called UNF STUDENT INFORMATION is the original table... where all the columns have repetitions. the UNF means Un-Normalized Form. BUT OF COURSE U KNEW THAT:)
LAB2-IOLA.accdb
Top Expert 2016

Commented:
Iola1981,

It is already stated that we cannot give direct answer to an assignment..

you already were given enough references to figure out what you need to do.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Iola1981,

Just so we are clear on a few things...
1. if this is an academic question, then my guess is that the topic of normalization is being covered in class.
In this case you should have some idea of how to go about this, correct? (class lessons, textbooks, questions in class?)

2. Besides, the file you posted already seems like it contains the normalized tables, they just need to be filled in then joined/linked.

(as far a the two posts above are concerned...)
3. While it is true that you did not ask for a direct answer, capricorn1 is also correct in that you have been given enough references/links to solve this.  
For example, the same links helped me understand these topics when I first started out.

Did you look at all the links we posted?
Based on your investigation of these links, what information are you lacking?

JeffCoachman

Author

Commented:
Hi! Jeff,

yes as u can see the attachment does show so
me form of eventual normalization, its just to join.....

I did figure it out, i had to create a unique auto no. in each table created, im at the stage of creating joins....

how do i go about creating a foreign key?

yes i know how to create a primary key.

i just want to know how am i going about it practically in MC Access....

thank you much!

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
A Foreign key is basically a Primary key from another table.

But the info in the links we posted, cover this extensively...
Correct?
Top Expert 2010

Commented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial