Wednesday, 5 February 2020

Normalization

0 comments

Normalization


? The rules are provided by the normalisation where we decompose the databases to the
minimum level so that there should not be any problems such as concurrency within the
database.
? You can normalise the databases using various forms of normalisation such as 1st NF, 2nd
NF, 3rd NF BCNF and 4NF, 5NF.


Boyce-Codd Normal Form: A relation is in Boyce-Codd Normal Form (BCNF) if and only if
every determinant in the relation is a candidate key.
Non Key Attribute: A non-key attribute is fully functionally dependent on the primary key if it
is functionally dependent on all the attributes comprising the primary key.
Normalization: Normalization consists of a series of rules that should be employed to make
sure that the table is fully normalized by listing the functional dependencies and decomposing
it into smaller, efficient tables.
Transitive Dependency: A transitive dependency arises when a non-key column is functionally
dependent on another non-key column that in turn is functionally dependent on the primary
key.

No comments:

Post a comment