TAL Distributors is considering changing its business model so that many sales reps can represent one customer
Fantastic news! We've Found the answer you've been seeking!
Question:
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))
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Intermediate Accounting principles and analysis
ISBN: 978-0471737933
2nd Edition
Authors: Terry d. Warfield, jerry j. weygandt, Donald e. kieso
Posted Date:
Students also viewed these accounting questions
-
Barness Corporation, with sales of $6,480,000, is considering changing its terms from "net 40" to "2/15, net 30." Currently, customers pay on day 45. The company forecasts that 60% of its customers...
-
FIFO and LIFO Harrisburg Company is considering changing its inventory valuation method from FIFO to LIFO because of the potential tax savings. However, the management wishes to consider all of the...
-
Gunter Grass Company is considering changing its inventory valuation method from FIFO to LIFO because of the potential tax savings. However, the management wishes to consider all of the effects on...
-
A health care facility in a metropolitan area is interested in the efficiency of its laboratory turnaround time. Based on data collected over last year, the mean turn around time was found to be 55...
-
One version of Ackermann's function A(m,n) is defined recursively for m, n N by A(0, n) = n + 1, n > 0; A(m, 0) = A(m - 1, 1), m > 0; and A(m, n) = A(m - 1, A(m, n - 1)), m, n > 0. [Such functions...
-
Assume that the pointer in Fig. 11.15 is spun and then the pointer in Fig. 11.16 is spun. Determine the probability of the pointers landing on A color other than red on both spins. Figure 11.15...
-
Respondents Varsity Brands, Inc., Varsity Spirit Corporation, and Varsity Spirit Fashions & Supplies, Inc., design, make, and sell cheerleading uniforms. Respondents have obtained or acquired more...
-
YourTeam.com is an online retailer of college and professional sports team memorabilia, such as hats, shirts, pennants and other sports logo products. Consumers select the college or professional...
-
Blood Money" podcast: What are the uses of human plasma? What is the argument for and against allowing private companies to pay for plasma? Does allowing payment for human bioproducts exploit...
-
Deduce the structure of a compound with molecular formula C 5 H 10 O that exhibits the following IR, 1 H NMR, and 13 C NMR spectra. Data from the mass spectrum are also provided. 100 Mass Spec. Data...
-
Mr. X is engaged in paper business and commenced production of paper on 1 st December, 2018. He has incurred the following expenditure on scientific research. Salary of research staff from 1st...
-
Why do new classical economists argue that in the long run aggregate demand can only affect the price level? Use a diagram to illustrate your answer.
-
The Henry Store has the following data for inventory: Cost Retail Inventory, January 1 $200,000 $400,000 Purchases for January 360,000 480,000 Sales for January 440,000 The store uses the dollarvalue...
-
3. Consider a stock currently priced at $40.. period of one month and for two periods, t appreciate or depreciate by 10%. The per annum. You have the right to shout a you lock in a profit payable at...
-
Do you find yourself unconsciously checking your phone or certain apps? What emotions seem to trigger this behavior? Do you notice a link between your use of certain technologies and how you feel, or...
-
Suppose A is an n n matrix such that A = In. a. Explain why A is invertible. b. What is A-?
-
The demand for electric power at Barton manufacturing over the period 2015 to 2021 is shown in the following table in megawatts. Year Time(t) Electrical Power Demand 2015 106 2016 2 115 2017 3 112...
-
In Exercises 1558, find each product. (9 - 5x) 2
-
Here are the financial statements of YoYo Company. Additional data: 1. Dividends of $36,000 were declared and paid. 2. During the year equipment was sold for $10,000 cash. This equipment cost $15,000...
-
The income statement of Kraemer Inc. reported the following condensed information. Kraemers balance sheet contained these comparative data at December 31. Kraemer has no depreciable assets. Accounts...
-
Twenty-five thousand shares reacquired by Elixir Corporation for $53 per share were exchanged for undeveloped land that has an appraised value of $1,700,000. At the time of the exchange the common...
-
Figure P2.4 shows a graph of position versus frame number from a video clip of a moving object. Describe this motion from beginning to end, and state any assumptions you make. Data from Figure P2.4...
-
What minimum information must be extracted from a video clip of a moving object in order to quantify the object's motion?
-
The sequence in Figure P2.3 represents a ball that is initially held above the ground. In the first frame the ball is released. In subsequent frames the ball falls, bounces on the ground, rises, and...
Study smarter with the SolutionInn App