We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.


+ Link For Assignments, GDBs & Online Quizzes Solution


+ Link For Past Papers, Solved MCQs, Short Notes & More

Assignment No. 04
Semester Spring 2010
Database Management Systems-CS403


Total Marks:  20


Due Date: 29/06/2010



To learn and understand basic concepts of different levels of Data Flow Diagrams (DFD’s).


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

Assignment should be in your own wordings not copied from net, handouts or books.

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


o        The assignment is submitted after due date.

o        The submitted assignment does not open or file corrupt.

o        The assignment is copied (from other student or copy from handouts or internet).

o        Student ID is not mentioned in the assignment File or name of file is other than student ID.

o        Assignment is not submitted in DOC file.


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






Q1. In which normal form the following STUDENT relation is if only A,B can act as the key.                                            Marks 10
   STUDENT(A, B, C, D, E, F, G, H) Where A, B, C and so on are the attributes of the relation STUDENT.
                   A, B -> C, D, E
                   C -> F
                   D -> G
                   E -> H

Note: Also mention why the relation is in that normal form.


Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10







New Garden Town, Lahore

Blue Area, Islamabad




You are required to normalize this relation into Third Normal Form (3NF).



Upload Instructions:

Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.


 Please Discuss here about this assignment...

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Views: 101

Replies to This Discussion

plz any one share assignmnet plz our just tell me how to solve


Looking For Something? Search Here

Latest Activity

Today Top Members 


This is a member-supported website. Your contribution is greatly appreciated!

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service