KEMBAR78
Assignment#4 and Solution | PDF | Databases | Information Technology Management
Scribd
Upload
22 views3 pages

Assignment#4 and Solution

The document outlines an assignment for a Database Systems lab course at COMSATS University Islamabad, focusing on normalization techniques. It provides an unnormalized table for a university course registration system and details the transformation process to First, Second, and Third Normal Forms. The assignment emphasizes the identification of redundancies and the creation of separate tables for students, courses, and enrollments.

Uploaded by

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

Assignment#4 and Solution

The document outlines an assignment for a Database Systems lab course at COMSATS University Islamabad, focusing on normalization techniques. It provides an unnormalized table for a university course registration system and details the transformation process to First, Second, and Third Normal Forms. The assignment emphasizes the identification of redundancies and the creation of separate tables for students, courses, and enrollments.

Uploaded by

tariqrafiqch
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

COMSATS University Islamabad

Sahiwal Campus
(Department of Computer Science)
Course Title: Database Systems (Lab) Course Code: CSC270 Credit Hours: 4(3,1
Course Instructor: Dr. Muhammad Inaam ul haq Programme Name: Bachelor of Science in CS )))
Semester: 5 Batch: SP23 Section: C C_CS_________
Date: 13/5/2025
Time Allowed: Two weeks Maximum Marks: 10
Student’s Name: Reg. No. CUI/ /SWL
CLO3
CLOs Question Max. Obtained Question Max. Obtained Question Max. Obtained
Addressed Nos. Marks. Marks Nos. Marks. Marks Nos. Marks. Marks
1 10
Important Instructions / Guidelines:
Read the question paper carefully and answer the questions according to their statements.

Assignment#4
CLO-3 Apply the data modeling and normalization techniques to design database for small
to medium size enterprise

Q.1 You are provided with the following Unnormalized Table (UNF) extracted from a proposed
database design for a university course registration system:
StudentID StudentName PhoneNumber Course1_ Course1_Name Course1_Instructor Course2_ID Course2_Name Course2_Instructor
ID
101 Alice Smith 555-1234 CS101 DBMS Dr. Thomas CS102 OS Dr. Richard

102 Bob Jones 555-5678 CS101 DBMS Dr. Thomas NULL NULL NULL

Analyze the table and identify the repeating groups or redundancies. Convert the above
unnormalized table into:

• First Normal Form (1NF)


• Second Normal Form (2NF)
• Third Normal Form (3NF)
Normalization Assignment Solution
This document presents the solution for normalization of a student enrollment system. The
process covers transformation from Unnormalized Form (UNF) to First Normal Form (1NF),
Second Normal Form (2NF), and finally to Third Normal Form (3NF).

Unnormalized Form (UNF)


UNF contains repeating groups and non-atomic values:

Stude Student PhoneN Cours Course1 Course1_I Cours Course2 Course2_I


ntID Name umber e1_ID _Name nstructor e2_ID _Name nstructor

101 Alice 555- CS101 DBMS Dr. CS102 OS Dr. Richard


Smith 1234 Thomas

102 Bob 555- CS101 DBMS Dr. NULL NULL NULL


Jones 5678 Thomas

First Normal Form (1NF)


Repeating groups removed; all values are atomic.

StudentID StudentName PhoneNumber Course_ID Course_Name Course_Instructor

101 Alice Smith 555-1234 CS101 DBMS Dr. Thomas

101 Alice Smith 555-1234 CS102 OS Dr. Richard

102 Bob Jones 555-5678 CS101 DBMS Dr. Thomas

Second Normal Form (2NF)


Removed partial dependencies by decomposing into Student, Course, and Enrollment tables.

Student Table:

StudentID StudentName PhoneNumber

101 Alice Smith 555-1234

102 Bob Jones 555-5678


Course Table:

Course_ID Course_Name Course_Instructor

CS101 DBMS Dr. Thomas

CS102 OS Dr. Richard

Enrollment Table:

StudentID Course_ID

101 CS101

101 CS102

102 CS101

Third Normal Form (3NF)


No transitive dependencies exist. The schema is in 3NF.

Summary
Form Description

UNF Repeating course columns per student

1NF Flattened rows, one course per row

2NF Separated student and course details

3NF No transitive dependencies

You might also like