Description
Assignment: Reading Data from Tables:
Please see attachment with screenshot of figure 1-5.
The exercises in this assignment will allow you the opportunity to practice reading data from tables. The questions require you to recall and apply the basic concepts of database management and challenge your problem-solving and analytical skills.
Refer to the TAL Distributors data represented in Figure 1-5, in Chapter 1, of Concepts of Database Management. (Pratt & Last, 2015, p. 7). Then, in a Word document, address the following:
List the names of all the customers that have a credit limit that is less than $10,000.
List the order numbers for orders placed by customer number 586 on October 15, 2015.
List the name of each customer that placed an order for two different items in the same order.
Find the sum of the balances for all customers represented by Rafael Campos.
For each order placed on October 13, 2015, list the order number, order date, customer number, and customer name.
TAL Distributors need to be able to contact customers when problems arise concerning an order. What other attributes could TAL include in the Customer table to assist in contacting customers?