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


+ Link For Assignments, GDBs & Online Quizzes Solution


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

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.


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


Total Marks: 15


Due Date: 21 Nov, 2011



To understand the Basics of Drawing ERD



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






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:



-          C-ID (Key)

-          C-Name

-          C-Address

-          C-Phone#



-          Order-ID (Key)

-          O-Description



-          Inv-ID (Key)

-          Inv-Description

-          Total-Amount




-          P-ID (Key)

-          P-Name

-          P-Price



-          Cat-ID (Key)

-          Cat-Description



-          V-ID (Key)

-          V-Name

-          V-Address



-          S-ID (Key)

-          S-Location

-          S-Phone#



-          H-ID (Key)




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








+ How to Follow the New Added Discussions at Your Mail Address?

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

See Your Saved Posts Timeline

Views: 2946


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

+ Click Here To Join (Our facebook study Group)


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


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


Complete Solution asi 02


Here is solution of cs403

Here is cs403 assignment do idea solution


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


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

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