Instructions for assignment 4 Create Tables amp; Indexes EACH DELIVERABLE IS NOTED WITH TWO DOLLAR SIGNS IN FRONT (SS), COLORED RED AND IS WORTH 10

Please answer the questions without requiring the database. I do not need the Results. I just need you to do the SQL commands. Thanks.

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4

Instructions for assignment 4 — Create Tables & Indexes EACH DELIVERABLE IS NOTED WITH TWO DOLLAR SIGNS IN FRONT (SS), COLORED RED AND ISWORTH 10 POINTS artial credit will be iven as a ro riate 1) USE THIS WORD DOC AND INSERT THE DELIVERABLES WHERE INDICATED - PLEASE NOTE THAT 2) ALL SCREENSHOTS SHOULD BE FULL-SCREEN SCREENSHOTS (no cropped screenshots)Create all of the following objects within the AdventureWork52014 database that you restored in assignment #3 For all of the belowI you are free to use SSMS or T-SQL I however. T-SQL is recommended due tothe details requested and deliverables needed The intent of this exercise is to create a new set of tables and indexes under a new schema addedto the Adventu reWork52014 database — PLEASE READ INSTRUCTIONS CAREFULLY TO CATCH ALLOF THE NUANCES BEING REQUESTED 3)4) 5) Create a new schema named CustomerService with owner of dbo. Create a new filegroup in the AdventureWork52014 DB containing one file — name the filegroupAD_CustomerService and file whatever you wish, but use standard naming convention for thesuffix. ($$)DEL|VERABLE - Take a screenshot of the database properties in SSMS showing the newfilegroup and file. Paste the screen shot in the word doc below: Create a new CLUSTERED table named CustomerService.Reps on the newly created Filegroupwith the following columns and properties:a. Column called ReplD that is the primary key and an ever—increasing unique integer (useIdentity property and make this the primary clustered key)b. Column called BusinessEntitle that is integer and must exist in the Person.Person table,if populated (enforce with referential integrity with the BusinessEntitle column in thePerson table — DO NOT CASCADE DELETES or UPDATES and nulls are not allowed)c. Column called SupervisorID that is integer and must exist in the Person.Person table, ifpopulated (enforce with referential integrity with the BusinessEntitle column in thePerson table — DO NOT CASCADE DELETES or UPDATES and nulls are not allowed)Table should be compressed at the page level($$)DELIVERABLE — COPY THE T_SQL TO CREATE THE ABOVE TABLE INTO THE WORDDOC BELOW: Create a unique index on the BusinessEntitle column (you can use the ALTER TABLE command)that sorts in temp_db and is created online - ($$)DELIVERABLE-COPY THE T_SQL TO CREATETHIS INDEX INTO THE WORD DOC BELOW: Create a new CLUSTERED table named CustomerService.Contacts on the newly createdFilegroup with the following columns and properties: