Question:
Answer each of the following questions using the TAL Distributors data shown in Figure 1-5. No computer work is required.
1. List the names of all customers that have a credit limit that is less than $10,000.
2. List the descriptions of all items in category GME and that are located in storehouse number 3.
3. List the order numbers for orders placed by customer number 586 on October 15, 2015.
4. List the item number, item description, and on-hand value (OnHand * Price) for each item in category PZL.
5. List the name of each customer that placed an order for two different items in the same order.
6. List the name of each customer that has a credit limit of $5,000 and is represented by Hui Tian.
7. Find the sum of the balances for all customers represented by Rafael Campos.
8. For each order, list the order number, order date, customer number, and customer name.
9. For each order placed on October 13, 2015, list the order number, order date, customer number, and customer name.
10. For each order placed on October 15, 2015, list the order number and customer name, along with the name of the customers sales rep.
11. TAL Distributors needs 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?
12. TAL Distributors wants the database to include data on all its employees, not just sales reps. What additional entities would the DBA need to include in the database to store this data?
Figure 1-5
Transcribed Image Text:
Rep RepNum LastName FirstName Street Campos Gradey Tian Sefton State PostalCode Commission Rate City Rafael 724 Vinca Dr. Grove CA 90092 $23,457.50 $41,317.00 $27,789.25 $0.00 15 0.06 CA 1785 Tyler Ave. Northfield CA CA Megan Hui 632 Liatris St. Fullton 90085 30 0.08 0.06 45 90098 Janet 267 Oakley St. Congaree 60 90097 0.06 Customer State PostalCode Balance $1,210.25 Creditlimit RepNum CustomerNum CustomerName Street City Toys Galore Brookings Direct 452 Columbus Dr. Grove 28 Laketon St. Fullton CA 90085 $7,500.00 15 126 CA 90092 $575.00 $10,000.00 30 260 The Everything Shop Johnson's Department Store 342 Magee St. Congaree CA 90097 $2,345.75 $7,500.00 45 334 124 Main St. Northfield CA $879.25 $7,500.00 30 386 90098 3456 Central Ave. Fullton Grove CA $345.00 $5,000.00 45 440 90085 Historical Museum Store 502 Cards and More 167 Hale St. Mesa CA $5,025.75 $5,000.00 15 90104 Almondton 3345 Devon Ave. Almondton CA $3,456.75 $15,000.00 45 586 90125 General Store Cricket Gift Shop 372 Oxford St. Grove CA 665 90092 $678.90 $4,234.60 $7,500.00 30 $10,000.00 15 Cress Store 12 Rising Sun Ave. Congaree 786 Passmore St. Northfield 945 Gilham St. CA 90097 713 Unique Gifts CA $124.75 $7,500.00 45 796 90098 824 Kline's Mesa CA 90104 $2,475.99 $15,000.00 30 CA All Sesson Gifts 382 Wildwood Ave. Fullton 90085 $935.75 $7,500.00 15 893 Orders OrderLine OrderNum ItemNum NumOrdered QuotedPrice OrderNum OrderDate CustomerNum 10/12/2015 CD33 $86.99 51608 126 51608 10/12/2015 $10.95 334 KL78 51610 51610 25 $13.99 10/13/2015 386 TR40 51613 51610 10 $104.95 51614 10/13/2015 DLS1 260 51613 $124.95 10/15/2015 FD11 51617 586 51614 $115.99 10/15/2015 51617 NL89 51619 126 4. $116.95 10/15/2015 51617 TW35 51623 586 3 FD11 $121.95 10/16/2015 51625 796 51619 $29.95 51623 DR67 $36.95 FH24 51623 12 $13.10 KD34 51623 10 $45.79 МТоз 51625 Item OnHand Category Storehouse Price 9 GME 21 GME ItemNum Description Patience AH74 $22.99 BR23 Skittles $29.99 Wood Block Set (48 piece) CD33 36 TOY $89.49 DL51 Classic Railway Set 12ΤΟΥ $107.95 DR67 Giant Star Brain Teaser 24 PZL. $31.95 DW23 Mancala $50.00 40 GME 3. Rocking Horse Puzzle Gift Set 8 TOY FD11 $124.95 FH24 65 PZL $38.95 Cribbage Set $75.00 KA12 56 GME KD34 Pentominoes Brain Teaser 60 PZL $14.95 KL78 Pick Up Sticks Zauberkasten Brain Teaser 110 GME $10.95 МТоз 45 PZL. $45.79 Wood Block Set (62 piece) Tic Tac Toe Fire Engine NL89 32 ΤΟΥ $119.75 TR40 75 GME $13.99 $118.95 TW35 30 TOY