JasonParkNormalization

When we have a one topublish many relationship we

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Table. Publisher The other requirement for Second Normal Form The 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 Third 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 table key attributes are mutually independent There should not be transitive There dependencies Boyce-Codd Normal Form Boyce-Codd BCNF BCNF requires that the table is 3NF and only determinants are the candidate keys only END END...
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.

Ask a homework question - tutors are online