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 selected article

Showing 1 of 684 articles.
Currently 107 other people reading this forum.

UWA week 36 (2nd semester, mid-semester break) ↓

Lab 04 - Question 05 (all 8)

5:53pm Thu 5th Sep, Kundan J.

"*Question: Find the item_ids that are either 'INK-RESIN' or 'INK-WRSOL' but not both in the po_items table. Hint you need to use UNION and INTERSECT operations.*" If you see the dataset from items table as below, IRN and IWS have one entry each for 'INK-RESIN' and 'INK-WRSOL'. Hence none of these item_ids are having both description or multiple entries in items table. item_id|descr|on_hand|price P9|9KG PAPER|300|25.25 P12|12KG PAPER|700|49.99 P18|18KG PAPER|100|100 IRN|INK-RESIN|3|500 IWS|INK-WRSOL|5|350 CBD|CARDBOARD|47|15 Now po_items table has these item_ids. As per question, we should be getting 'IRN' and 'IWS' both but only 'IWS' is expected in the output. Is my understanding correct about this question?

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