February 4th, 2001, 08:59 PM
Re: True Understanding..
Thanks! Glad you found the article interesting!
February 16th, 2001, 06:20 AM
Re: Good article, wrong title.
Normalization is the correct term for this procedure though, I studied it at university
February 24th, 2001, 06:10 PM
February 24th, 2001, 07:14 PM
Re: most excellent 2
very most excellent dude, it helped me create a database in just about 5 minutes!
March 2nd, 2001, 01:53 AM
reg database normalization
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.
March 2nd, 2001, 11:07 AM
Good article, one suggestion
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.
April 29th, 2001, 06:46 PM
Nice overview of database normalization. Good example.
Thanks for the refresher!
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 :)
June 20th, 2001, 01:28 AM
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.
July 12th, 2001, 09:16 AM
"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.
July 19th, 2001, 08:53 PM
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.
July 30th, 2001, 06:25 AM
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.
August 20th, 2001, 08:37 PM
Ah, The light comes on!
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.
September 16th, 2001, 03:49 AM
that is a really comprehensive article to clear the lingering doubts anybody has regarding the fundamentals of normalization. kudos to the author.
September 19th, 2001, 04:57 AM
Re: database Normalisation
Plase send me mail about
Database normalisation and the part of normalisation
Rudi B Prakoso