Review the following tutorials: Tutorial: Connect to and query a SQL Server instance by using SQL Server Management Studio SQL Tutorial use links on left of the screen to navigate the SQL topics You will now create a database for the following seven tables. You will build upon this database in the upcoming units of the course. Create a database containing the following tables: Table:DepartmentDatatype (Length)PKDepartmentIDINTNameVARCHAR (50)LocationVARCHAR (50) TableEmployeeDatatype (Length)PKEmployeeIDINTNationalIDINTFK2ContactIDINTLoginIDINTFK1ManagerIDINTShiftIDINTTitleVARCHAR (3)BirthDateDATEMaritalStatusVARCHAR (20)GenderVARCHAR (1)reDateDATESalariedDECIMALVacationHoursDECIMALSickLeaveHoursDECIMALCurrentVARCHAR (1) * NOTES: Salaried and Current columns will hold Y/N data to indicate whether an employee is or is not salaried and is or is not a current employee respectively. Table:EmployeeAddressDatatype (Length)FK1EmployeeIDINTPKAddressIDINTStreetVARCHAR (150)CityVARCHAR (50)StateVARCHAR (2)ZIPVARCHAR (5) Table:PaystoryDatatype (Length)PK, FK1EmployeeIDINTPKRateChangeDateDateRateDECIMALPayFrequencyDECIMAL Table:EmpDeptstoryDatatype (Length)PK, FK2EmployeeIDINTPK, FK1DepartmentIDINTPKStartDateDATEPK, FK3ShiftIDINTEndDateDATE Table:ShiftDatatype (Length)PKShiftIDINTNameVARCHAR (30)StartTimeDATEEndTimeDATE Table:JobCandidateDatatype (Length)PKJobCandidateIDINTFKEmployeeIDINTResumeVARCHAR (500)
