Scribd
Upload
34 views6 pages

Normalization Report 3NF SQL

The document outlines a lab task for a Database Systems course, focusing on normalizing a given table up to the Third Normal Form (3NF). It details the steps taken to achieve 1NF, 2NF, and 3NF, including the creation of separate tables for STUDENT, FACULTY, COURSE, and ENROLLMENT. SQL queries for creating these tables are also mentioned but not included in the summary.

Uploaded by

Maaid Ali Khan
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
34 views6 pages

Normalization Report 3NF SQL

The document outlines a lab task for a Database Systems course, focusing on normalizing a given table up to the Third Normal Form (3NF). It details the steps taken to achieve 1NF, 2NF, and 3NF, including the creation of separate tables for STUDENT, FACULTY, COURSE, and ENROLLMENT. SQL queries for creating these tables are also mentioned but not included in the summary.

Uploaded by

Maaid Ali Khan
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
You are on page 1/ 6

Software Engineering Department

Program: Software Engineering

Course:Database System Lab


Batch: 2024

Course: Database Systems

Submitted To: Submitted By:


Lect.Sumera Aslam Maid Ali
F24608047
Post LAB TASK:

1. Normalize the given table up to 3NF and in word file show relations formed
after applying each normal form 1 to 3

Step 1: First Normal Form (1NF)


The original table is already in 1NF as all fields contain atomic values and each record is
unique.
No repeating groups or multi-valued fields are present.

Step 2: Second Normal Form (2NF)


The table has a composite primary key (STU_ID, COR_ID). To remove partial dependencies:
- Create STUDENT table for STU_ID → STU_Name
- Create COURSE table for COR_ID → CORE_name, Faculty, Teacher_Phone

- Create ENROLLMENT table for the mapping and grade info

SQL Queries to Create Tables


Step 3: Third Normal Form (3NF)
Remove transitive dependency: Teacher_Phone depends on Faculty, not COR_ID directly.
So we separate FACULTY table and remove Teacher_Phone from COURSE.

Final 3NF Relations

1. STUDENT(STU_ID, STU_Name)
2. FACULTY(Faculty, Teacher_Phone)

3. COURSE(COR_ID, CORE_name, Faculty)

4. ENROLLMENT(STU_ID, COR_ID, Grade)

SQL Queries to Create Tables

You might also like