Vuhelper
11-15-2011, 02:45 AM
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.
* 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.