We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search


+ Link For Assignments, GDBs & Online Quizzes Solution


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

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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


Total Marks: 20


Due Date: 12/05/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:

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).

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


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






Q Draw an E-R diagram for each of the following situations:


  1. Each of Corporation division is composed of many departments. Each of the departments has many employees assigned to it, but each employee works for only one department. The attributes of EMPLOYEE include NAME, ADDRESS, BIRTHDATE and the attributes of DEPARTMENT are DEPT_NO and DEPT_NAME.   5 Marks


  1. During some period of time, a customer can rent many videos from the Video Store. Each of the VideoStore’s can be rented to many customers during that period of time.    5 Marks


  1. An Airline can be assigned to fly many flights, but each flight is flown by only one airline.                 5 Marks


  1. An employee may have earned many degrees, and each degree may have been earned by many employees.       5 Marks 


Guidelines / Instructions

It is required to draw Entity Relationship Diagrams for each of the upper situations using Chen’s notation. A sample can be found at http://en.wikipedia.org/wiki/Entity-relationship_model . It is also required to clearly mention that either the relationship is One-to-One, One-to-Many or Many-to-Many. Figures can be drawn using MS Visio, Erwin or MS Word.

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.Thanks





+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

See Your Saved Posts Timeline

Views: 25


+ 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)

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

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