C170 - Data Management Applications

First Normal Form -- when all non-key columns depend on the primary key - a table with a primary key is in first normal form - a table with no duplicate rows is in first normal form Second Normal Form -- when all non-key columns depend on the whole primary key - cannot depend on part of a composite primary key - a table with a simple primary key is automatically in second normal form A table with a simple primary key must be in what normal form? -- second normal form or higher Third Normal Form -- when all non-key columns depend on the key, the whole key, and nothing but the key Violation of Third Normal Form -- a non-key column depends on a column that is not unique Boyce-Codd Normal Form -- whenever column A depends on column B, then B is unique - same as Third Normal Form, except "non-key" is removed A table has: - columns A, B, C, D - candidate key (A, C, D) - primary key (A, C, D) - dependency D → B (in addition to dependencies on candidate keys) What is the normal form of the table? -- First Normal Form - the table has one candidate key, which is also a primary key - any table with a primary key is in FIRST nf - the non-key column B does not depend on the whole primary key...so not in SECOND normal form