I tried the first SQL Quiz question. It's supposed to be an easy one and I wrote the query based on my submitted SQL files. However, when I clicked check button, it told me my answer was wrong and corresponding error message was "no such column: StartDate". However, I did use StartDate as an attribute in my schema. So right now I'm confused whether we should use our own work or some provied schema. And where can I find the provided schema? Thank you.

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." [help1402]⬈

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.

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 I’m overlooking anything, feel free to point it out. Thanks!

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

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!

If you remember in the class we had discussions on whether you can create unique PKs or not. A number of students did that and some did not. Hence, where we felt necessary, we have provided some key attributes and PKs.

Would it not have been completely valid to make the regNum the PK of Vehicle though? In fact, the provided ERD specifically says that regNum should be the PK. So now that I've made my own schema with that assumption I lost marks for following the ERD because I didn't know about vehicleID...