Question:
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. In each step, indicate how to use relational algebra to obtain the desired results.
1. List the number and name of all reps.
2. List all information from the Item table for item FH24.
3. List the order number, order date, customer number, and customer name for each order.
4. List the order number, order date, customer number, and customer name for each order placed by any customer represented by the rep whose last name is Campos.
5. List the number and date of all orders that were placed on 10/15/2015 or that were placed by a customer whose rep number is 30.
6. List the number and date of all orders that were placed on 10/15/2015 by a customer whose rep number is 45.
7. List the number and date of all orders that were placed on 10/15/2015 but not by a customer whose rep number is 45.
Figure 2-1
Transcribed Image Text:
Rep RepNum LastName FirstName Street Rafael Megan Hu Janet State PostalCode Commission Rate City 724 Vinca Dr. 632 Liatris St. 1785 Tyler Ave. 267 Oakley St. Campos Gradey Tian Grove CA $23,457.50 $41,317.00 $27,789.25 $0.00 15 90092 0.06 Fullton CA 30 90085 0.08 CA Northfield Congaree 45 90098 0.06 Sefton CA 60 90097 0.06 Customer CustomerNum CustomerName Street Toys Galore State PostalCode Balance $1,210.25 CreditlLimit RepNum $7,500.00 15 City Fullton 28 Laketon St. CA 126 90085 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 260 | The Everything Congaree 342 Magee St. CA 90097 $2,345.75 $7,500.00 45 334 Shop Johnson's Department Store $879.25 386 124 Main St. Northfield CA $7,500.00 30 90098 CA Grove 3456 Central Ave. Fullton 90085 $345.00 $5,000.00 45 440 Historical Museum Store Меза Cards and More 167 Hale St. CA $5,025.75 $5,000.00 15 502 90104 Almondton General Store 3345 Devon Ave. Almondton CA $3,456.75 $15,000.00 45 586 90125 Cricket Gift Shop 372 Oxford St. Grove CA 665 90092 $678.90 $4,234.60 $10,000.00 15 $7,500.00 30 12 Rising Sun Ave. Congaree 786 Passmore St. Northfield 945 Gilham St. Cress Store CA 90097 713 Unique Gifts CA $124.75 $7,500.00 45 796 90098 Kline's Mesa CA 90104 $2,475.99 $15,000.00 30 824 All Season Gifts 382 Wildwood Ave. Fullton CA $935.75 $7,500.00 15 893 90085 Orders OrderLine NumOrdered QuotedPrice OrderNum ItemNum OrderNum OrderDate CustomerNum 10/12/2015 126 CD33 $86.99 51608 51608 10/12/2015 $10.95 334 KL78 51610 51610 25 $13.99 10/13/2015 386 51610 TR40 51613 10 $104.95 10/13/2015 51613 DLS1 51614 260 $124.95 10/15/2015 FD11 51617 586 51614 NL89 $115.99 10/15/2015 51619 126 51617 $116.95 10/15/2015 586 TW35 51623 51617 $121.95 10/16/2015 FD11 51625 796 51619 $29.95 DR67 51623 $36.95 FH24 51623 12 $13.10 KD34 51623 10 $45.79 51625 МТоз Item ItemNum Description OnHand Category Storehouse Price 9 GME AH74 Patience $22.99 BR23 Skittles 21 GME $29.99 CD33 Wood Block Set (48 piece) Classic Railway Set 36 ΤΟΥ $89.49 DL51 12ΤΟΥ $107.95 24 PZL DR67 Giant Star Brain Teaser $31.95 DW23 Mancala 40 GME $50.00 Rocking Horse Puzzle Gift Set 8 TOY FD11 $124.95 FH24 65 PZL $38.95 Cribbage St Pentominoes Brain Teaser 56 GME $75.00 KA12 KD34 $14.95 60 PZL KL78 Pick Up Sticks 110 GME $10.95 МТоз NL89 Zauberkasten Brain Teaser 45 PZL $45.79 Wood Block Set (62 piece) 32 ΤΟΥ $119.75 Tic Tac Toe Fire Engine TR40 75 GME $13.99 TW35 30 ΤΟΥ $118.95