It's UWAweek 47

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

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.

How do I ask a good question?
Displaying selected article
Showing 1 of 684 articles.
Currently 90 other people reading this forum.


 UWA week 41 (2nd semester, week 11) ↓
SVG not supported

Login to reply

👍?
helpful
11:12am Thu 10th Oct, ANONYMOUS

Hi, In question 3 of lab 5, I have managed to write a code which has correct expected results for 3/4 tests. However, one of the test is: DELETE FROM po_items WHERE job_id = '002' AND po_id = 'HHH'; DELETE FROM pos WHERE job_id = '002' AND po_id = 'HHH'; SELECT * FROM pos WHERE job_id = '002' AND po_id = 'HHH'; Is the first line of code an error, where it is meant to be pos instead of pos_item? The expected result is that no trigger should be evoked however my trigger is evoked for this test. If someone could clarify this it would be great. Thank you.

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy