ITEC 3500, Extra credit 5% of the total grade, Due: April 30th before class.
Show the SQL commands used to achieve the following tasks. Use SQL Server as your test DBMS.
1. Create a database called ExtraCredit and a table called Employees using the following info: (15 pts)
Table Columns
Data
Type
Length
of Data Allow Null?
Employees EmployeeID int No
Employees LastName nvarchar 20 No
Employees FirstName nvarchar 10 No
Employees Title nvarchar 30 YES
Employees TitleOfCourtesy nvarchar 25 YES
Employees BirthDate datetime YES
Employees HireDate datetime YES
Employees Address nvarchar 60 YES
Employees City nvarchar 15 YES
Employees Region nvarchar 15 YES
Employees PostalCode nvarchar 10 YES
Employees Country nvarchar 15 YES
Employees HomePhone nvarchar 24 YES
Employees Extension nvarchar 4 YES
Employees ReportsTo int YES
Set the EmployeeID as the primary key.
2. Then use the following info to insert data into the table, set a constraint that the hire date must be later than the birth date. (15
points)
EmployeeID LastName FirstName Title
TitleOfCourte
sy
BirthDat
e HireDate Address City
Regi
on
Postal
Code
Countr
y
HomePh
one
Extensio
n
Reports
To
