CS403 Database Management Systems Assignment No. 02 Semester Fall 14 November 2011

[Vuhelper]

[B]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
- Order-ID (Reference Key)

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 order 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. And there 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.
[/B]