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
7.9k points