What is normalization in database?AThe process of creating a table structureBThe process of converting data into a more structured formCThe process of deleting irrelevant data

Normalization in database is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.

Here are the steps to understand it better:

1. Creating a table structure: This is the first step in normalization. It involves creating tables for different types of data. For example, if you have a database for a school, you might have a table for students, another for teachers, and another for classes.

2. Converting data into a more structured form: This is the second step in normalization. It involves taking the data that you have and converting it into a form that makes it easier to work with. This might involve breaking down data that is in a large, unwieldy format into smaller, more manageable pieces.

3. Deleting irrelevant data: This is the third step in normalization. It involves removing data that is not necessary for the database. This might involve deleting duplicate data, or data that is not relevant to the purposes of the database.

So, in summary, normalization in database is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.