• Complete TAL Distributors Exercises: QBE 1-10 on Page 65 of Concepts of Database Management.
• Complete the queries after installing TAL Distributors Database which can be obtained at Concepts of Database Management (Links to an external site.) Student Companion Site (Links to an external site.).
• Rename the database to include your own name at the beginning.
• Save each query in the Access database with the exercise number (Query 1, Query 2,, Query 10).
• Zip up the database into a zip file. Do not use 7z, tar, gz, rar, or any other type of compression.
• Submit the zip file with the entire database that includes all 10 queries.

  In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database so you will still have the original data when you complete Chapter 3.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. Check with your instructor if you are uncertain about which approach to take.

• List the number and name of all customers.

• List the complete Item table.

• List the number and name of all customers represented by rep 15.

• List the number and name of all customers that are represented by rep 15 and that have a credit limit of $10,000.

• List the number and name of all customers that are represented by rep 15 or that have a credit limit of $10,000.

• For each order, list the order number, order date, number of the customer that placed the order, and name of the customer that placed the order.

• List the number and name of all customers represented by Megan Gradey.

• How many customers have a credit limit of $15,000?

• Find the total of the balances for all customers represented by rep 30.

• Give the item number, description, and on-hand value (OnHand * Price) for each item in category GME.

  ItemNum	Description	OnHand	Category	Storehouse	Price
  AH74	Patience	9	GME	3	$22.99
  BR23	Skittles	21	GME	2	$29.99
  CD33	Wood Block Set (48 piece)	36	TOY	1	$89.49
  DL51	Classic Railway Set	12	TOY	3	$107.95
  DR67	Giant Star Brain Teaser	24	PZL	2	$31.95
  DW23	Mancala	40	GME	3	$50.00
  FD11	Rocking Horse	8	TOY	3	$124.95
  FH24	Puzzle Gift Set	65	PZL	1	$38.95
  KA12	Cribbage Set	56	GME	3	$75.00
  KD34	Pentominoes Brain Teaser	60	PZL	2	$14.95
  KL78	Pick Up Sticks	110	GME	1	$10.95
  MT03	Zauberkasten Brain Teaser	45	PZL	1	$45.79
  NL89	Wood Block Set (62 piece)	32	TOY	3	$119.75
  TR40	Tic Tac Toe	75	GME	2	$13.99
  TW35	Fire Engine	30	TOY	2	$118.95

  Chapter 2

  Rep

  Customer

  Orders

  OrderLine

  Item

  FIGURE 2-1

  Sample data for TAL Distributors