CMS Project: Phase II Instructions In this phase, you will create tables based upon the ERD and SQL code below.You will thenpopulate each table with the data presented below. Finally, you will create queries that will be used to support reports for Accounting and Management. You will not actually create the reports in a GUI environment– only the queries that will serve as the basis for the reports. Screenshots are required for a grade to be given. One screenshot is not the idea; however, multiple screenshots along the way is the goal. Background : The following ERD will be used as the basis for this Phase. Part A: Table Creation and Data Loading Instructions : Create a new database in SQL Server and run the following CREATE TABLE commands. Note that you must run the CREATE TABLE statements in the order presented (and load the data in the order presented) to avoid conflicts resulting from foreign key constraints. Additional instructions for materials to turn in for this phase of your project are included at the end of this specification document. CREATE TABLE Regions (RegionID int not null, RegionAbbreviation varchar(4), RegionName varchar(100), CONSTRAINT PK_Regions PRIMARY KEY (RegionID)) CREATE TABLE Countries (CountryID int not null, CountryName varchar(50), WeeklyHours int, Holidays int, VacationDays int, RegionID int, CONSTRAINT PK_Countries PRIMARY KEY (CountryID), CONSTRAINT FK_CountriesRegions FOREIGN KEY (RegionID) References Regions) CREATE TABLE EmployeeTitles (TitleID int not null, Title varchar(15), CONSTRAINT PK_EmpTitles PRIMARY KEY (TitleID)) CREATE TABLE BillingRates (TitleID int not null, Level int not null, Rate float, CurrencyName varchar(5), CONSTRAINT PK_BillingRates PRIMARY KEY (TitleID, Level), CONSTRAINT FK_BillingRatesTitles FOREIGN KEY (TitleID) References EmployeeTitles) CREATE TABLE Employees (EmpID int not null, FirstName varchar(30), LastName varchar(30), Email varchar(50), Salary decimal(10,2), TitleIDint, Level int, SupervisorID int, CountryID int, CONSTRAINT PK_Employees PRIMARY KEY (EmpID), CONSTRAINT FK_EmployeesCountries FOREIGN KEY (CountryID) References Countries, CONSTRAINT FK_EmployeesEmpTitles FOREIGN KEY (TitleID) References EmployeeTitles, CONSTRAINT FK_EmployeeSupervisors FOREIGN KEY (SupervisorID) References Employees) CREATE TABLE ContactTypes (ContactTypeID int not null, ContactType varchar(30) CONSTRAINT PK_ContactTypes PRIMARY KEY (ContactTypeID)) CREATE TABLE ContractTypes (ContractTypeID int not null, ContractType varchar(30) CONSTRAINT PK_ContractTypes PRIMARY KEY (ContractTypeID)) CREATE TABLE BenefitTypes (BenefitTypeID int not null, BenefitType varchar(30) CONSTRAINT PK_BenefitTypes PRIMARY KEY (BenefitTypeID)) CREATE TABLE Clients (ClientID int not null, LegalName varchar(50), CommonName varchar(50), AddrLine1 varchar(50), AddrLine2 varchar(50), City varchar(25), State_Province varchar(25), Zip varchar(9), CountryID int, CONSTRAINT PK_Cli.