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 111 other people reading this forum.


 UWA week 43 (2nd semester, study break) ↓
SVG not supported

Login to reply

👍?
helpful
11:56pm Sun 27th Oct, ANONYMOUS

1.for q4 of the written portion,i used case since we only have to sort by fName if the lname is the same?is that accepted or do we have to use order by only? 2.for q7 of written portion,i used and equijoin instead of a left join but i have specified that where can be null so it will return both null and not null queries.is that ok?(added note:isnt union all the same as union?) 3.for q8 of written portion,can we select fname,lname from staff then do join on parking lot and covered using spaceNo and set where condition of capacity>50?the subquery is the join parking lot portion also just to confirm transactions isnt included in the exam right?

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