CS403 Assignment No. 2 solution
Saturday, April 23, 2011 Posted In CS and IT Edit ThisAssignment 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:
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:
:::::::::::::::::::::::::::::::::::
Solution:
