cs403 assginment no 2 data base management spring 2011 idea solution 25th April

[Xpert]

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
   

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

Please wait solution will be given soon.

[moon13]

we are waiting for your kindness

[Vuhelper]

[size=18]full solution in attachment [/SIZE]

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
ONE to ONE Relation

[harib raza]

helper kia har statement ki alag diagram nahi bnani thi anyways thanks alot

[sanam]

mileys24:yah you may

[Vuhelper]

thanks harib...................... just idea solution ..........you can share your own idea

[qadirbhai]

shukria bhai

[Xpert]

mileys22:welcome mileys2:

[harib raza]

xprt plz siraf itna bta dein k (a) statement and (b) statement ki alag diagrams bnani hain ya (a) mein her statement ki plz guide me
its urgent
plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

[Xpert]

alag alag han janab. same nahi han.