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

Showing 2 of 684 articles.
Currently 114 other people reading this forum.

UWA week 38 (2nd semester, week 8) ↓

Lab 4 Q5 (both)

8:15pm Mon 16th Sep, ANONYMOUS

Hi, I got the answer right by luck after multiple trials, but I still dont understand why. At the begining, I was referring 'po_items'table for the FROM as the question asks to find the 'item_ids' in the 'po_items' table, however it kept showing error. After looking at the data tables I realized there's no 'descr' column in it which caused the error everytime, but why it's still shown in the question since we never use 'po_items'in SQL enqury? Much appreciate if you could explain, cheers!

Lab 4 Q5 (both)

3:23pm Thu 19th Sep, Adam W.

Hi, The question is incorrect, a more appropriate version of the question would be: Find the item_ids that are either 'IRN' (INK-RESIN) or 'IWS' (INK-WRSOL) from the po_items table, but exclude any items that also exist in other purchase orders. However, the question cannot be changed at this stage, but future versions of it will be adjusted. That question would require a UNION and an EXCEPT. ANONYMOUS wrote:

> Hi, I got the answer right by luck after multiple trials, but I still dont understand why. > > At the begining, I was referring 'po_items'table for the FROM as the question asks to find the 'item_ids' in the 'po_items' table, however it kept showing error. After looking at the data tables I realized there's no 'descr' column in it which caused the error everytime, but why it's still shown in the question since we never use 'po_items'in SQL enqury? > > Much appreciate if you could explain, cheers!

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