help1402

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 the 3 articles in this topic

Showing 3 of 684 articles.
Currently 98 other people reading this forum.

UWA week 33 (2nd semester, week 4) ↓

Lab 2, Question 6 (all 3)

4:57pm Fri 16th Aug, ANONYMOUS

Is anyone having trouble with the update statement? When I execute my code for question 6 in lab 2, it removes the date entirely for the tuple of interest rather than replacing it with the new date.

UWA week 34 (2nd semester, week 5) ↓

Lab 2, Question 6 (all 3)

9:28am Mon 19th Aug, Jichunyang L.

Could you check your SQLite query? The format for an update statement should be

UPDATE table_name
SET date_column = 'new_date'
WHERE condition;

Lab 2 Question 6 (all 3)

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

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 2nd semester help fora Algebra Advanced Algorithms Cloud Computing High Performance Computing Intelligent Agents Professional Computing Relational Database Management Systems Systems Programming