normalization_output.md

Database Normalization Outputs

This file shows the table data for each normalization stage: NNF, 1NF, 2NF, and 3NF.

---

NON NORMALIZED FORM (NNF)

Table: student_all

student_id	student_name	course1	course2	teacher	dept
1	Ram	Math	Science	Mr.A	Science
2	Sita	Math	English	Ms.B	Arts

---

FIRST NORMAL FORM (1NF)

Table: student_course_1nf

student_id	student_name	course	teacher	dept
1	Ram	Math	Mr.A	Science
1	Ram	Science	Mr.A	Science
2	Sita	Math	Ms.B	Arts
2	Sita	English	Ms.B	Arts

---

SECOND NORMAL FORM (2NF)

Table: student_2nf

student_id	student_name
1	Ram
2	Sita

Table: course_2nf

course_name	teacher	dept
Math	Mr.A	Science
Science	Mr.A	Science
English	Ms.B	Arts

Table: enrollment_2nf

student_id	course_name
1	Math
1	Science
2	Math
2	English

---

THIRD NORMAL FORM (3NF)

Table: student_3nf

student_id	student_name
1	Ram
2	Sita

Table: department_3nf

dept_id	dept_name
10	Science
20	Arts

Table: course_3nf

course_id	course_name	dept_id
101	Math	10
102	Science	10
103	English	20

Table: enrollment_3nf

student_id	course_id
1	101
1	102
2	101
2	103