Discuss the three phases in normalization
please give a brief explanation
Answers
1. First normal form:
The first step in normalisation is putting all repeated fields in separate files and assigning appropriate keys to them
2. Second normal form:
In this stage of normalisation, all non-key elements that are fully specified by something other than the complete key are placed in a separate table. Normally, these non-key elements are dependent on only a part of a compound key.
3. Third normal form:
This stage of normalisation enables eliminating redundant data elements and tables that are subsets of other tables. The redundant elements are those non-key data elements that are placed in more than one table of the virtual data elements.
Answer:
Normalization is the process of reorganizing data in a database so that it meets two basic requirements: (1) There is no redundancy of data (all data is stored in only one place), and (2) data dependencies are logical (all related data items are stored together). ... Normalization is also known as data normalization
The process of normalisation involves three stages, each stage generating a table in normal form.
First normal form: The first step in normalisation is putting all repeated fields in separate files and assigning appropriate keys to them. ...
Second normal form: ...
Third normal form
In other words 3NF can be explained like this: A table is in 3NF if it is in 2NF and for each functional dependency X-> Y at least one of the following conditions hold: X is a super key of table. Y is a prime attribute of table.
...
Third Normal form (3NF)
Explanation:hope it is helpful to you