Page 2 - An Introduction to Database Normalization

Thanks! Glad you found the article interesting!

wj gilmore

Normalization is the correct term for this procedure though, I studied it at university

most excellent, dude

very most excellent dude, it helped me create a database in just about 5 minutes!

Dear Sir,
Your article on database concepts and normalization was really excellent and most useful.I hope u would be writing such articles in near future to help the IT community.
Thanking ,
Subramanian.N

I found this to a well-written article with clear examples and explanations (not always easy to find on the Web). The author definitely did a good job of communicating the material.



One nice addition would have been a small section on paragraph that briefly alerts the reader to the possible tradeoffs between normalization and such things as performance and development complexity.

Nice overview of database normalization. Good example.

Thank you!

This was exactly what I was looking for. I've been programming for seven years and have these concepts internalized but couldn't regurgitate them for my clients when I needed to. That's the disadvantage of being out of school for so long.

But you gotta love the Web!

Thanks for having this article out there :)

hi

good job. I guess this can be inproved a bit by taking a common example and do the design for it. That should make things very clear.



cheers

balsu

You say:

"Obviously, the original table contains several sets of repeating groups of data, namely classID, className, classTime, classLocation, professorID, professorName. Each attribute is repeated three times, allowing for each student to take three classes."

But this isn't the case. In your original table, there are no repeating groups. The table is defined so that each student may only take one class. A poorly defined table, certainly, but also a poorly selected and/or illustrated example.

I just started reading your forum and not yet finished it. also i havent checked other's messeges so not sure if anybody else has raised same question and u answered it or not.
Any way in your ER diagram you are showing 1:M relationship between student and classes. I think it should be M:M as one student can registered with many classes and con class can have many student.
let me know if i am missing something.

Assalamu alaykom
dear sir,
Mr.Roshad
most respectfully i beg to say that I need
the ER diagram and i would like to request you to send it to my E-mail.
thank you.

I am studing IS and one of the courses is Database Concepts. Normailization in the text was like reading Greek. This article made it clear for me- thanks.

that is a really comprehensive article to clear the lingering doubts anybody has regarding the fundamentals of normalization. kudos to the author.

Plase send me mail about
Database normalisation and the part of normalisation

thank's
Rudi B Prakoso