Please consider offering answers and suggestions to help other students!
And if you fix a problem by following a suggestion here,
it would be great if other interested students could see a short
"Great, fixed it!" followup message.
After everything, somehow I agree with you.
I am actually one of the student who complained earlier. However, after reading the justification of not providing schema and data is to prevent student finishing using AI to finish everything it make sense,...
I just used my first attempt to do selection for data I wanted to grab, this is the data I found so far that will be commonly used by the questions, if you wanted to use it.
VehicleType
VehicleTypeID make model doors body tri...
Adding another entry here for question 7
Assertion always expect VehicleID but no matter what I did (even already using as "VehicleID" ) my result still have the output in Vehicleid (Which in incorrect).
Expected Got
VehicleID Vehicleid
.....
Might check this out
https secure.csse.uwa.edu.au run help1402?p np opt U519
But there is also a problem about the answer assertion, it expected VehicleID but no matter what did you do (even already using as "VehicleID" ) you will still have the o...
For those that didn't notice yet, Question 3 have been changed and you have been given another change to retry the test.
For question 7, Hybrid is Fuel and Luxury is the trim
So please kindly use that
I am still figuring out how to do question 8...
Question 8
Create a view ('ActiveHiresWithInsurance') to show active hires with insurance details (show HireID, Date, PolicyType, and Cost), between the dates 5th of Jan 2024 and 25th May 2024, and for all insurance entries with a cost of more then ...
Suggestion for SQL Quiz for Take Home Test
Dear Teaching Team and Everyone,
I have a suggestion and at the same time will help everyone with this
Question 3
Question Find the client details for clients whose hired vehicle has travelled between 5,000 an...
Same here I also wanted to know this. Because I faced something like "In the case study, what attribute would be primary key of..." and "In the case study, ... is always unique"
While the ER specifies the specified field to be Primary Key, in the para...
Hi, I think you can easily infer the direction of the arrow based on the text.
For Invoice it is Invoice --- generated for --- HiredVehicle
It is mentioned in this narration "Only after the vehicle is returned an invoice is generated for the vehicle h...
