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

Hi, can someone please help me with the 7th question where we are supposed to use a SET operation? The column names are very confusing and I keep getting a different output. Thanks

Hi, How are we supposed to know what the column names are? VehicleID and VehicleIDType were never seen in the ER diagram. Moreover, the column name, regNum (typed in this specific casing in the ER diagram), is RegNum in the output. How are we suppose...

Nevermind, was able to get the question. Forgot to mention that the primary key was changed before the question so maybe add it in the question so other students don't make the same mistake as me.

I'm pretty sure that the question still isn't working. Correct me if I am wrong but I believe that some key from Vehicle (Unsure if it is regNum or something else because the key changes mid-test) is meant to be in HiredVehicle but it is saying that t...

I am unable to answer questions as the tables I made in my SQL from part 2 cannot be found. Is there reference SQL tables somewhere I am not seeing? How can I answer questions using my SQL tables if they do not match what is expected by the Moodle cr...

But how do you even do question 8 without joining HiredVehicle and Insurance? Shouldn't the insuranceID be placed as FK in HiredVehicle allowing us to perform a join?

Hi When the test refers to the 'case study', does this mean only the written description of the specifications and NOT the ERD? I ask because sometimes they are contradictory. Thanks

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

Hello I am trying to attempt the test but it is incredibly ambiguous as we are not provided with the schema of the tables, as such I can't find out what fields certain tables have. For example on question 3 I have to innerjoin on clientID but clientI...

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

If a schema is provided, can the grades of the students who already submitted please be reset? Due to the confusion and lack of information I feel it is unfair for those who attempted the test to get penalties on their grades. Thank you

Hello, I am also finding a lot of confusion with the schema's for each table. For some questions some fields seem to not exist from what I had in my solution (Which I followed the solution ERD given to us) along with some changes to the schema's menti...

Yeah I noticed one question seems to reference attributes like "HireID" and "VehicleID" but those weren't present at all in the case study nor in the ER diagram

I attempted the SQL part of the take home test, and like many others have mentioned, although the tests pass on my databases, once I run it on moodle it fails because some entity and attribute names are different. Would we be getting a schema? I find...

Hi everyone, I m a bit confused because the attributes in the ERD model seem different from those used in the SQL test, specifically in question 3. Could we please get some clearer guidance on this to ensure we re on the right track for the test? If...

So far, I've found that the attribute names etc of the schema in the SQL questions match those of ERD given for us to use for Part 2, which can be found on LMS in the information for Part 2 of the project, called Reference-ERD.pdf.

So far, I've found that the attribute names etc of the schema in the SQL questions match those of ERD given for us to use for Part 2, which can be found on LMS in the information for Part 2 of the project, called Reference-ERD.pdf.

It is mentioned here by the lecturer that you should use the same attributes as provided with the ER of project 2. "In the SQL part of the quiz, you may need to use the same attributes as I will share with you the minimal schema." https secure.csse.u...

Yeah I'm confused too, the case study and ER diagram have some parts where they contradict each other even though the ER diagram is made from the case study.