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


 UWA week 39 (2nd semester, week 9) ↓
SVG not supported

Login to reply

👍x3
helpful
2:06pm Tue 24th Sep, ANONYMOUS

I have a take on q7 of the mid-term exam. Maybe I was overthinking on the test but I think the answer should be C, the relational algebra operation is invalid. The reason I thought the answer was C is simply because hotelName doesn’t exist on the Room table thus would cause confusion if you!re only provided with the Room schema without the Hotel schema To make B valid, you would need to use an operation like this to make it make sense πhotelNo, hotelName(σprice>50 (Room) ⨝hotelNo Hotel)


SVG not supported

Login to reply

👍?
helpful
10:40am Thu 26th Sep, Mehwish N.

c is the right answer!

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