CSIT115/CSIT815: Data Management and Security - IT Assignment Help

Assignment Task:

Task 1
Download a file solution1.sql and insert into the file the implementations of the following queries as SELECT statements of SQL.

(1) Find the first and last names of employees who live in NSW, Hurstville, Victoria St. or NSW, Pennant Hills.

(2) Find the registration numbers, capacities, and statuses of all truck whose capacity is in range between 2000 and 4000 both inclusive.

(3) Find the first and last names of employees who did not provide information about initials and who provided information about a date of birth.

(4) Find the first and last names of all employees born either in 1980, or 1992 or 1992 It is your task to find an appropriate standard function that can be used to extract a year from a date.

(5) Find the registration numbers of all trucks. The results should be displayed in the ascending order of the statuses and for all trucks that have the same status, the results should be displayed in the descending order of registration numbers.

(6) Find the total number of distinct names of cities being the departure locations for at least one trip. A city is a departure location when it is a departure location of the first leg of a trip.

(7) Find the total number of trips performed by each driver. List the driving licence numbers associated with the total number of trips. Ignore the drivers who performed no trips so far.

(8) Find the total number of times each truck has been used for the trips. List the truck registration numbers associated with the total number of trips. List only the trucks used more than 5 times.

(9) Find the trip numbers, driving licence numbers of the drivers who performed the trips and the registration numbers of the trucks used for the trips done in the first 30 days after 1 February 2016.

(10)Find the total number of trips that started or finished or passed through a city that has a letter y in its name. When ready process a script file solution1.sql with SELECT statements. To create a report from processing of SELECT statements open a Terminal window and start the command line interface MySQL in the following way:

This CSIT115: IT Assignment has been solved by our IT 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.