CSE2DCX : Database Fundamentals on the Cloud - Computer Science Assignment Help

Assignment Task :

Background 

Over the past decade Carol’s confections have become one of the leading  confectionary vendors in Melbourne. The number of shops has increased from 1  in 2010 to 4 in 2019. The management has decided to automate its current manual  staff management process. Instead of using their current paper-based system they  wish to use a web-based staff management system. 

You are tasked to handle the initial work on the database systems - 

constructing tables, populating data and running SQL queries. 

They have decided the initial database will contain 3 tables. 

• Employee 

• Department 

• Grade 

The Employee table will store employee ID, employee name, manager, job, salary,  commission, hire date and department ID (Department where the employee works).  The Department table will store the Department ID, department name, address and  phone number. The Grade table will store the Grade ID, minimum salary, maximum  salary and annual leave. 

The manager column will be used to store the employee id of the manager, for  example Adam’s manager is Eve whose is also an employee and has employee id  1211. The manager column for Adam will have the value 1211. The commission  column represents the sales commission that some employees earn. The grade id  will be a character value for instance employees in grade B earn between 60000  (min salary) and 80000 (max salary). Each grade has an associated annual leave  loading. The other fields are self-explanatory. 

Login to the SQL Server database using the credentials (username and password)  that you have created earlier. If you are unable to log in due to any reason, please  do not proceed any further. Please contact the academic team.

Tasks 

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.  

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. 

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 

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.

This Computer Science Assignment has been solved by our Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.