Answered step by step
Verified Expert Solution
Question
1 Approved Answer
TAL Distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many customers.
TAL Distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many customers. Using this information, convert the following unnormalized relation to fourth normal form.
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commission, Rate))
Rep RepNum LastName FirstName Street Campos Gradey Tian Sefton 15 30 45 60 Customer CustomerNum 126 260 334 386 440 502 586 665 713 796 824 893 Orders OrderNum 51608 51610 51613 51614 51617 51619 51623 51625 Item ItemNum AH74 BR23 CD33 DLS1 DR67 DW23 FD11 FH24 KA12 KD34 KL78 MT03 NL89 TR40 TW35 Rafael Megan Hui Janet CustomerName Toys Galore Brookings Direct The Everything Shop Johnson's Department Store Grove Historical Museum Store Cards and More 724 Vinca Dr. 632 Liatris St. 1785 Tyler Ave. 267 Oakley St. Order Date 10/12/2015 126 10/12/2015 334 10/13/2015 386 10/13/2015 260 10/15/2015 586 10/15/2015 126 10/15/2015 586 10/16/2015 796 Street 28 Laketon St. 452 Columbus Dr. 342 Magee St. 124 Main St. 167 Hale St. 3345 Devon Ave. 372 Oxford St. 12 Rising Sun Ave. 786 Passmore St. CustomerNum 3456 Central Ave. Fullton CA 90085 Almondton General Store Cricket Gift Shop Cress Store Unique Gifts Kline's 945 Gilham St. Mesa All Season Gifts 382 Wildwood Ave. Fullton Description Patience Skittles Wood Block Set (48 piece) Classic Railway Set Giant Star Brain Teaser State PostalCode Commission Rate CA 90092 City Grove Fullton Northfield CA 90098 Congaree CA 90097 CA 90085 Mancala Rocking Horse Puzzle Gift Set Cribbage Set Pentominoes Brain Teaser Pick Up Sticks Zauberkasten Brain Teaser Wood Block Set (62 piece) Tic Tac Toe Fire Engine City Fullton Grove CA Congaree CA Northfield CA 51608 51610 51610 51613 CA Mesa Almondton CA Grove Congaree CA Northfield CA OrderLine OrderNum 51614 51617 51617 51619 51623 51623 51623 51625 OnHand Category 9 GME 21 GME 36 TOY 12 TOY 24 PZL 40 GME 8 TOY 65 PZL 56 GME 60 PZL 110 GME 45 PZL 32 75 GME 30 TOY 3 State PostalCode CA 90085 90092 90097 2 FD11 NL89 TW35 FD11 DR67 FH24 KD34 MT03 1 3 2 3 3 33333 1 3 2 CA Storehouse Price 3 2 2 CA CA 90098 90104 90125 90092 90097 90098 90104 90085 Item Num NumOrdered QuotedPrice CD33 KL.78 TR40 DLS1 $22.99 $29.99 $89.49 $107.95 $31.95 $50.00 $124.95 $38.95 $75.00 $14.95 $10.95 $45.79 $119.75 $13.99 $118.95 5 25 10 5 1 4 3 2 5 12 10 $23,457.50 0.06 $41,317.00 0.08 $27,789.25 0.06 $0.00 0.06 8 Balance CreditLimit Repl $1,210.25 $7,500.00 15 $575.00 $10,000.00 30 $2,345.75 $7,500.00 45 $879.25 $345.00 $7,500.00 30 $5,000.00 45 $5,025.75 $5,000.00 15 $3,456.75 $15,000.00 45 $678.90 $7,500.00 30 $4,234.60 $10,000.00 15 $124.75 $7,500.00 45 $2,475.99 $15,000.00 30 $935.75 $7,500.00 15 $13.10 $45.79 $86.99 $10.95 $13.99 $104.95 $124.95 $115.99 $116.95 $121.95 $29.95 $36.95
Step by Step Solution
★★★★★
3.32 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started