1
University of Management and Technology,
Lahore Campus
Assignment # 05 – Spring 2024
Course Name:
Database Systems
Course Code:
CC2141
Credit Hours:
3(2,1)
Course Instructor/s:
Mr. Muhammad Ehsan
Program Name
BS Computer Science
Semester/ Section:
BSCS 4th, V4
Maximum Marks:
10
Submission
Deadline:
Friday, June 11, 2024
Moderator Signature
Instructions:
• The aim of this assignment is to learn the basics of Normalization.
• The assignment assessment will be based on the correctness of your answer and also based on
your effort.
• I can take either quiz or in-class viva for this assignment by calling anyone from the class.
• Note: There will be NO LATE submissions allowed. And if you submit the assignment after the
deadline, it will be considered unsubmitted and you will be given ‘0’ marks.
Questions: CLO-3
Normalize the tables up to the fourth normal form.
Question 1:
