The reason why a database table is in the first normal form (1NF), but not in the second form (2NF) is because:

a. There is a non-prime attribute that is partially dependent on the key of the table.

b. There is a nested table or a complex object structure embedded in the table.

c. There is an many-to-many relationship embedded in the table.

d. All of a., b., and c.

Question

Computers & Technology

Vanessa Wong

6 April, 17:07

The reason why a database table is in the first normal form (1NF), but not in the second form (2NF) is because:

a. There is a non-prime attribute that is partially dependent on the key of the table.

b. There is a nested table or a complex object structure embedded in the table.

c. There is an many-to-many relationship embedded in the table.

d. All of a., b., and c.

+3

Answers (1)

Know the Answer?

Brayan Charles · Answer 1

Answer:a) There is a non-prime attribute that is partially dependent on the key of the table.

Explanation: The database table that contains the data is found in the normal rather the second form because the first form of the database has the capability of handling the primary key by being dependent partially.

Primary key is used for dealing with the table for unique identification of the attribute. The attribute in the tables has the unique value which is not divisible or atomic. These feature is not present in the second form, that is no non - prime attribute is dependent partially with the unique key of the table. Thus, option (a) is the correct option.