The Office Supplies Delivery Company(OSDC) specialises in supplying stationery and office supplies to small businesses.They plan to develop a database using a relational database management system(RDBMS) to store their order processing information.The requirements for this proposed system include the following:- i. Customers are identified by a unique customer number which must be stored along with the customer name and address. ii. Customers place orders either by telephone or by post using a preprinted order form. iii. An order may be for one or more order items.Each order has a unique order number. The date the order was placed and the total cost of the order will be recorded. iv. Each order item is for a single product, however, the quantity of that product ordered in an order item may be greater than one.An order item number is recorded along with the quantity ordered and the extended cost(i.e. product price x quantity ordered). v. Products may be purchased from more than one supplier and a supplier may provide more than one product. vi. Each product has a unique code,a description and a price. vii. Suppliers’ names and addresses need to be stored. Produce an entity relationship diagram that accurately models the information Listed above. (Include on diagram attributes and the cardinality of each relationship.You do not need to resolve many to many relationships or show participation constraints.)
The Office Supplies Delivery Company(OSDC) specialises in supplying stationery and office supplies to small businesses.They plan to develop a
i. Customers are identified by a unique customer number which must be stored along with the customer name and address.
ii. Customers place orders either by telephone or by post using a preprinted order form.
iii. An order may be for one or more order items.Each order has a unique order number. The date the order was placed and the total cost of the order will be recorded.
iv. Each order item is for a single product, however, the quantity of that product ordered in an order item may be greater than one.An order item number is recorded along with the quantity ordered and the extended cost(i.e. product price x quantity ordered).
v. Products may be purchased from more than one supplier and a supplier may provide more than one product.
vi. Each product has a unique code,a description and a price.
vii. Suppliers’ names and addresses need to be stored.
Produce an entity relationship diagram that accurately models the information Listed above.
(Include on diagram attributes and the cardinality of each relationship.You do not need to resolve many to many relationships or show participation constraints.)
Step by step
Solved in 2 steps with 1 images
