Question

Provide a normalized data tables for the following table. You have to list step-by step process. (IS 614 student: do 1NF, 2NF, 3 NF; IS 417 student: do 1NF and 2NF) CUSTOMER NAME WAREHOUSE WAREHOUSE NUMBER LOCATION SALES AMOUNT SALESPERSON SALESPERSON SALES CUSTOMER NUMBER NAME AREA NUMBER 3462 Waters West 18765 18830 19242 Dryne East 18841 18899 19565 13540 10600 9700 Delta Systems A. Levy and Sons Ranier Company R. W. Flood Inc. Seward Systems Stodola's Inc. Fargo Bismarck Bismarck Superior Superior Plymouth 3593 11560 2590 8800

Answer 1

Persun FD - selles peosan mubern { sales alume , sales areas. customer number - {customer Alame} Customer name-{warehouse number 1 waoebouse number { Werchove lo caitien} {Selespeosun; Costang omber} - {Salls Ansowt} It is in INF, belso in ant but not in 3N because there is transitive delaton so, we bere to elecompose cte