This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Table.
Publisher The other requirement for Second Normal Form
is that you cannot have any data in a table with a
composite key that does not relate to all portions
of the composite key. Third Normal Form
Third normal form (3NF) requires that
there are no functional dependencies of
non-key attributes on something other
than a candidate key. A table is in 3NF if all of the non-primary
key attributes are mutually independent There should not be transitive
dependencies Boyce-Codd Normal Form
BCNF requires that the table is 3NF and
only determinants are the candidate keys
View Full Document
This note was uploaded on 02/07/2014 for the course MIS 304 taught by Professor Mejias during the Spring '07 term at Arizona.
- Spring '07