Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them
1. There are no duplicated rows in the table.
2. Each cell is single-valued (i.e., there are no repeating groups or arrays).
3. Entries in a column (attribute, field) are of the same kind.
A table is in 2NF if it is in 1NF and if all non-key attributes are dependent on the entire key.
A table is in 3NF if it is in 2NF and if it has no transitive dependencies
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a candidate key
A relation is in 4NF if it has no multi-valued dependencies.
A key uniquely identifies each row in a table. A domain is the set of permissible values for an attribute. By enforcing key and domain restrictions, the database is assured of being freed from modification anomalies. DKNF is the normalization level that most designers aim to achieve.Bca1023, if this helps please login to Mark As Answer. | Alert Moderator