Download the attached Word Document Template named “Lastname – Lab 1.doc”. (change Lastname to your last name)
*** ATTENTION! ***
USE THE ATTACHED WORD DOCUMENT TEMPLATE WHEN YOU TURN IN YOUR ASSIGNMENT
Create a SQL Server Database.
Create the following two tables using the following fields:
(Note: Supply the SQL Server data types when creating the tables. Apply a primary key to each table.)
• Exempt (holds exempt status which is either 1 or 0)
Using the SQL INSERT statement:
o Enter ten records into the employee table.
o Enter five records into the job_title table.
Include all SQL statements (i.e create, insert, etc used to complete each task of your assignment. Do not include screenshots – rather copy/paste the SQL scripts in the Word document template attached.
Click the Assignment Files tab to submit your assignment.