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?

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


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

cs403 idea solution

Attachments:

thx sir diagrame boht difficult bna de hai but thx idea k leye ....!!!

thx sir imran for question 2 and 1st question b share kr de and question #2 doc file mey share kr dette tu edit krne mey easy ho jata but its ok. ...... so plz share 1st question....!!!

See the attached file for idea 

Attachments:

CS403+Assignment+no+2+Soluton_(www.vustudents.net

See the attached file please

Attachments:

RSS

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

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