Task 1
Login to SQL Server and create the Employee table (see table 1) using SQL
statements. You will be assessed on the following,
Is the SQL syntax error free?
Has the primary key been implemented?
Have the proper data types been implemented?
Have you implemented appropriate constraints (e.g. null values, unique,
referential integrity) to help in improving the integrity of data?
Write the finalised SQL statements that you used to create the table. [2 marks]
Task 2
Login to SQL Server and create the Department table (see table 2) using SQL
statements. You will be assessed on the following,
Is the SQL syntax error free?
Has the primary key been implemented?
Have the proper data types been implemented?
Have you implemented appropriate constraints (e.g. null values, unique,
referential integrity) to help in improving the integrity of data?
Write the finalised SQL statements that you used to create the table. [2 marks]
Task 3
Login to SQL Server and create the Grade table (see table 3) using SQL
statements. You will be assessed on the following,
Is the SQL syntax error free?
Has the primary key been implemented?
Have the proper data types been implemented?
Have you implemented appropriate constraints (e.g. null values, unique,
referential integrity) to help in improving the integrity of data?
Write the finalised SQL statements that you used to create the table. [2 marks]
Task 4
Write a query to insert the following data to populate the Employee table. Make any
reasonable modifications so that the data matches your field names and data types
and conform with integrity constraints.

Place New Order
It's Free, Fast & Safe

"Looking for a Similar Assignment? Order now and Get a Discount!