File HUME mer Design Layout Relerences Malinys Review View Help L of cut E ALI Calibri (Body) 14 A A Aar to BI U va x, x? APA E 6 Copy Paste Format Painter Clipboard v Ev S AaBbCcDc AaBbCcDc AaBb C AaBb Cc AaB AaBbccc AaBbCDi AalbCCD 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Emphasis Font Paragraph Styles Assignment 2 - Part 2 1.) Create a new database named CPD224Training to be used in this class. a. Right click Databases in Object Explorer->New Database b. Use this database to test out your code for the next few steps 2.) Develop the t-sql code that you would use to create a schema called "Production" 3.) Develop the t-sql code in order to create a table with the following specifications. Create this table as part of the Production schema (created in the previous step). 4.) Test out your scripts. 5.) Attach the t-sql code that you have created for steps 2 and 3 to the drop box for this week. Table : Products Sparse Identity IDENTITY (1, 1) Column Name ProductID Description Weight Availability Dt Price InStock Type INT VARCHAR(150) DECIMAL(10, 2) DATETIME MONEY BIT SPARSE Nullability NOT NULL NULL NULL NULL NULL NULL