A manager asks that a data table listing corporate equipment be decomposed into smaller tables leaving the concatenation of the Salesperson Number and Order Number as the primary key

Which step in data normalization is this

• First normal form
• Second normal form
• Third normal form
• Fourth normal form
   

Salesperson Salesperson Order Name Number Number 119 Salesperson Table 137 186 186 255 361 420 452 Taylor, A Baker, B Adams, A Adams, A Lincoln, J Carlyle, L Green, C French, F City New 102 York 192 Detroit 324 Dallas 544 Dallas 232 Atlanta 123 Detroit 333 Tucson 432 New York Commission Rate 20% 10% 5% 5% 5% 7% 11% 8%