VUsolutions Transferred to AchiKhasi.com

From December 2011, this blog www.VUsolutions.blogspot.com is transferred to http://achikhasi.com/vu/ . So, you may visit http://achikhasi.com/vu/ for latest study related help.

Back to home VUsolutions

VUsolutions Fans Club [join us for MORE solutions]

VUsolutions on Facebook

CS403 Assignment No. 2 solution

Saturday, April 23, 2011 Posted In Edit This
Assignment No. 02 

Semester Spring 2011

Database Management Systems-CS403




Total Marks: 15


Due Date: 25/04/2011




Objective:
To learn and understand basic concepts of ER Diagram.

Instructions:
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:

  • The assignment is submitted after due date.
  • The submitted assignment does not open or file is corrupt.
  • The assignment is copied (from other student or copy from handouts).
  • The assignment is in the format other than MS Word (doc).
  • 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.       A University has many departments whereas each department belongs to that particular university. That university has also many buildings whereas each building belongs to that particular university. The University also has many employees whereas each employee belongs to that particular university. Every employee has only one parking space whereas each parking space belongs to only one employee. Department offers many study programs whereas each programs offered by only a single department. 7.5 Marks

2.       In a shopping Store there are many supervisors whereas each supervisor belongs to one store. Product belongs to a single vendor whereas vendor provides so many products. Product belongs to a single category whereas category has many products. A category belongs to a single shelf in a store whereas a shelf may have more than one categories’ products.7.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
:::::::::::::::::::::::::::::::::::


Solution:








Back to home VUsolutions

Shaadi.com: Just create ur account & find ur partner or EARN money, its reall & EASY

VUsolutions Followers (Join NOW and Get Extra Benefits)

Install LATEST toolbar having lot of features - GET solutions on Desktop

toolbar powered by Conduit
Caliplus 300x250 NoFlam VitoLiv 468x60 GlucoLo