The correct answer is: C. Normalization
Normalization is the process of organizing data in a database to minimize redundancy and improve data integrity. It is a database design technique that helps to ensure that data is accurate, consistent, and easy to manage.
There are three normal forms: first normal form (1NF), second normal form (2NF), and third normal form (3NF).
1NF is the most basic level of normalization. It requires that each table have a primary key, which is a column or set of columns that uniquely identifies each row in the table.
2NF requires that each table have a primary key and that all non-key columns depend on the primary key. This means that each column in the table must contain data that is related to the primary key.
3NF requires that each table have a primary key and that all non-key columns are not transitively dependent on the primary key. This means that each column in the table must contain data that is directly related to the primary key and not indirectly related through another column.
Normalization is an important part of database design. It helps to ensure that data is accurate, consistent, and easy to manage.
A. Renormalizations is not a correct answer. Renormalization is the process of converting a database from one normal form to another. It is done to improve the performance of the database or to make it easier to maintain.
B. Filtering is the process of selecting a subset of data from a database. It is done to reduce the amount of data that needs to be processed or to focus on a specific set of data.
D. Sorting is the process of arranging data in a specific order. It is done to make the data easier to read or to find specific data.