Please follow the ERD model that was provided. In case there are PKs that are not specified, we have mentioned them under various questions.

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...

I think we needed to create our own data to populate the databases

hi, these are the schemas we need to follow?

HI I am unsure where to find the data to populate our sql database to do the take home sql quiz. please advise.

Yeah, question 21

I think that this question has a typo.

I think there is a MCQ that do not have a correct answer according to the ER diagram we are given. What is the correct cardinality between HiredVehicle and Vehicle in the case study?

You are a life saver thank you

You are an absolute legend I hope you have an amazing year

Thank you, this definitely should have been provided by the UC prior to the test opening.

And the most ironic thing is you guys say You should know the schema before doing sql questions and you guys didn t even post it for us? Shame on you teaching team remember that we are paying thousands of dollars for this unit don t forget ...

Bro you re a legend for posting the schema thank you so much for this Teaching team why didn t you guys post the schema? It clearly shows that you guys aren t doing a good job on creating the assessments for this unit?

Hi guys, I have used select statements to extract the attributes of all the attributes for entities I could think of. If you guys need attributes for anything else let me know and I'll try find them too. HiredVehicle HireID, Date, CardType, CardNo, O...

With Q8, both insurance and HiredVehicle table have HireID in common, so consider joining with that in mind. At this point, we have to waste points to look at the schema.

I am getting this error too.. I am unsure why

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...

Yeah the teaching team is always creating vague and confusing questions in the test and labs and they always have typos in the labs as well if you guys are reading this you should do better and write the questions more clearly? Look I am understand t...

Quick heads up, doing SELECT FROM insurance; Results in this entries InsuranceID PolicyType Cost HireID ... 1 Comprehensive 50 1 2 Third-Party 30 2 3 Comprehensive 40 3...