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?
10 articles posted by this ANONYMOUS person
Showing 10 of 684 articles.
Currently 40 other people reading this forum.


 UWA week 44 (2nd semester, 1st exam week) ↓
SVG not supported 6:12pm Mon 28th Oct, ANONYMOUS

I was also wondering the same thing


 UWA week 43 (2nd semester, study break) ↓
SVG not supported 10:26pm Thu 24th Oct, ANONYMOUS

are the marks not released yet??


SVG not supported 5:53pm Tue 22nd Oct, ANONYMOUS

Me too


SVG not supported 5:53pm Tue 22nd Oct, ANONYMOUS

I have been waiting for the same


 UWA week 41 (2nd semester, week 11) ↓
SVG not supported 9:40pm Tue 8th Oct, ANONYMOUS

I was actually asking when we will get the MCQ exam results. Thanks


SVG not supported 1:53pm Tue 8th Oct, ANONYMOUS

Hi, I just wanted to know when we will get the marks for the first part of take home test (MCQs?). Asking because we can get marks instantly for SQL part, not it is not the case for MCQ part, I wonder why.


 UWA week 37 (2nd semester, week 7) ↓
SVG not supported 6:40pm Tue 10th Sep, ANONYMOUS

In Attribute Dictionary do I need to write down the Foreign Keys or not? Thank You


 UWA week 35 (2nd semester, week 6) ↓
SVG not supported 9:31am Fri 30th Aug, ANONYMOUS

In that case, shouldn't the GROUP BY clause also have phone and city in it? In one of the slides I saw that if attributes are not in an aggregate function in the HAVING clause, they must be mentioned in the GROUP BY clause.


SVG not supported 1:25pm Thu 29th Aug, ANONYMOUS

I was thinking it would be SELECT creditcode, count(cust id) AS 'Number of Publishers' FROM publishers WHERE city IS NOT NULL OR phone IS NOT NULL GROUP BY creditcode HAVING COUNT(cust id) 2 ORDER BY creditcode; Am I wrong?


SVG not supported 3:33pm Wed 28th Aug, ANONYMOUS

Hello, While I was preparing for the mid-term exam, in one of the slides I found the statement If SELECT list includes an aggregate function and there is no GROUP BY clause, SELECT list cannot reference a column out with an aggregate function. For e...

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