Databases Reference
In-Depth Information
Source for Order Item Information
The following ORDER_ITEM table contains information about orders placed with the
company, and includes product ID, amount ordered, price of items, and other data.
Display 5.5
The ORDER_ITEM Table
Source for Customer Information
The following CUSTOMER table contains information about the customers who are
placing orders with the company. Information includes name, address, birthdate, and
other data.
Display 5.6
The CUSTOMER Table
In reviewing the previous tables, the data warehousing team identified the following
issues:
The salesperson and salesperson ID must be correlated to determine sales.
The sales totals for each order must be correlated with the correct salesperson.
The sales for each salesperson must be totaled.
Some information does not exist in current source tables. New columns and tables
must be created.
Search WWH ::
Custom Search