Second normal form - Non key attributes are functional dependent on key attributes - Database

Q.  Database: In second normal form ______________________
- Published on 29 Jun 15

a. A composite attributes is converted to individual attributes.
b. Non key attributes are functional dependent on key attributes.
c. The non key attributes functionally dependent on not a part of key attributes.
d. All the above.

ANSWER: Non key attributes are functional dependent on key attributes.
 
A table is said to be in the second normal form when all the non-key attributes are fully functional dependent on the primary key.

Related Content

 

    Discussion

  • Karan   -Posted on 05 Oct 16
    Non key attributes are functional dependent on key attributes....

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲