CS403 Assignment No. 2 Announced

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: o The assignment is submitted after due date. o The submitted assignment does not open or file is corrupt. o The assignment is copied (from other student or copy from handouts). o The assignment is in the format other than MS Word (doc). 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: a. 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 b. 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