1. Create the actual database of the design in Microsoft SQL Server 2. Use the provided template to begin. 3. Add all DROP tables as instructed 4. Write the CREATE SQL statements to create each table. In doing so, add the constraints to add the primary keys to each table. 5. Ensure each column that is added to each table has the correct and appropriate data type. 6. Once complete with each table, add at least 3 rows of different data to each table. Ensure that the PK in each table is unique. Start and 1 and add 1 to each PK for each table. 7. Write the following SELECT SQL Statements: a. Write a Select SQL statement to return all rows from the Songs Table b. Write a Select SQL statement to return all customers from the Customers Table for customers with a specific last name. c. Write a Select SQL statement to return all rows from the Songs Table for songs recorded after a specific date (based on your data). 8. Write the following UPDATE SQL Statements. Include a select statement before and after each update statement to check if the statement worked as expected. a. Write an Update SQL Statement to change the City for a specific customer. b. Write an Update SQL Statement that will change a specific Record Label to a new name. 9. Write the following DELETE SQL statements: Include a select statement before and after each delete statement to check if the statement worked as expected. a. Write a Delete SQL Statement to delete a specific customer b. Write a Delete SQL Statement to delete all songs for a specific record label