20764 Administering a Microsoft SQL Database Infrastructure Project 1 Introduction This project will test your knowledge on the labs that you have completed in this course. You will work with the database you created in Assignment 5, making modifications as necessary. Ensure that you have completed Assignments 5, 8 and 10 in their entirety before you begin this project. In addition, before you begin, please ensure that you verify the information that is your RetailSales database, and re-run SQL commands as necessary. Database Structure The following tables should already represent the structure of your RetailSales database. Database: Retail Sales Table Ottawa.Customers Table: Ottawa.Suppliers Column Name Character Type Max Characters Column Name Character Type Max Characters CUSTOMERID int (PK) SUPPLIERID int (PK) FIRSTNAME varchar 100 SUPPLIERNAME varcher 100 LASTNAME varchar 100 ADDRESS varcher 100 ADDRESS varchar 100 CITY varcher 100 CITY varchar 100 PROVINCE varcher 100 PROVINCE varchar 100 POSTALCODE archer 100 PHONENUMBER varchar 100 PHONENUMBER varchar 100 Table Ottawa. Products Table: Transactions Column Name Character Type Max Characters Column Name Character Type Max Characters PRODUCTID int (PK) TRANSNUM int (PK) DESCRIPTION varchar 255 PRODUCTID int (FK] COST money CUSTOMERID int (FK) RETAILPRICE money RETAILPRICE money SUPPLIERID int (FK) QUANTITY int