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


 UWA week 35 (2nd semester, week 6) ↓
SVG not supported

Login to reply

👍?
helpful
10:58pm Wed 28th Aug, ANONYMOUS

Hi, While I am practicing for the midterm exam, I have following questions: 1. On worksheet 1, at the query for CREATE TABLE, I am not so sure about the type of isOwnerOccupied is BOOLEAN. As I look up on the internet, I don't think SQLite3 has type of BOOLEAN, instead it uses INT and store 0 | 1. Is this a typo or 2. On worksheet 3, at Q5.1, is the RA for "List all hotels" just Hotels ? I think it is missing the pi letter ? 3. On worksheet 3, at Q5.2, what is the meaning of this symbol "^" in the middle of "select type S, with price < 20, in relation named Room" ? 4. In lecture slide for week 3, slide 40 (EquiJoin) and slide 43 (Natural Join) both give same result. Both RA is just different by the predicate. So in the mock exam, at Q4, is B also a correct answer ? If not, what is the real difference here ? Does the slide give wrong information ? 5. We are studying what covered the past weeks. But we have not looked at Right Outer Join. Will this be include in the exam as well ? Thank you

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