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

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

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

 

Assignment No. 02
Semester Fall 2011
Database Management Systems-CS403
 

 

Total Marks: 15

 

Due Date: 21 Nov, 2011

 

Objective

To understand the Basics of Drawing ERD

 

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit 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

 

GOOD LUCK 

 

 

 

Draw an ER Diagram of “Inventory Management System” on the basis of information given below. Follow the given “Rules” to draw Cardinalities and Relationships between Entities.

 

 * ERD must be drawn by using MS-Word. No other submitted format is acceptable.

 

Entities and Attributes:

 

Customer:

-          C-ID (Key)

-          C-Name

-          C-Address

-          C-Phone#

 

Order:

-          Order-ID (Key)

-          O-Description

 

Invoice:

-          Inv-ID (Key)

-          Inv-Description

-          Total-Amount

 

 

Product:

-          P-ID (Key)

-          P-Name

-          P-Price

 

Category:

-          Cat-ID (Key)

-          Cat-Description

 

Vendor:

-          V-ID (Key)

-          V-Name

-          V-Address

 

Store:

-          S-ID (Key)

-          S-Location

-          S-Phone#

 

Hall:

-          H-ID (Key)

 

Rules:

 

ü  Customer can place many Orders at a time. He also may not place any Order

ü  There is always one Invoice for each Order.

ü  One Order can have one or many Products. And one Product can be ordered many times or may not be ordered at all.

ü  A Vendor provides many products and it is also possible that organization order single product from multiple vendors.

ü  One Category can have many products, but must have at least one product. And one product must belongs to a single category.

ü  A Store has Products of many Categories. And Products of one Category is always placed in one Store.

ü  One store has multiple halls and one hall belongs to single store.

 

 

 

                                                                             

 

 

 

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 2923

.

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

Attachments:

Replies to This Discussion

yaar kuch karo iss ka please..............exams ki b tayari krni hai aur...........................?

tariq bhai share solution plz

any one to help us............

This link will be very helpful for making this assignment

http://www.google.de/imgres?imgurl=http://www.umsl.edu/~sauterv/ana...

see that idea for  ER Diagram of “Inventory Management System


Kamran you shared really a nice link.. nice to have this.,,,

Yes, I found it good that why posted here. Best of luck..

Thxxxxxx

Complete Solution asi 02

Attachments:

Here is solution of cs403

Here is cs403 assignment do idea solution

Attachments:

first question kahan hy????????????????

RSS

Latest Activity

+ M.Tariq Malik liked Muhammad Naeem Khan's discussion Untitled
24 minutes ago
Fajar liked + "AS"'s discussion Log .
31 minutes ago
Fajar liked +++Student+++++'s discussion MEN
31 minutes ago
Fajar liked +¢αяєℓєѕѕ gιяℓ's discussion شرم سے میرا سر جھک گیا
31 minutes ago
Fajar liked +¢αяєℓєѕѕ gιяℓ's discussion Home remedies for hair fall and regrowth
31 minutes ago
+¢αяєℓєѕѕ gιяℓ posted discussions
39 minutes ago
Fajar liked + "AS"'s discussion Log .
1 hour ago
Awais updated their profile
1 hour ago

Today Top Members 

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

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