We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
Assignment No. 02
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:
For any query about the assignment, contact at firstname.lastname@example.org
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)
- Order-ID (Key)
- Inv-ID (Key)
- P-ID (Key)
- Cat-ID (Key)
- V-ID (Key)
- S-ID (Key)
- 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.
+ 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?
.+ 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?)
cs403 idea solution
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
See the attached file please