Very good serie ! I have been teaching Access for a long time and your presentation of Normalization is really clear. And the fact of chaining this with E-R is a great approach.
This is a good example of normalization. I am curious about the several forms of Normalization. Most experts only follow the first three. What is the purpose of the last four?
The first three normal forms: 1) are common to nearly all databases, 2) solve the vast majority of data anomoly problems, and 3) are the easiest to explain to newbies.
The higher normal forms are used for increasingly specialized cases, and depending on the business rules, are often better handled at the application level rather than the database level.
There's a longer answer, but I'll save that for a new post. Stay tuned.
4 comments:
Very good serie ! I have been teaching Access for a long time and your presentation of Normalization is really clear.
And the fact of chaining this with E-R is a great approach.
Wow!
I never knew someone who could 'talk Access' like that.
This is a good example of normalization. I am curious about the several forms of Normalization. Most experts only follow the first three. What is the purpose of the last four?
@ kino
The short answer is...
The first three normal forms: 1) are common to nearly all databases, 2) solve the vast majority of data anomoly problems, and 3) are the easiest to explain to newbies.
The higher normal forms are used for increasingly specialized cases, and depending on the business rules, are often better handled at the application level rather than the database level.
There's a longer answer, but I'll save that for a new post. Stay tuned.
Post a Comment