9607
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]
Attachments:
CSE2DCX-2019-….pdf
Assignment-3…..docx
