Exercise 17-6 [20 points] Write a script that (1) creates a schema named Admin, (2) transfers the table named Addresses from the dbo schema to the Admin schema, (3) assigns the Admin schema as the default schema for the user named RobertHalliday that you created in exercise 2, and (4) grants all standard privileges except for REFERENCES and ALTER to RobertHalliday for the Admin schema.

Language is SQL Server Management Studio (SQL Server Express 2017)

Here is exercise 2: Write a script that (1) creates a login ID named RobertHalliday with the password HelloBob; (2) sets the default database for the login to the MyGuitarShop database; (3) creates a user named RobertHalliday for the login; and (4) assigns the user to the OrderEntry role you created in exercise 1.

The script is what you're creating