Scribd
Upload
12 views2 pages

Database Normalization Assignment

The document outlines the normalization process of a Teacher Data Table through four stages: Unnormalized Form (UNF), First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). It details how the data is organized into separate tables to eliminate redundancy and ensure data integrity. The final structure consists of distinct tables for Teachers, TeacherSubjects, and Departments.

Uploaded by

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

Database Normalization Assignment

The document outlines the normalization process of a Teacher Data Table through four stages: Unnormalized Form (UNF), First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). It details how the data is organized into separate tables to eliminate redundancy and ensure data integrity. The final structure consists of distinct tables for Teachers, TeacherSubjects, and Departments.

Uploaded by

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

Normalization of Teacher Data Table

Unnormalized Form (UNF)


TeacherID TeacherNam Subjects ContactNum Department Department
e bers Head

1 Mr. Ali Math, 123456, Science Dr. Khan


Physics 789101

2 Ms. Sara Chemistry 456789 Science Dr. Khan

3 Mr. Ahmed Math, 112233, Arts Dr. Ahmed


English 445566

First Normal Form (1NF)


TeacherID TeacherNam Subject ContactNum Department Department
e ber Head

1 Mr. Ali Math 123456 Science Dr. Khan

1 Mr. Ali Physics 789101 Science Dr. Khan

2 Ms. Sara Chemistry 456789 Science Dr. Khan

3 Mr. Ahmed Math 112233 Arts Dr. Ahmed

3 Mr. Ahmed English 445566 Arts Dr. Ahmed

Second Normal Form (2NF)

Table 1: Teacher
TeacherID TeacherName Department DepartmentHead

1 Mr. Ali Science Dr. Khan

2 Ms. Sara Science Dr. Khan

3 Mr. Ahmed Arts Dr. Ahmed

Table 2: TeacherSubjects
TeacherID Subject
1 Math

1 Physics

2 Chemistry

3 Math

3 English

Table 3: TeacherContacts
TeacherID ContactNumber

1 123456

1 789101

2 456789

3 112233

3 445566

Third Normal Form (3NF)

Table 1: Teacher
TeacherID TeacherName Department

1 Mr. Ali Science

2 Ms. Sara Science

3 Mr. Ahmed Arts

Table 4: Department
Department DepartmentHead

Science Dr. Khan

Arts Dr. Ahmed

You might also like