Scribd
Upload
4 views4 pages

DB Normalization

The document outlines the normalization process of a student enrollment database through First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). It includes tables for Students, Courses, Enrollments, and Instructors, detailing their relationships and attributes. The final structure separates data into distinct tables to eliminate redundancy and ensure data integrity.

Uploaded by

rehanhashmi142005
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
4 views4 pages

DB Normalization

The document outlines the normalization process of a student enrollment database through First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). It includes tables for Students, Courses, Enrollments, and Instructors, detailing their relationships and attributes. The final structure separates data into distinct tables to eliminate redundancy and ensure data integrity.

Uploaded by

rehanhashmi142005
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

StudentID Student Name Course ID Course Name Instructor Instructor Office Grade

101 Ali Raza CS101 DB Design Dr. Ahmed Room 101 A

101 Ali Raza CS102 OOP Dr. Sana Room 102 B+

102 Sara Khan CS101 DB Design Dr. Ahmed Room 101 A-

103 Bilal Akhtar CS103 Networks Dr. Ali Room 103 B

1. First Normal Form (1NF)

2. Second Normal Form (2NF)

Table 1: Students

StudentID StudentName

101 Ali Raza

102 Sara Khan

103 Bilal Akhtar

Table 2: Courses
CourseID CourseName Instructor InstructorOffice

CS101 DB Design Dr. Ahmed Room 101

CS102 OOP Dr. Sana Room 102

CS103 Networks Dr. Ali Room 103

Table 3: Enrollments

StudentID CourseID Grade

101 CS101 A

101 CS102 B+

102 CS101 A-

103 CS103 B

3. Third Normal Form (3NF)

Table 1: Students
StudentID StudentName

101 Ali Raza

102 Sara Khan

103 Bilal Akhtar

Table 2: Enrollments / Grades

StudentID CourseID Grade

101 CS101 A

101 CS102 B+

102 CS101 A-

103 CS103 B

Table 3: Courses
CourseID CourseName InstructorName

CS101 DB Design Dr. Ahmed

CS102 OOP Dr. Sana

CS103 Networks Dr. Ali

Table 4: Instructors

InstructorName InstructorOffice

Dr. Ahmed Room 101

Dr. Sana Room 102

Dr. Ali Room 103

You might also like