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-….pdfAssignment-3…..docx

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now