help1402

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 the 2 articles in this topic

Showing 2 of 684 articles.
Currently 43 other people reading this forum.

UWA week 39 (2nd semester, week 9) ↓

Midterm Question 7 (both)

2:41am Mon 23rd Sep, ANONYMOUS

Hotel: (hotelNo, hotelName, city) Room: (roomNo, hotelNo, type, price) Booking: (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest: (guestNo, guestName, guestAddress) Π hotelNo, hotelName(σ price>50(Room)) The correct option given for this is: b) This will produce a relation with attributes (hotelNo, hotelName) with a room price greater than $50. But Room does not have the attribute hotelName so without a Join operation shouldn't this be invalid and the correct answer be c)?

Midterm Question 7 (both)

5:15pm Mon 23rd Sep, Farah W.

I have the same question.

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 2nd semester help fora Algebra Advanced Algorithms Cloud Computing High Performance Computing Intelligent Agents Professional Computing Relational Database Management Systems Systems Programming