O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required