Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:Options1NF2NFNone of these3NFAll of these

The form that simplifies and ensures that there are minimal data aggregates and repetitive groups is 3NF (Third Normal Form).

Here's why:

1NF (First Normal Form) only ensures that each column in a table has atomic (indivisible) values. It doesn't necessarily reduce data aggregates or repetitive groups.

2NF (Second Normal Form) goes a step further and removes partial dependencies, i.e., it ensures that no column is dependent on a part of the primary key. However, it still doesn't guarantee minimal data aggregates or repetitive groups.

3NF (Third Normal Form) is the form that simplifies and ensures minimal data aggregates and repetitive groups. It removes transitive dependencies, i.e., it ensures that no non-key column is dependent on another non-key column. This results in a database design with minimal data aggregates and repetitive groups.

So, the correct answer is 3NF.