Database design techniques often use the terms
and so on.
What do these mean, and how do we implement these in SQL Server?
How do you strike the balance between purist design and pragmatic implementation?
The Normal Forms are rules for creating relations that will attempt to eliminate data anomolies.
It's taking a real world problem, such as an invoice, and creating tables to represent it such that there is no data redundancy, data integrity is enhanced, and dependancies are identified.
In SQL we implement these ideas through tables, constaints and relational keys.
There are times when design is denormalized for performance. For instance it may be more efficient, despite the additional space requirements and potential IUD overhead, to add a field to a row rather than joining an additional table to get the information.
answered Oct 19, 2009 at 02:52 PM
Normal Forms are a set of design principles used for analysing and elminating certain types of redudancy in database design. The Second and Third normal forms (2NF and 3NF) are concerned with redundancies that can arise from Functional Dependencies.
2NF and 3NF are subsumed by the more significant and concise Boyce-Codd Normal Form (BCNF) which can be stated as: Every non-trivial determinant is a superkey.
Normalization has nothing to do with performance because it specifies only the logical characteristics of the database, not their physical implementation. However, given the poor degree of Physical Data Independence in many DBMSs it is sometimes necessary to compromise your logical model in order to make corresponding changes to the underlying physical implementation. Another reason to make such compromises is if you need to implement some constraint or other logic that the DBMS cannot otherwise support.
answered Oct 19, 2009 at 04:36 PM
The only glory most of us have to hope for is the glory of being normal - Katherine Fullerton Gerould
In anything at all, perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away. - Saint-Exupery, Wind, Sand, and the Stars
The rules leading to and including the third normal form can be summed up in a single statement: Each attribute must be a fact about the key, the whole key, and nothing but the key. - Wiorkowski and Kull
answered Dec 09, 2009 at 07:00 AM
Scot Hauder 4