Step ladie creatki Create a new database and execute the code below in SQL Server's query window to create the database tables. CREATE TABLE PhysicianSpecialties. (Specialtvik integer, Specialty Name varchar(50), CONSTRAINT PK_PhysicianSpecialties PRIMARY KEY (SpecialtyIn)) go CREATE TABLE ZipCodes (Zincade varchar(10), city varchar(se), State varchar(2) CONSTRAINT PK ZipCodes PRIMARY KEY (Zincode>> 80 CREATE TABLE RhysicianPractices PracticeIR integer PitasticeName archar 50) Address Line1 yarchan 5e Addressiline2 barchani se Lincode Warcharlie Phone Wanchar 14 Fax vachan 14 WebsiteURL varchanie CONSTRAINT PK Physicianrractices PRIMARY KEY ice CONSTRAINTIFKI PhysicianPractices uzicades FOREIGN KEY ZipCode REFERENCES Zipcodes 89 CREATE TABLE Physicians (Physician integer, FirstName varchar(40), LastName varchar(50). PracticeIn integer, SpecialtyID integer, Email varchar(50), CONSTRAINT PK Physicians PRIMARY KEY (PhysicianID). CONSTRAINT EK Physicians Practices FOREIGN KEY (PracticeID) REFERENCES_PhysicianPractices, CONSTRAINT EK. Physisians PhysicianSpecialities FOREIGN KEY (SpecialtyID REFERENCES PhysicianSpecialties) go CREATE TABLE Patients (Patient in integer FirstName varchar(5e), Middletoitial varchar(1), LastName varchar(50) Address Line1 varchar(50) Address_Line2 varchar(50) ZipCode varchar(10) Phone Home varchar(14), Phone Alternate varchar(14) Email varchar(50) CONSTRAINT PK Patients. PRIMARY KEY Patient ID) go CREATE TABLE Referrals (ReferralID integer, StartDate small.datetime, EndDate smalldatetime, Patient ID integer Physiciant integer CONSTRAINT PK Referrals PRIMARY KEY (ReferralID CONSTRAINT FK Referrals Patients FOREIGN KEY PatientID REFERENCES Patients CONSTRAINT FK Referrals Physicians FOREIGN KEY (PhysicianID REFERENCES Physicians) go DV CREATE TABLE Services (ServiceID integer, ServiceName varchar(50), CONSTRAINT PK ServiceID PRIMARY KEY (ServiceID)) go CREATE TABLE Frequencies (FrequencyID integer, Frequency varchar(30), CONSTRAINT PK Frequencies. PRIMARY KEY (FrequencyID)) BO CREATE TABLE ReferralServices (ReferralID integer, Service ID integer, Erequency ID integer, CONSTRAINT PK ReferralServices. PRIMARY KEY Referral ServiceID) CONSTRAINT FK Referral Services Referrals FOREIGN KEY ReferralID REFERENCES Referrals, CONSTRAINT EK Referralservices Services FOREIGN KEY ServiceID REFERENCES Services, CONSTRAINT EK ReferralServices Frequencies FOREIGN KEY FrequencyID REFERENCES Frequencies) go CREATE TABLE Payment Tyres. (PaymentTypeID integer, Payment Type varchar(25), CONSTRAINT PK Payment Types PRIMARY KEY (Payment TypeID)) go CREATE TABLE InsuranceCompanies. (InsuranceID integer, Insurance Company varchar(50), Address Line1 varchar(50), Address Line2 varchar(50), ZipCode varchar(10), Phone varchar(15), Fax varchar (15) Email varchar. 50) CONSTRAINT PK Insucance Companies. PRIMARY KEY InsuranceID CONSTRAINT EK Insurance Companies ZipCodes FOREIGN KEY (ZipCode) REFERENCES ZipCodes) go CREATE TABLE Contracts Contractin integer Intent StartDatelemat Hatetime Contractin integer, ReferralID integer, StartDate smalldatetime, EndDate smalldatetime, Payment TypeID integer, Insurance ID integer, NegotiatedRate float, CONSTRAINT PK Contracts PRIMARY KEY (ContractID), CONSTRAINT PK Contracts Referrals FOREIGN KEY (ReferralID REFERENCES Referrals, CONSTRAINT EK.Contracts Payment Types. FOREIGN KEY (Payment TypeID REFERENCES Payment Types, CONSTRAINT EK Contracts Insurance companies. FOREIGN KEY InsuranceID REFERENCES InsucanceCompanies go CREATE TABLE EmployeeTypes. (EmployeeTypeID integer identity, EmployeeType varchar(25), CONSTRAINT PK Employee Types. PRIMARY KEY (EmployeeTypeID)) go CREATE TABLE EmployeeTitles (EmployeeTitleID integer, EmployeeTitle varchar(30), CONSTRAINT PK EmployeeTitles PRIMARY KEY (EmployeelitleID)) go CREATE TABLE EmployeeSkilllevels (SkilllevelID integer, Skilllevel varchar(15), CONSTRAINT PK Employeeskilllevels PRIMARY KEY (SkilllevelID)) go CREATE TABLE BillingRates. (Employee TypeID integer, SkilllevelID integer, BillingRate float, CONSTRAINT PK PrimaryKey PRIMARY KEY (EmployeeTypeID, Skilllevel ID, CONSTRAINT EK BillingRates Employee Tyres FOREIGN KEY (EmployeeTypeID) REFERENCES Employee Types, CONSTRAINT EK BillingRates Employeeskilllevels FOREIGN KEY (SkilllevelID) REFERENCES Employeeskilllevels) go CREATE TABLE EmployeeRanks. (RankID integer, EmployeeTypeID integer Title ID integer, SkilllevelID integer, HourlyRets float, Salary float, CONSTRAINT PK EmployeeRanks PRIMARY KEY (RankID) CONSTRAINT EK EmployeeRanks Employee Types FOREIGN KEY (EmployeeTypeID REFERENCES EmployeeTypes. CONSTRAINT FK EmployeeRanks. EmployeeTitles FOREIGN KEY (TitleID REFERENCES EmployeeTitles, CONSTRAINT EK EmployeeRanks Employeeskilllevels FOREIGN KEY (SkilllevelID REFERENCES Employeeskill levels go CREATE TABLE Employees (EmployeeID integer, FirstName varchar (30), MiddleInitial varchar(1), LastName varchar(50), Address Line1 varchar(50), Address Line2 varchar(50), ZipCode varchar(10), Phone varchar(14), Cell Phone varchar (14), Email varchar(50), RankID integer HourlyWage float, Salary float CONSTRAINT RK Employees PRIMARY KEY (Employee ID CONSTRAINT EK Employees EmployeeRanks. FOREIGN KEY RankID REFERENCES EmployeeRanks, CONSTRAINT EK Employee ZipCodes. FOREIGN KEY (ZipCode) REFERENCES ZipCodes.) CREATE TABLE Shifts (Shift ID integer, ShiftName varchar(20), StartTime time, EndTime, time, CONSTRAINT PK Shifts. PRIMARY KEY (ShiftID)) CREATE TABLE DaysOfWeek (DayofWeekID integer, DayQfWeeks varchar(15), CONSTRAINT PK DaysOfWeek PRIMARY KEY (DayOfWeekID)) go CREATE TABLE Availability Employee ID integer, Week of smalldatetime. DayOfWeekID integers ShiftID integer, CONSTRAINT PK Availability PRIMARY KEY Employee Weekof DayOfWeekID. ShiftID). CONSTRAINT FK Availability Employees FOREIGN KEY EmployeeID REFERENCES Employees CONSTRAINT FK Availability DaysOfWeek FOREIGN KEY DayOfWeekID REFERENCES RaysofWeek CONSTRAINT EK Availability Shifts. FOREIGN KEY ShiftID REFERENCES Shifts go CREATE TABLE Medicalsuppliers. (Supplier ID integer, SupplierName varchar(50), Address Linel varchar(50), Address Line2 varchar(50), ZipCode varchar(10), Phone varchar(14), Fax varchar(14), Email varchar(50), CONSTRAINT PK MedicalSuppliers. PRIMARY KEY (SupplierID), CONSTRAINT EK Medicalsuppliers zipcodes FOREIGN KEY (Zipcode) REFERENCES ZipCodes) CREATE TABLE Supplies (SupplyID integer, SupplyDescription varchar(40) Charge Rent float CONSTRAINT PK Supplies PRIMARY KEY SupplyID) BO CREATE TABLE SupplyInventory (SupplyID integer, Supplier ID integer, DateReceived smalldatetime, UnitCost float, Quantity float, CONSTRAINT PK Supply Inventory PRIMARY KEY (SupplyID, Supplier ID DateReceived), CONSTRAINT EK SupplyInventory Supplies FOREIGN KEY (SupplyID REFERENCES Supplies, CONSTRAINT EK SupplyInventory Suppliers FOREIGN KEY (SupplierID REFERENCES MedicalSuppliers go CREATE TABLE Visits (Visit ID integer, DateRendered smalldatetime, StartTime time EndTime time, Employee ID integer, Patient ID integer, CONSTRAINT PK Visits PRIMARY KEY (VisitID), CONSTRAINT EK Visits Employees. FOREIGN KEY (EmployeeID) REFERENCES Employees, CONSTRAINT EK Visits Patients. FOREIGN KEY (Patient ID) REFERENCES Patients) go CREATE TABLE VisitDetails (VisitID integer, VisitDetailID integer, SupplyID integer, SupplyQuantity integer ServiceID integer, Charge float CONSTRAINT PK VisitDetails PRIMARY KEY Visitio VisitDetail ID CONSTRAINT EK VisitDetaiils. Supplies FOREIGN KEY SupplyID) REFERENCES Supplies, CONSTRAINT EK VisitDetails Services FOREIGN KEY ServiceID) REFERENCES Services) go Total number of patients (single value) 33. List the number of patients who received insulin injections during 2014 (Note this is the number of unique patients who ever received insulin injections -not the number of visits in which insulin injections were provided). 34. List the total number of 4" self-adhesive bandages that were used in 2014 Total number of 4" self-adhesive bandages (single value) Employee Last Name, Employee First Name, Employee Type, Employee Title Sort order: Employee Type - ascending Employee Title--ascending Employee Last Name - ascending Employee First Name - ascending Total catheters (single value) 26. Display a list of Employees who were available to work during morning shifts during the week of 11/2/2014 and had a skill level of level 3. 27. Display the total quantity of catheters added to inventory during 2013 28. Display the total cost of "sterile gloves - small provided by Poole's Medical supplies during 2013. 29. Display the average cost of supplies for each supply item broken out by supplier. Total cost (single value) Supply, Supplier, Average cost per supply item Sort order: Supply - ascending Supplier - ascending 30. Display the total cost of all items purchased from suppliers broken out by supplier. Supplier, Total cost of all items provided by supplier Sort order: Supplier - ascending 30. Display the total cost of all items purchased from suppliers broken out by supplier. Supplier, Total cost of all items provided by supplier Sort order: Supplier - ascending Total number of patients (single value) 33. List the number of patients who received insulin injections during 2014 (Note this is the number of unique patients who ever received insulin injections - not the number of visits in which insulin injections were provided) 34. List the total number of 4" self-adhesive bandages that were used in 2014 Total number of 4" self-adhesive bandages (single value) CREATE TABLE Visits (Visito integer, DateRendered smalldatetime. Start Time time, EndTime tine, Employee ID integer, Patient In integer, CONSTRAINT PK Visits. PRIMARY KEY (VisitD), CONSTRAINT EK Visits Employees. FOREIGN KEY (Employee ID) REFERENCES Employees, CONSTRAINT EK Visits Patients. FOREIGN KEY (Patient ID) REFERENCES Patients) go CREATE TABLE VisitRetails (Visito integer, VisitDetailin integer. Sun VIR integer SupplyQuantity. Integer Services integer Charge float CONSTRAINT PK VisitDetails. PRIMARY KEY (VisitID. VisitRetailin) CONSTRAINT EK VisitDetalls Supplies. FOREIGN KEY (SupplyID REFERENCES Supplies CONSTRAINT EIVisitDetails Services. FOREIGN KEY (ServiceID REFERENCES Services) go D. CREATE TABLE Medical Suppliers. (Supplier IR Integer Suppliechane varchar(5e), Address Linel varchar(50), Address Line2 varchar(50), Zipcode varchar(10), Phone varchar(14), Fax varchar(14), Email varchar(50), CONSTRAINT PKI MedicalSuppliers. PRIMARY KEY (SuppliCIR), CONSTRAINT EK. MedicalSuppliers.Zipcodes. FOREIGN KEY (ZipCode) REFERENCES Zincades go CREATE TABLE Supplies (Supply integer SuprixDesscirtien varchar(40), Cherce Penit float, CONSTRAINT PK Supplies PRIMARY KEY (SURRIYIR)) go CREATE TABLE Supply.Inventory SupplyID integer. Supplier in integer DateReceived smalldatetime, WhatCost float, Quantity float CONSTRAINT PKSupplxInventory. PRIMARY KEY SURROIO, SuppliecIR. DateReceived CONSTRAINT EKUISURRixinventory Supplies FOREIGN KEY SARIYID REFERENCES Supplies CONSTRAINT EKUSRRIX.Inventory Suppliers. FOREIGN KEY SuppliecIR REFERENCES Medical Suppliers go CREATE TABLE Shifts (Shift integer ShiftMas, varchar(20), StartTime time, Eodtime time, CONSTRAINT EK Shifts PRIMARY KEY (ShiftID)) go CREATE TABLE DaysOfWeek. (RayofWeekin integer, Da varchar(15), CONSTRAINT PK Daysofbesk PRIMARY KEY (RayofWeekID)) go CREATE TABLE Availability Employee in integer Weekof smalldatei RayofweckID Integer Shifto Integer CONSTRAINT PKLAxellability PRIMARY KEY EmployeeIR Weekof DayQfweckID. Sbiti CONSTRAINT EKLAvailability Employees. FOREIGN KEY (Employes IRS REFERENCES Employees CONSTRAINT EK Axe ability of Wesk FOREIGN KEY (DayalseIR REFERENCES Dawsofwesk, CONSTRAINT EKLAA lot Shifts. FOREIGN KEY ShitID REFERENCES Shifts 20 CREATE TABLE FroloveeRanks. (Bank in integer Employee LYRIR integer, Titlsin, integer, Skillsxelin integer, Hulvate float, Salary float) CONSTRAINT PK. EmplexceRanks. PRIMARY KEY (Rankin), CONSTRAINT EK. EmplexceRaoks. Elexeeyes. FOREIGN KEY (Explores typeIN REFERENCES Englovce RSS. CONSTRAINT EK Couplexecranks. Ebelove titles. FOREIGN KEY (IitleIR) REFERENCES Earloxes Titles CONSTRAINT EK EmplexceRanks. Forloverskillevels FOREIGN KEY (Skill.exelIR) REFERENCES Forlovseskillevels) go CREATE TABLE Employees (Employee in integer, FirstName varchar(30), MiddleInitibl varchar(1), Last Name varchar(50) Address Linel varchar(5e), Address Line2 varchar(50) ZipCode varchar(10) Phone varchar(14) Cell Phone varchar(14) Email varchar(5e) BankID integer HoudlyWage float, Salary float CONSTRAINT PK_Emplexees. PRIMARY KEY (EmployeSIR CONSTRAINT EK Employees EmployeeBanks. FOREIGN KEY (RankIR) REFERENCES EmplexesBanka. CONSTRAINT EKLEmployes RipCodes. FOREIGN KEYK ZipCode. REFERENCES ZiRedes) go CREATE TABLE Employee types. (Employee TuneIn integer identity, Employee lyne varchar(25) CONSTRAINT PK.EnplexeeTypeS, PRIMARY KEY (EmployseTypeIR)) go CREATE TABLE EmployeeTitles. (Euplay.celiter integer Employeetitie varchar(30), CONSTRAINT EK..Eanlexeetitles PRIMARY KEY (Employee Title) 80 CREATE TABLE Employeeskilllexela (Skilleve.IR integer, Skilllevel warchar(15) CONSTRAINT PELLE LexeeskilllexSha PRIMARY KEY (Skillevel) EO CREATE TABLE BitingRates Employee Tanteger skillevel integer Bling Bate float CONSTRAINT PK Primarxkex PRIMARY KEY (Employee Rein skillevel CONSTRAINT EK.BilingRates Employce Types FOREIGN KEY Employes.TyRID REFERENCES Employee Tyres CONSTRAINT EK BlineBates Employeeskilllevels. FOREIGN KEY Skill.exelID REFERENCES Employeeskillevels 30 CREATE TABLE Eaxaentxes KPaynentIYIR integer Paxcal. Tyre varchar(25), CONSTRAINT EK Paxbeat Types PRIMARY KEY (CaxnentTypeID)) go CREATE TABLE LOS CHOC.Canies. (Insucancer integer, Los canc.Cooox varchar(50), Address Linel varchar(5e), Address Line2 varchar(50), Zipcode varchar(10), Phone varchar(15), Fax varchar(15), Email varchar(50), CONSTRAINT PK Insurance Companies PRIMARY KEY (InsuranceIR. CONSTRAINT EK Unsurance companies. ZinCodes FOREIGN KEYiRfede) REFERENCES ZARedes) BO CREATE TABLE Contracts (Santcast integer BALTA Inteen StartDate aidatetime , EndDate small PaymentTypeID integer Ina cand integer Negotiatedate float CONSTRAINT Pcontrasts PRIMARY KEY ContCASTIR CONSTRAINT Pcontcacts Referrals FOREIGN KEY BLIR REFERENCES Referrals, CONSTRAINT Econtracts Payment types. FOREIGN KEY Payment TesID REFERENCES PaymentTyres, CONSTRAINT Eetcactuinsurancecompanies FOREIGN KEYucanceID REFERENCES Insurance Companies 90 CREATE TABLE Services (Service ID integer, ServiceName varchar(50), CONSTRAINT PK Service ID PRIMARY KEY (ServiceID)) go CREATE TABLE Frequencies (Frequency ID integer, Frequency varchar(30), CONSTRAINT PK Frequencies. PRIMARY KEY (FrequencyID)) CREATE TABLE Referral Services (ReferralID Integer ServiceID integer Frequency ID integer CONSTRAINT PK ReferralServices PRIMARY KEY ReferralID. Service ID CONSTRAINT FK ReferralServices Referrals FOREIGN KEY (ReferralID REFERENCES Referrals, CONSTRAINT FK ReferralServices Services FOREIGN KEY (ServiceID REFERENCES Services CONSTRAINT EK ReferralServices Frequencies FOREIGN KEY (FrequencyID REFERENCES Frequencies) go CREATE TABLE Patients (Patient ID integer, First Name varchar(50), MiddleInitial varchar(1), LastName varchar(58), Address Linel varchar(50), Address Line2 varchar(50), ZipCode varchar(10), Phone Home varchar(14), Phone Alternate varchar(14), Email varchar(50), CONSTRAINT PK Patients PRIMARY KEY (Patient ID)) 89 CREATE TABLE Referrals (ReferralID integer, StartDate smalldatetime, EndDate smalldatetime Patient ID integer Physician ID integer CONSTRAINT PK Referrals PRIMARY KEY (ReferralID CONSTRAINT EK Referrals Patients FOREIGN KEY Patient ID REFERENCES Patients, CONSTRAINT FK Referrals Physicians FOREIGN KEY (PhysicianID REFERENCES Physicians) 80 CREATE TABLE Physician Practices (PracticeIn integer, PracticeName varchar(50), Address_Line1 varchar(50), Address Line2 varchar(50), ZipCode varchar(10), Phone varchar(14), Fax varchar(14), WebsiteURL varchar(50), CONSTRAINT PK PhysicianPractices PRIMARY KEY (PracticeID) CONSTRAINT EK PhysicianPractices. ZipCodes. FOREIGN KEY (Zipcode) REFERENCES Zipcodes.) go CREATE TABLE Physicians (Physician ID integer, First Name varchar(40), LastName varchar(50) Practice ID integer, Specialty ID integer, Email varchar(50) CONSTRAINT PK Physicians PRIMARY KEY PhysicianID CONSTRAINT EK Physicians Practices FOREIGN KEY PracticeID REFERENCES. PhysicianPractices CONSTRAINT EK. Physicians. PhysicianSpecialities FOREIGN KEY SpecialtyID REFERENCES PhysicianSpecialties.) go CREATE TABLE PhysicianSpecialties (Specialty ID integer, SpecialtyName varchar(50), CONSTRAINT PK PhysicianSpecialties PRIMARY KEY (SpecialtyID)) go CREATE TABLE ZipCodes (ZipCode varchar(10), City varchar(50), State varchar(2), CONSTRAINT PK ZipCodes PRIMARY KEY (ZipCode) go Eselect * from medicalsuppliers 121% Results Messages Supplier Supplier Name Virginia Medical Supplies 2 Lynchburg Medical Supplies 3 Pooled Medical Supplies Address_Une 1 2198 Old Jetty 999 Dusty Promenade 5884 Heather Run Addreos One2 NULL NULL NULL Zip Code Phone 24502 NULL 24503 NULL 24701 NULL Fax NULL NULL Email NULL NULL NULL NULL Eselect * from Availibility 121 % DayofWeekID ShiftID 2 2 4 1 5 N N N 2 3 Results Messages EmplD Week Of 11/2/2014 2 1 11/2/2014 1 11/2/2014 11/2/2014 2 11/2/2014 16 2 11/2/2014 2 11/2/2014 8 11/2/2014 9 11/2/2014 10 11/2 2012 3 4 5 5 6 1 2 3 3 3 6 1 3 11 EPOTA Eselect * from shifts 121 % Results Messages Shift ID Shift Name 1 1 Moming 2 Aftemoon 3 3 Evening Start Time End Time 08:00:00.0000000 12:00:00.0000000 12:00:00.0000000 16:00:00.0000000 16:00:00.0000000 20:00:00.0000000 3 select * from EmployeeSkilllevels 121 % 1 Results Messages Skill LevellD Skill Level 1 Level 1 2 Level 2 3 Level 3 2 3 select * from EmployeeTitles 121 % 2 Results Messages Employee TitleID Employee Title 1 LPN-1 2 3 LPN-3 3 4 LPN-4 4 5 LPN-5 5 6 RN-1 6 7 RN-2 8 RN-3 8 9 RN-4 9 10 RN-5 10 11 RN-6 11 12 RN-7 6 ES es Eselect * from EmployeeTypes 121 % Results Messages Employee TypeID Employee Type 1 Nurse 2 Ade 3 Owner Manager Administration 4 8 8 select from Esployes els nies 121% Emplo Firme La 2 Jy Sharon 4 Shan 5 NULL Madero Laine K Adana 1 Ander F Men T Bay NULL 3 E G U Chen F Cak Address Address 2 2630 Burg Lookout NULL 1264 Old Banco NULL 541 Maty Wynd A4 4462 Pleasant Ek Crew 5136 Golden Fox Mount Al 77 5788 Velvet NULL 3545 Green Towine NULL 2 road How MULL 5050 Harvest Port NULL 356 NULL 5073 Silver Maze NULL ZeCode Hoseltone Capo Rar Hout War Say 2502 14421244714 Usa Adormec 13 05 NULE 2060 44344122643 (12055 Arnhem 5 27 NULL 7 4X152462 Sercom 21 NULL 20000 78223 69413715121 1263 Sharco 25 NULL 19000 24503 EN9054647 B.com 16 11 24551 413423432 434 135 LeBron 70 35.5 NULL 24502 1434) 228-8856 1434 Acom 1 2 24561 5401 Dhe 22 NULL 12 24560 540427,1157 (5400 125,2555 Crambene 11 19 NOLE 24551 45272025 Wa Docco 26 NULL 25000 24562 1434 433 434 505 7735 Red.com 10 NILLO NULL Rank le eComps Annie Chert DISO Venia Ruby 10 select * from SupplyInventory I 121 % - T Results SupplyID 4 Messages SupplerID 2 2 UntCost 2 5 9 Quantty 8 15 14 4 2 7 4 2 10 13 Date Received 10/4/2013 10/22/2013 10/30/2013 11/17/2013 11/23/2013 12/7/2013 12/15/2013 12/22/2013 1/7/2014 1/22/2014 2/1/2014 1 1 3 1 4 9 5 9 16 9 10 PA 16 LAPTOP-AOGKOQFH SQLEXPRE select * from Supplies = nks illLevels Eles pes ompanies ppliers pes ractices -pecialties 121 % rvices N N 1 Results Messages SupplyID Supply Description ChargePerUnit 1 1 10mm syringes 1 2" Gauze 1 3 3 2" self-adhesive bandages 2 4 4" Gauze 4 5 5 4" self-adhesive bandages 5 6 6 adhesive tape - 1 1/2 in. 0.5 7 7 adhesive tape - 2 in. 0.75 8 catheters 5 9 9 paper adhesive tape 0.75 10 10 sterle gloves - large 1.5 11 11 sterle gloves - medium ventory Jibility grates Eracts loyee sloyeeRanks Sloyees ployeeTypes aranceCompa ients 6 8 1.5 select * from Services