Question: graph close up. thank you ! Consider a table named ORDER_ITEM, with data as shown below. The schema for ORDER_ITEM is: ORDER_ITEM (OrderNumber, SKU, Quantity,

graph close up. thank you ! Consider a table
graph close up. thank you ! graph close up. thank you ! Consider a table
Consider a table named ORDER_ITEM, with data as shown below. The schema for ORDER_ITEM is: ORDER_ITEM (OrderNumber, SKU, Quantity, 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 Order Number must have at least one SKU associated with it, and may have several. Use this to answer the following questions. 1360 S 50 1. Define INF. Is ORDER_ITEM in INF? If not, why not, and what would have to be done to put it into INF? Make any changes necessary to put ORDER_ITEM into INF. If this step requires you to create an additional table, make sure that the new table is also in INF. 2. Define 2NF. Now that ORDER_ITEM is in INF, 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. 3. Define 3NF. Now that ORDER_ITEM is in 2NF, is it also 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. If this step requires you to create an additional table, make sure that the new table and any other tables created in previous steps are also in 3NF. 1 2 3 4 5 6 7 OrderNumber 1000 1000 2000 2000 3000 3000 3000 SKU 201000 1 202000 1 101100 4 101200 2 100200 1 101100 2 101200 1 Quantity Price 300.00 130.00 50.00 50.00 300.00 50.00 50.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!