SNUM SNAME SAREA CNUM CNAME WNUM WLOC SAMOUNT 3462 Bruce South 18765 18830 Delta Systems 4 Fargo Bismarck 13540 10600 Jon & Jon Co. 3 Bismarck Superior Superior 19242 9700 Tri-Tachyon Imperium Sys. 3...

Table 1 is the Sales table, which is an unnormalized table. The description of the Sales table are SNUM = salesman number, CNUM = customer number, WNUM = warehouse number, SAMOUNT = sale amount, etc.

a.)Write down four functional dependencies (FDs) that are valid in the Sales table

b.)Write down the Sales table's normalization result that is in the 2NF, but not in the 3NF.
Explain why the table is not in the 3NF.

Extracted text: SNUM SNAME SAREA CNUM CNAME WNUM WLOC SAMOUNT 3462 Bruce South 18765 18830 Delta Systems 4 Fargo Bismarck 13540 10600 Jon & Jon Co. 3 Bismarck Superior Superior 19242 9700 Tri-Tachyon Imperium Sys. 3 3593 David North 18841 11560 18899 Anaheim 2590 Piping Drachmae Inc. 19565 Plymouth 8800