Accommodation. Mathematics. Database Normalization and Table structures. Unfortunately, this is not quite correct.
To give a quick summary, the normal forms are as follows: 1NF: Every row must be an identifiable relation. This means that, in a table, no row may be an exact duplicate of another row, and nor may the row be completely filled with NULL. 2NF All non-key attributes of the table must depend on the entire key. This means that, when a table has a compound key, attributes which depend only on a subset of the key columns should be moved out of the table. For example, take the comment above which mentions a compound primary key of OrderID and LineNo; if the application wants to use invoice_bgcolor to alternate the background color of rows on an invoice, it should go outside of this table, because it depends on LineNo but not on OrderID 3NF You have 3NF pretty much correct above.
Smart Wiki Search. xFruits - Compose your information system. Calculators & generators. Visualization. Statistics.