Consider a table named ORDER_ITEM, with data as shown below. The schema for Order_Item is ORDER_ITEM (OrderNumber, SKU, Quantity, Price). In addition to the functional dependency (f.d.) of OrderNumber and SKU, the other f.d. is SKU Price, where SKU is a Stock Keeping Unit number, which is similar to a part number. Here it indicates which product was sold on each line of the table. Note that one OrderNumber must have at least one SKU associated with it, and may have several. Use this table and the detailed discussion of normal forms on the slides to answer the following questions.

Define 1NF. Is ORDER_ITEM in 1NF? If not, why not, and what would have to be done to put it into 1NF? Make any changes necessary to put ORDER_ITEM into 1NF. If this step requires you to create an additional table, make sure that the new table is also in 1NF.

Define 2NF. Now that ORDER_ITEM is in 1NF, is it also in 2NF? If not, why not, and what would have to be done to put it into 2NF? Make any changes necessary to put ORDER_ITEM into 2NF. If this step requires you to create an additional table, make sure that the new table is also in 2NF. Make sure to mark the relationship between two relations by drawing an arrow from the foreign key to its corresponding primary key.

Define 3NF. Is your answer to Step 2 in 3NF? If not, why not, and what would have to be done to put it into 3NF? Make any changes necessary to put ORDER_ITEM into 3NF.

OrderNumber SKU Quantity Price 1 1000 2 1000 3 2000 4 2000 5 3000 6 3000 7 3000 201000 1 202000 101100 4 101200 2 100200 101100 2 1012001 300.00 30.00 50.00 50.00 00.00 50.00 50.00