Question: In the TAL Distributors database shown in Figure 2-1, the Rep table contains four rows and the Customer table contains 12 rows. How many rows

In the TAL Distributors database shown in Figure 2-1, the Rep table contains four rows and the Customer table contains 12 rows. How many rows would be contained in the Cartesian product of these two tables?


Figure 2-1

Rep RepNum LastName FirstName Street Campos Gradey Tian State PostalCode Commission Rate City Rafael 724 Vinca Dr. Grove

Rep RepNum LastName FirstName Street Campos Gradey Tian State PostalCode Commission Rate City Rafael 724 Vinca Dr. Grove CA $23,457.50 $41,317.00 $27,789.25 $0.00 15 90092 0.06 Megan Hui 632 Liatris St. Fullton CA 30 90085 0.08 1785 Tyler Ave. 267 Oakley St. Northfield Congaree CA 90098 45 0.06 0.06 Sefton Janet CA 60 90097 Customer Creditlimit RepNum $7,500.00 15 CustomerNum CustomerName Street State PostalCode Balance $1,210.25 City Fullton Toys Galore 28 Laketon St. CA 126 90085 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 260 The Everything Shop Johnson's Department Store 342 Magee St. Congaree CA $2,345.75 $7,500.00 45 334 90097 124 Main St. Northfield CA 90098 $879.25 $7,500.00 30 386 Grove Historical 3456 Central Ave. Fullton CA $345.00 $5,000.00 45 440 90085 Museum Store $5,000.00 15 Cards and More 167 Hale St. Mesa CA $5,025.75 502 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 90092 $7,500.00 30 $10,000.00 15 665 $678.90 $4,234.60 12 Rising Sun Ave. Congaree Cress Store CA 713 90097 Unique Gifts 786 Passmore St. Northfield CA $124.75 $7,500.00 45 796 90098 Kline's 945 Gilham St. Mesa CA $2,475.99 $15,000.00 30 824 90104 All Season Gifts 382 Wildwood Ave. Fullton CA 90085 $935.75 $7,500.00 15 893 OrderLine Orders OrderNum OrderDate OrderNum ItemNum NumOrdered QuotedPrice CustomerNum 10/12/2015 51608 CD33 $86.99 51608 126 10/12/2015 $10.95 51610 334 KL78 51610 25 $13.99 10/13/2015 386 TR40 51613 51610 10 $104.95 10/13/2015 DL51 51614 260 51613 FD11 $124.95 10/15/2015 51614 51617 586 $115.99 10/15/2015 NL89 51619 126 51617 4. $116.95 51623 10/15/2015 TW35 586 51617 $121.95 10/16/2015 FD11 51625 796 51619 $29.95 $36.95 S13.10 DR67 51623 51623 FH24 12 KD34 51623 10 $45.79 MT03 51625 Item OnHand Category Storehouse Price ItemNum Description Patience 9 GME 74 $22.99 BR23 Skittles 21 GME $29.99 Wood Block Set (48 piece) 36 TOY 12 TOY CD33 $89.49 DL51 Classic Railway Set $107.95 DR67 Giant Star Brain Teaser 24 PZL $31.95 DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY 65 PZL. $124.95 FH24 Puzzle Gift Set $38.95 Cribbage St Pentominoes Brain Teaser $75.00 KAI2 56 GME KD34 60 PZL $14.95 KL78 Pick Up Sticks 110 GME $10.95 Zauberkasten Brain Teaser $45.79 45 PZL Wood Block Set (62 piece) NL89 $119.75 32 TOY Tic Tac Toe Fire Engine TR40 75 GME $13.99 TW35 30 TOY $118.95

Step by Step Solution

3.52 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The Cartesian p... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1807_60b8c1214282d_716222.pdf

180 KBs PDF File

Word file Icon

1807_60b8c1214282d_716222.docx

120 KBs Word File

Students Have Also Explored These Related Database Concepts Questions!