help1402

It's UWAweek 42 (2nd semester, week 12)

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

Showing 4 of 612 articles.
Currently 16 other people reading this forum.

UWA week 37 (2nd semester, week 7) ↓

About Q5 in Lab 4 (all 4)

4:34pm Tue 10th Sep, ANONYMOUS

I’m having trouble understanding the meaning of Q5 in Lab 4, particularly the phrase, "but not both in the po_items table." Based on the data given, no job_id has both item_ids in po_items, and no po_id has both item_ids in po_items. Am I working with incorrect data for Lab 4? Even with the expected answer, I’m struggling to identify any logical approach that fits the question. Could someone explain the question in more detail? Thank you for your assistance.

About Q5 in Lab 4 (all 4)

7:07pm Tue 10th Sep, Jichunyang L.

Hi,

This question means "finding item_ids that are either INK-RESIN or INK-WRSOL but not both in the po_items table. I don't think you need to use 'job_id'.

About Q5 in Lab 4 (all 4)

12:17pm Thu 12th Sep, ANONYMOUS

I am having trouble to understand the questions too. In particular, the second part.

In the given data (po_items), IRN appears on the two rows as below:

004/CCC/IRN/4 006/GGG/IRN/2

and IWS appears on one row as below:

002/AAA/IWS/2

In which situation, both item_ids (IRN and IWS) appear in the po_items table? Can anyone please give an example?

Thanks.

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

About Q5 in Lab 4 (all 4)

3:05pm Wed 18th Sep, Adam W.

Hi,

You are correct, the question appears to be flawed, and includes a situation that could not happen, but adjusting at this stage may cause everyone who attempted and got it right to have to re-do it at this late stage. the answer is still achievable though, but just doesn't work as intended.

A better question would have been:

Find the item_ids that are either 'INK-RESIN' (IRN) or 'INK-WRSOL' (IWS) from the po_orders table, but exclude any items that are also present in the po_deliveries table. Use UNION and EXCEPT operations to filter the results.

Thanks, Adam.

ANONYMOUS wrote:

I am having trouble to understand the questions too. In particular, the second part.

In the given data (po_items), IRN appears on the two rows as below:

004/CCC/IRN/4 006/GGG/IRN/2

and IWS appears on one row as below:

002/AAA/IWS/2

In which situation, both item_ids (IRN and IWS) appear in the po_items table? Can anyone please give an example?

Thanks.

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