Chapter 2, Problem 5TD

Explanation of Solution

Tables in the TAL Distributors database:

The TAL Distributors database consists of the following tables:

• REP(REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMMISSION, RATE)
• CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME,STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT)
• ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM, REP_NUM)
• ORDER_LINE (ITEM_NUM, ORDER_NUM, NUM_ORDERED, QUOTED_PRICE)
• ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE)

Here, there exist mainly five tables namely the “REP”, “CUSTOMER”, “ITEM”, “ORDERS”, and “ORDER_LINE” with the respective data. The primary keys for the table “ORDER_LINE” are been listed or use “ITEM_NUM”, “ORDER_NUM” as per requirements...