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

Hi, When answering the SQL based questions for part 2 of the take home test, is there a specific relation schema we have to refer to? If so, where could we find that? Thanks

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

Thanks a lot I was having problems with the formatting too and this solution totally fixed it

Good morning, In the take home exam, some questions ask "in the case study" and others ask "in the case study's EER model", does this mean that for questions which ask "in the case study" we have to refer exclusively to the case study description? Or ...

Do we have to complete the take home test in one sitting or is there an option to access it again before the deadline?

Hi, No you do not need to use the average in Q7. Can you please post the actual question here, because i feel you may be referring to a different question.

Hi, No issues. I also mentioned in an announcement that it is expected that your understanding about the project would improve during the take home test, so please attempt the questions even if you did not implement certain tecnhiques in the project ...

Dear Dr. Nasim, I ve recently submitted Project 2, which I completed without using the TRIGGER and VIEW clauses. However, I noticed in one of the forum posts regarding the scope of the take-home test that you mentioned TRIGGER and VIEW are needed fo...

Hi For Lab-5 Q7, can you please clarify if we need to use A- Avg(price) from items table OR B- AVG ( item.price po items.quantity) i.e. AVG of total item cost A returns an avg value of 173.37 vs B returns a value of 2478.95 if I take first approach, I ...

Do we have to complete the take home test in one sitting or is there an option to access it again before the deadline?

Mam i got the same problem I submitted project before the deadline but got mail from the university that my project is not submitted kindly check once my student id is (24291609)

Hi, Multiple ways to address this. Either you put a null, or you populate it correctly with the return depot (that's what happens in real life , one chooses the return depot when they make the booking). Cheers

Hi, The examples that you have mentioned are going to work in sqlite (see the code below). However, this is not going to work with other dilects of SQL. You can use it in sqlite if you want to. In the exam, if you have written a query that either work...

Hi, Your submission is in the draft format. You did not submit it. You can submit it under late submissions links. There is no penalty. Cheers

That's okay as long as you know what's going on cheers

I think that perhaps you were just overthinking. I can't think of a single person in UWA CS that uses VSCode and doesn't use the autocomplete. On the other hand, using something like Github Copilot which is an AI assistant within VSCode is almost cer...

Actually this is a little bit silly but you have to put period (.) on the message 'Cannot delete pos record with associated po items.' It should be something like this. Found it after meddling around.

While writing my tables, queries, I was using VSCode and it had auto code completion enabled which was suggesting code. I had to turn it OFF considering it may trigger academic integrity issues. However just wondering, was I overthinking? will auto co...

Hi, I received an email that said that my submission for part 2 of the project was not received. But I had uploaded and submitted the files well before the deadline, but I can't see it on the forum right now. Do I submit the files again?