22.7. Database Design for Customer Order Warehouse
A warehouse chain keeps several items to supply to its customers on the basis of order released by them for particular item(s). The warehouse has number of stores and the stores hold a variety of items. The warehouse is required to meet all of a customer’s order requirements from those stores located in the customer’s city. The warehouse chain wants an efficient database design for its business to meet the increased service demand of its customers.
22.7.1. Requirement Definition and Analysis
The following requirements have been identifies after the detailed analysis of the existing system:
The quantity of items held (QTY-HELD) by each store appears in relation HOLD and the stores themselves ...
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
