File Home Insert Design Layout References Mailings Review View Help Assignment 3 Use Listing 1-1 in the text as a guide for the steps to complete the questions/steps below. The steps will guide you to use column-level encryption on a column named Credit CardNo. The column is encrypted using a symmetric key protected by a password. Please make sure to put all answers into a single PDF or Word/RTF document. Do not submit as separate files please. In the document, include all steps as I have listed here. For each step, show your code as well as a screenshot of the results when you run your code. 1.) Create a new table in database CPD224 called Customers with the following columns and properties: CustomerID datatype INT primary key LastName datatype varchar size 25 and set to not allow null values FirstName datatype varchar size 25 Email datatype varchar size 20 CreditCard No varbinary size 128 2.) Create a symmetric key by password with algorithm AES_256 (use example on listing 1-1 as a guide). 3.) Open the symmetric key that you just created. File Home Insert Design Layout References Share Mailings Review View Help 4.) Insert 5 rows of data into Customers and use ENCRYPTBYKEY to encrypt the CreditCardNo column data. 5.) Query to select all rows from table Customers. 6.) Query to select all rows from table Customers again, but this time show decrypted CreditCardNo data. 7.) Close the symmetric key created above. 8.) Repeat the same code as you executed in Step #6 above. 9.) Explain why the result set in step 6 is different than step 8. 10.) The above example encrypts data using a symmetric key protected by password. Another way to do this is to use a certificate. Explain why you may choose to use a certificate instead of a password to protect the symmetric key. n'e... E 2