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 91 other people reading this forum.


 UWA week 34 (2nd semester, week 5) ↓
SVG not supported

Login to reply

👍?
helpful
8:43pm Sun 25th Aug, Sandy BG.

Here's the question; Perform an UPDATE on the pos table, Updating the following row to have the following values: job_id 002 po_id AAA po_date 1990-05-20 -> 1990-04-18 vendor_id ABC Here's the answer I got; UPDATE pos SET po_date = '1990-04-18', vendor_id = 'ABC' WHERE job_id = '002' AND po_id = 'AAA'; The answer was correct and passed all the checks on Moodle, but what I'm wondering is; is the "vendor_id = 'ABC'" line really necessary? Or rather, would this answer still have been correct without that line? The question appears to read as if we are being instructed to just change one piece of data, the po_date. If this is the case, why are we also changing the vendor_id? Could I have just left that part of the solution out, and perhaps it was just marked correct as changing something that is to correct, to the same thing (which is correct) is technically correct (but bad practise). 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