The reason why a database table is in the second normal form (2nf), but not in the third form (3nf) is because:
a. there is a non-prime attribute that is transitively dependent on the key of the table.
b. there is a one-to-many relationship embedded in the table.
c. both a. and b.
d. neither a. nor b.

Hi!

The correct answer is a. There is a non-prime attribute that is transitively dependent on the key of the table.

Explanation:

By definition, a database table is in 3NF if:

since it can be assumed that what aslam is making is a template by compiling all the commonly used excel formatting in several worksheets in an excel document, aslam can choose to save it using the .xltx or .xltm format instead. thus, aslam can distribute the templates he has made to his team members in an easier manner.