Normalising Your Database - Third Normal Form (3NF): Now we've looked at normalising a database to 1NF (First Normal Form) and to 2NF (Second Normal Form) we will continue to investigate normalising to Third Normal Form. Concepts >> A tab...More
Normalising Your Database - Third Normal Form (3NF): Now we've looked at normalising a database to 1NF (First Normal Form) and to 2NF (Second Normal Form) we will continue to investigate normalising to Third Normal Form. Concepts >> A table is in second normal form (2NF) and there are no transitive dependencies. A transitive dependency is a type of functional dependency in which the value in a non-key field is determined by the value in another non-key field and that field is not a candidate key.
Normalising Your Database - Second Normal Form (2NF): Now we've looked at normalising a database to 1NF (First Normal Form), we will continue to investigate normalising to Second Normal Form. A table is in first normal form and each non-k...
www.databasedev.co.uk/2norm_form.html
-
Get Site Info