Assignment 5: Database Refactoring Task Consider the following database relations Order and Orderltem, 1. name the refactoring pattern(s) you use. 2. list every step in the order of changing from the original table structure into new table structure. Assume the Ordered data type is a number. 3. schema update mechanics: include the operations and SQL commands needed to achieve the desired objective 4. data migration mechanics: include the operations and SQL commands needed to achieve the desired objective Original Order and Orderltem Relations: Order Orderltem OrderID PK OrderID Customer Number PK OrderitemNumber Order Date NumberOrdered StorelD ShipTo BillTo Total New Order and Orderltem Relations: Order Orderltem PK Customer Number PK Customer Number PK Order Date PK Order Date PK StorelD PK StorelD ShipTo PK Orderltem Number Billto NumberOrdered Total Assignment 5: Database Refactoring Task Consider the following database relations Order and Orderltem, 1. name the refactoring pattern(s) you use. 2. list every step in the order of changing from the original table structure into new table structure. Assume the Ordered data type is a number. 3. schema update mechanics: include the operations and SQL commands needed to achieve the desired objective 4. data migration mechanics: include the operations and SQL commands needed to achieve the desired objective Original Order and Orderltem Relations: Order Orderltem OrderID PK OrderID Customer Number PK OrderitemNumber Order Date NumberOrdered StorelD ShipTo BillTo Total New Order and Orderltem Relations: Order Orderltem PK Customer Number PK Customer Number PK Order Date PK Order Date PK StorelD PK StorelD ShipTo PK Orderltem Number Billto NumberOrdered Total