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 6 articles in this topic
Showing 6 of 612 articles.
Currently 114 other people reading this forum.


 UWA week 32 (2nd semester, week 3) ↓
SVG not supported

Login to reply

👍?
helpful
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 queries? For example, do we have to know how to write these: - R U S - Pcol1, . . . , coln(R) - rR(myCount) ÁCOUNT propertyNo (σrent > 350 (PropertyForRent)) ... *(I just copy from the slides, you can check the attachments to be clearer) Regards,


SVG not supported

Login to reply

👍?
helpful
3:08pm Tue 6th Aug, Jichunyang L.

Hi, Please focus on the SQLite queries, but remember the logic behind the relational algebra operations.


SVG not supported

Login to reply

👍?
helpful
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

Login to reply

👍?
helpful
3:29pm Tue 6th Aug, Jichunyang L.

For example, if you meet this question, you should know how to calculate the answer.



This article has 1 attachment:

 

SVG not supported

Login to reply

👍?
helpful
12:25am Wed 7th Aug, ANONYMOUS

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


SVG not supported

Login to reply

👍x1
helpful
10:20pm Wed 7th Aug, Mehwish N.

May be :)

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