Hi, How strictly will the syntax of the SQL be marked? As this is closed book, there is no guarantee we will remember all the SQL syntax perfectly so it would be great to know what the leeway for that is. Thank you,

Legend, absolute lifesaver

Hi, How do we create error codes in SQL? Thanks,

Hi there, 1. I have managed to solve the question already however I did not see anywhere in the lectures or lecture recordings that described anything near what is the solution to question 2. 2. I solved it twice once with the intended solution and on...

Thanks, I understand you're explanation and while I agree with the way you have explained it I still find it odd that the depotid is done the way it's done. Because there was no assumption made that the vehicles might be picked up and dropped off to ...

Hi Team, I have already completed most of the 2nd part of the project, however I have a major issue with it. 1. Since we are basing our SQL on the ERD, would it not work since the model we have been given is not in 3rd Normal Form which creates lots o...

Hi all, I am a bit confused as to how we resolve our many to many relationships. From what I can see we place a new Entity in between the two Entities in order to resolve it. In regards to the project does this mean we need new relationships between th...

Hi there, Is is alright if I colour the Attributes Dictionary to make it more clear which attributes belong to which Entity. Thank you,

No, the depot itself is the loaction. What it means is location address is written per depot.