Scribd
Upload
5 views6 pages

Understanding 0NF to BCNF Normalization

The document outlines the normalization process of a student database through various normal forms, starting from 0NF to BCNF. It describes the structure of tables and the rules for each normalization form, ensuring that data is organized without redundancy and dependencies. The final tables include Student, Course, Faculty, and Enrollment, demonstrating a clear separation of entities.

Uploaded by

Muthu Viswanathan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views6 pages

Understanding 0NF to BCNF Normalization

The document outlines the normalization process of a student database through various normal forms, starting from 0NF to BCNF. It describes the structure of tables and the rules for each normalization form, ensuring that data is organized without redundancy and dependencies. The final tables include Student, Course, Faculty, and Enrollment, demonstrating a clear separation of entities.

Uploaded by

Muthu Viswanathan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

StudentId StudentName Courses Faculty FacultyPhone

S101 Ravi DBMS, Java Muthu, Rohan 12345, 98765


S102 Priya DBMS Muthu 12345
S103 Kiran Java, Python Rohan, Pradeep 98765, 22334

0NF: 0 Normalization Form


There are repeating groups
There are multivalued attribute
No clear structure

StudentId StudentName CourseName Faculty FacultyPhone


S101 Ravi DBMS Muthu 12345
S101 Ravi Java Rohan 98765
S102 Priya DBMS Muthu 12345
S103 Kiran Java Rohan 98765
S103 Kiran Python Pradeep 22334

1NF: 1 Normalization Form


Rule:
Each cell should hold exactly one value (there should not be any repeated values or multi-valued colu
Each record (in each and every row) must be unique

Student Table Course Table


StudentId StudentName CourseName Faculty
S101 Ravi DBMS Muthu
S102 Priya Java Rohan
S103 Kiran Python Pradeep

2NF: 2 NORMAL FORM


Rules:
It must be already in 1NF
There should not be any partial dependency

Student Table Course Table


StudentId StudentName CourseName Faculty
S101 Ravi DBMS Muthu
S102 Priya Java Rohan
S103 Kiran Python Pradeep

3NF: 3 NORMAL FORM


Rules:
It must be in 2NF
There should not be Transitive Dependency

Student Table EnrollmentTable


StudentId StudentId
(PK) StudentName (FK) CourseName
S101 Ravi 101 DBMS
S102 Priya 101 JAVA
S103 Kiran 102 DBMS
103 JAVA
103 PYTHON

BCNF: Boyce-Codd Normal Form


Rules:
Must be in 3NF
For every functional dependency ( X -> Y) X must be the super key
d values or multi-valued columns)

EnrollmentTable
FacultyPhone StudentId CourseName
12345 101 DBMS
98765 101 JAVA
22334 102 DBMS
103 JAVA
103 PYTHON

Faculty Table EnrollmentTable


Faculty FacultyPhone StudentId
Muthu 12345 101
Rohan 98765 101
Pradeep 22334 102
103
103
CourseTable Faculty Table
FacultyId FacultyId
CourseName (FK) (PK)
DBMS FAC001 FAC001
JAVA FAC002 FAC002
PYTHON FAC003 FAC003
CourseName
DBMS
JAVA
DBMS
JAVA
PYTHON
Faculty FacultyPhone
Muthu 12345
Rohan 98765
Pradeep 22334

You might also like