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:

to change your username, you must:

1) make sure what the username you want to change to is allowed in this community

2) contact a administrator (for example, jaysl)

3) through pm, tell the admin what you want to change to

4) if the username is allowed, it will be changed in a matter of seconds (minutes at most)

~