Which of the following normal form, all non-key attributes must be fully functional dependent on primary key?
a) 1st normal form
b) 2nd normal form
c) 3rd normal form
d) 4th normal form
Which of the following normal form, all transitive dependencies must be removed?
a) 1st normal form
b) 2nd normal form
c) 3rd normal form
d) 4th normal form
Which of the functions of tables in 2nd normal form?
a) have composite key
b) hidden dependencies eliminated
c) eliminating insertion anomaly
d) none of these
