Adventure Works Inc is one of the largest suppliers of the motor parts in North America. As part of their IT expansion initiative Mission 2028, they want to revamp their Legacy systems. This includes upgrading their databases from flat files to a RDBMS. The company also wants to aggressively follow up their reports by moving from excel charts to visualization tools like Tableau. The inventory team would like to conduct a pilot test as defined below.

Use AdventureWorks2012

1. SQL Server The Inventory team wants to create a new table which is a subset of the Product table, that is used in the Production environment. The new table should have the ProductID, Name, ProductNumber and MakeFlag. There should be no duplicate columns. Also the field MakeFlag should be renamed to NEW_MakeFlag. Paste a Screenshot 10 points

2. SQL Server The team wants to make sure that no duplicates are inserted in this new custom table. Since the size of the table is small, they decided to go ahead and insert all the rows from the parent table, each time the SSIS package was executed. Paste a Screenshot 10 points