Normalization Whole Process Diagram Relation with Anomalies and Dependencies
Third Normal Form (3NF)
Eliminate Repeating Groups
Eliminate Multivalued Dependency
First Normal Form (1NF)
Fourth Normal Form (4NF)
Eliminate Partial Functional Dependency
Second Normal Form (2NF)
Eliminate Transitive Dependency
Eliminate Join Dependency
Fifth Normal Form (5NF)
Simple Normalized Relations without Anomalies and Dependencies
Representation
5 NF
Many-to-M
5NF Process With Example
5 NF
4NF Process With Example
4 NF
Representation
4 NF
Multivalue
Many-to-Ma
Whole Representation up to 3NF 1 NF
2 NF
3 NF
Fun
Tr
N
Representation
3 NF
Funct
Trans
3NF Process With Example
3 NF
Boyce-Codd Normal Form (BCNF) BCNF is a Variation in 3NF
A Relation is said to be in BCNF, If It is in Third Normal Form and Every determinant is a Candidate Key.
A relation R is said to be in BCNF if A -> B, and A is a candidate key for means that determinant should not be a non-key attribute. Any relation that is in BCNF is also in 3NF, but vice versa is not true.
BCNF
Fu
Tr
Representation
1 NF
1NF Process with Example
1NF
Relationship as a Relation (Many-To-Many)
Relationships
Relationship It is an association between two or more relations. Relationship is also represented as a Relation in Relational Data Mode Types of Relationships One-To-One One-To-Many Many-To-One Many-To-Many
Relation Vs Table
Relation is another term for Table with some added constraints It should not contain duplicate rows. Every cell must contain atomic values. It should have a primary key. Table
Relation
Relational Data Model
Relational Data Model is based on Mathematical Relational Algebra. In this model data is represented in the form of Relations even Relations also represented using Relations.
Relation A Relation is a two dimensional table, columns are called as attributes a are called as tuples.
A Relation should satisfy the following rules. Relation should have a unique name in the Database. Attributes should have a unique name and entries in the Attributes shoul same type. Tuples in the Relation should be unique. Cells must contain atomic values. Relation should contain a Primary key.