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.
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.
This CSE2DCX – Computer Science Assignment has been solved by our Computer Science experts at Schooling Best. 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.
