Tutorial on Database Schema - Slide 9 - Deliveries from Amazon.com

Back   Next Slide

  1. Deliveries from Amazon.com
    Deliveries go thru a series of progressive stages, such as (alphabetically) :-
    • Cleared Customs
    • Delivered
    • Left Warehouse
Amazon Deliveries
Deliveries
  • Deliveries is a straightforword area to model.
  • We have added just two Tables.
  • The 'Customers_Orders_Delivery' Table keeps a history of the Stages in the delivery of the Order.
  • The 'Ref_Delivery_Status_Codes' tells us what those Stages can be, and they can be displayed in a Drop-down list in an Application.
  • As you can see, a series of records will be stored in the 'Customers_Orders_Delivery' Table.
  • Each record has a different date and time and a different Stage.
  • This Table makes it possible to track the Order to final Delivery.



    © DataBaseAnswers.org 2006