Please consider offering answers and suggestions to help other students!
And if you fix a problem by following a suggestion here,
it would be great if other interested students could see a short
"Great, fixed it!" followup message.
Hi,
Forget what the class mates are saying, look at the unit outline (what does it say?) "submitted via Moodle-Assessed via a take home test"
Also look at the project question sheet (what does that say?).
" Following the submission of both parts ...
The reason you're not getting the correct answer is due to your format, not your SQL grammar. You need to ensure the error is in Line 12; otherwise, you won't get the expected result. A simple way to address this is by ensuring there are no blank lin...
I also got the 'Unexpected sqlite3 error Error near line 13 Cannot delete pos record with associated po items' error
I used both abort fail but the results remained the same (also as the hint provided by the question we're supposed to use abort t...
Hi,
On the Lecture wk 10, Slide 28-29 mentions the following
(a) If column in view is based on an aggregate function
Column may appear only in SELECT and ORDER BY
clauses of queries that access view.
Column may not be used in WHERE nor be an ar...
I have the same question
After looking up online, it should be something like
CREATE TRIGGER abort delete from my tbl
BEFORE DELETE ON my tbl
BEGIN
SELECT RAISE(ABORT, 'You can''t delete records from my tbl');
END;
However, my output runs perfectly, b...
the portal has late submission tab available.
if we have already submitted our work but later realised that we can improve the model;
can we also submit under late submission? will the original submission be discarded and new one will be considered? o...
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...
