Assignment No. 02 (Graded)
Spring 2025
CS403P- Database Management System (Practical)

Instructions:

Please read the following instructions carefully before solving & submitting the assignment solution:

It should be clear that your assignment will not get any credit (zero marks) if:

o        The assignment is submitted after the due date.

o        The submitted assignment solution does NOT open or the file is corrupt.

o        The assignment is copied (from other students or ditto copy from handouts or the internet).

o        Please ensure that your assignment submission is in .doc or .docx format. Other formats such as scanned images, PDFs, .zip, .rar, .bmp, etc., will not be accepted.

Objectives:

The objectives of this assignment are:

• Understanding and applying normalization (2NF and 3NF) to decompose relations, minimize redundancy, and eliminate partial and transitive dependencies in database design.
• Developing real-world database design skills by identifying functional dependencies and creating structured, efficient, and scalable tables..

Content Covered:  This assignment covers Lectures 18-24 of your course CS403P.

Deadline:  Your assignment must be uploaded/submitted on or before the due date.

For any query about the assignment, contact at cs403p@vu.edu.pk

GOOD LUCK