Types of Functional Dependencies :
Trivial functional dependency
non-trivial functional dependency
Multi-valued dependency
Transitive dependency

Functional dependency in DBMS :
The attributes of a table is said to be dependent on each other when an attribute of a table uniquely identifies another attribute of the same table.

For example: Suppose we have a student table with attributes: Stu_Id, Stu_Name, Stu_Age....

See more

Normalization :

Normalization.pdf

0 Downloads

Boyce Codd normal form (BCNF): It is an advance version of 3NF that’s why it is also referred as 3.5NF. BCNF is stricter than 3NF. A table complies with BCNF if it is in 3NF and for every functional dependency X->Y, X should be the super key of the table.

Third Normal form (3NF) :A table design is said to be in 3NF if both the following conditions hold:


Table must be in 2NF
Transitive functional dependency of non-prime attribute on any super key should be removed.
An attribute that is not part of any can...

See more

Second normal form (2NF) :A table is said to be in 2NF if both the following conditions hold:
Table is in 1NF (First normal form)
No non-prime attribute is dependent on the proper subset of any candidate key of table.
An attribute that is not part of any candidate key is...

See more

First normal form (1NF) :
As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values.


Example: Suppose a company wants to store the names and contact details of its employees. It creates a ta...

See more

Normalization :
Here are the most commonly used normal forms:
First normal form(1NF)
Second normal form(2NF)
Third normal form(3NF)
Boyce & Codd normal form (BCNF)