In the earlier forum post, the lecturer replied that you should follw the ERD https secure.csse.uwa.edu.au run help1402?p np opt U505

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

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.

Hi, I actually found some discrepacies and missing information I would like to discuss, I hope this will reach the teaching team to help me and other students to do their projects. Below I have grouped the questions according to the entity for ease of...

Actually the reason this query can run SELECT job id, po date FROM pos WHERE po date '1990-01-03' GROUP BY job id; is Because sqlite have "bare columns" implementation in aggregation query https www.sqlite.org draft lang select.html bare columns in ...

WHERE is used to filter data before aggregation HAVING is used to filter data after aggregation (after GROUP BY clause) As far as I remembered, you can actually use both WHERE and HAVING at the same time. Just note that WHERE will filter the data befor...

Hi everyone, I just wanted to put up some discussion to see your view regarding this point in the project. So we do have this point here in the scenario. For each make of car, the daily rental tariff ( 3) is recorded for each of the tariff types ...

Seems like you have to ignore the "(or equal to)" part so it can use 300 25.25

Yeah even with the provided data, the assertion somehow seems impossible. Or maybe others who got it done can elaborate. item id descr on hand price P9 9KG PAPER 300 25.25 P12 12KG PAPER 700 49.99 P18 18KG PAPER 100 100 IRN INK-RESIN 3 500 IWS INK-WRSOL 5 ...