Scribd
Upload
3 views2 pages

SmartLearn Normalization

The document outlines the normalization process of the SmartLearn Education System, detailing the structure of tables in 1NF, 2NF, and 3NF. In 1NF, a single table contains all student and course information, while 2NF separates data into multiple tables for students, courses, instructors, enrollment, and course-instructor relationships. Finally, 3NF further refines the structure by adding an email field to the instructors table, ensuring that all tables are free from transitive dependencies.

Uploaded by

i243137
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
3 views2 pages

SmartLearn Normalization

The document outlines the normalization process of the SmartLearn Education System, detailing the structure of tables in 1NF, 2NF, and 3NF. In 1NF, a single table contains all student and course information, while 2NF separates data into multiple tables for students, courses, instructors, enrollment, and course-instructor relationships. Finally, 3NF further refines the structure by adding an email field to the instructors table, ensuring that all tables are free from transitive dependencies.

Uploaded by

i243137
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

SmartLearn Education System -

Normalization (1NF, 2NF, 3NF)


1NF Table
StudentCourse_1NF
StudentID (PK), StudentName, Phone, CourseID, CourseName, InstructorName, Semester,
Grade, GPA, Attendance, Department, Room

2NF Tables
Students
StudentID (PK), StudentName, Phone, Department

Courses
CourseID (PK), CourseName, Room

Instructors
InstructorID (PK), InstructorName

Enrollment
EnrollmentID (PK), StudentID (FK), CourseID (FK), Semester, Grade, GPA, Attendance

CourseInstructor
CourseID (FK), InstructorID (FK)

3NF Tables
Students
StudentID (PK), StudentName, Phone, Department

Courses
CourseID (PK), CourseName, Room

Instructors
InstructorID (PK), InstructorName, Email

Enrollment
EnrollmentID (PK), StudentID (FK), CourseID (FK), Semester, Grade, GPA, Attendance
CourseInstructor
CourseID (FK), InstructorID (FK)

You might also like