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


 UWA week 43 (2nd semester, study break) ↓
SVG not supported 12:47pm Fri 25th Oct, ANONYMOUS

I see it is being greyed out instead of red green. I think there is a problem with the question 26.


SVG not supported 9:28pm Thu 24th Oct, ANONYMOUS

I thought that I was left alone..


 UWA week 39 (2nd semester, week 9) ↓
SVG not supported 8:12pm Mon 23rd Sep, ANONYMOUS

We're in the same boat.


SVG not supported 6:50pm Mon 23rd Sep, ANONYMOUS

Hi, After DROP, INSERT (some sample data), the project requires to "perform some simple queries to ensure it works correctly". So, what kind of queries are they and do they need to be listed in the SQLite script submission file? Are Views and Triggers...


SVG not supported 3:30pm Mon 23rd Sep, ANONYMOUS

Oh, you made me to compare mine and I also lost 2 marks. No idea what to do...


 UWA week 38 (2nd semester, week 8) ↓
SVG not supported 8:59pm Sat 21st Sep, ANONYMOUS

If I need some more Associative Tables (which are not drawn in the ERD) for 2 or 3 entities, it is possible for this Part 2? In addition, is driversNum written in PersonalClient license number or quantity? Thank you and best regards.


 UWA week 37 (2nd semester, week 7) ↓
SVG not supported 2:16pm Sat 14th Sep, ANONYMOUS

According to the hint "Hint use UNION then an EXCEPT operation." But why? Because the table bookjobs has both cust id and jobtype, we just need to use EXCEPT like this SELECT cust id FROM bookjobs WHERE jobtype IN ('R', 'H') EXCEPT SELECT cust id FROM boo...


 UWA week 32 (2nd semester, week 3) ↓
SVG not supported 12:25am Wed 7th Aug, ANONYMOUS

Sure, I can translate and compute it. Is that kind of example in the exam ?


SVG not supported 3:16pm Tue 6th Aug, ANONYMOUS

Cool, I know the logic may decide whether a given relation is the correct or not but I may not write down those things by myself because they are so hard to remember their names or symbols or drawings, etc. Thank you.


SVG not supported 2:34pm Tue 6th Aug, ANONYMOUS

Dear, In week 3, we have learnt about Relational Algebra such as selection, projection, etc. Do we have to remember how to write the relations using those symbols operations (U, up-side-down U, big Pi, sigma, etc..) or we just need to focus on SQL quer...

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