Saved Bookmarks
| 1. |
According to normalization rules a table is said to be in second normal form if and only if it is |
| Answer» In a table, if attribute B is functionally dependent on A, but is not functionally dependent on a proper SUBSET of A, then B is considered fully functional dependent on A. Hence, in a 2NF table, all non-key attributes cannot be dependent on a subset of the primary key. Note that if the primary key is not a composite key, all non-key attributes are always fully functional dependent on the primary key. A table that is in 1st normal FORM and CONTAINS only a single key as the primary key is automatically in 2nd normal form. | |