Database Fundamentals on the Cloud - CSE2DCX - IT Assignment Help

Assignment Task

Background
The Antiquity Car Rentals company is stuck in the past. For years the organisation has depended on manual information recording procedures to store information about their customers, sales staff and cars. The rental car company maintains these different types of information in separate paperbased files.
As you can imagine, retrieving a required record from a massive file is both difficult and time consuming, as is extracting information for the development of reportsApart from these problems storing many paper-based files requires a significant amount of storage space.
To overcome these issues Antiquity Car Rentals has decided to finally take advantage of modern technology to create an application that will allow them to perform these functions in a far more efficient manner.
Your organisation has been hired by Antiquity to assist with the digitization of their records. You have been tasked to handle the initial work on the database systems, which will consist of constructing tables, populating data and running SQL queries. It has been decided that the initial database will contain 5 tables.

• CUSTOMER
• TRANSACTION
• CAR
• EMPLOYEE
• SHIFT

Tasks

Task 1
Login to the SQL Server and create the CUSTOMER table using SQL statements (refer Table 1 below). Write the finalised SQL statements that you used to create the table.

Task 2
Write the finalised SQL statements that you used to create the table. Provide a screenshot of the output.

Task 3
Write the finalised SQL statements that you used to create the table.

Task 4
Write the finalised SQL statements that you used to create the table.

Task 5
Write the finalised SQL statements that you used to create the table.

Task 6
Write a query to insert the following data to populate the CUSTOMER table. Make any reasonable modifications so that the data matches your field names and data types and conform with integrity constraints.

This CSE2DCX - IT Assignment has been solved by our IT experts at My Uni Papers. 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.