77.8k views
1 vote
If you have a collection of related attributes that can be considered a subtheme for one of the entities and you remove it, what form is the database now in?

A. Third normal
B. Second normal
C. Fourth normal
D. First normal

1 Answer

3 votes

Answer:

If you have a collection of related attributes that can be considered a subtheme for one of the entities and you remove it, the form of the database is now in Second Normal Form (2NF).

Step-by-step explanation:

In the Second Normal Form, the table is in 1st Normal Form and all non-key attributes are fully dependent on the primary key. It means that the table does not contain any partial dependency, which is when a non-key attribute is dependent on only a part of the primary key and not the entire key.

A database that is in 2NF has been stripped of all attributes that do not depend on the primary key, which is the subtheme that you have removed.

A database in third normal form (3NF) has no transitive dependency.

A database in fourth normal form (4NF) has no multi-valued dependency.

A database in first normal form (1NF) has no repeating groups.

User Iamtheasad
by
8.8k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.