Second Normal Form
Database Normalization, First Normal Form
978-613-7-90807-5
6137908070
68
2011-10-13
29.00 €
eng
https://images.our-assets.com/cover/230x230/9786137908075.jpg
https://images.our-assets.com/fullcover/230x230/9786137908075.jpg
https://images.our-assets.com/cover/2000x/9786137908075.jpg
https://images.our-assets.com/fullcover/2000x/9786137908075.jpg
Second normal form (2NF) is a normal form used in database normalization. 2NF was originally defined by E.F. Codd in 1971. A table that is in first normal form (1NF) must meet additional criteria if it is to qualify for second normal form. Specifically: a 1NF table is in 2NF if and only if, given any candidate key K and any attribute A that is not a constituent of a candidate key, A depends upon the whole of K rather than just a part of it. In slightly more formal terms: a 1NF table is in 2NF if and only if all its non-prime attributes are functionally dependent on the whole of every candidate key. (A non-prime attribute is one that does not belong to any candidate key.) Note that when a 1NF table has no composite candidate keys (candidate keys consisting of more than one attribute), the table is automatically in 2NF.
https://www.morebooks.de/books/gb/published_by/rupt/193157/products
Informatics, IT
https://www.morebooks.de/store/gb/book/second-normal-form/isbn/978-613-7-90807-5