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?

7 articles posted by this ANONYMOUS person

Showing 7 of 684 articles.
Currently 8 other people reading this forum.

UWA week 44 (2nd semester, 1st exam week) ↓

Week-6: SDLC

12:55am Mon 28th Oct, ANONYMOUS

Under Week-6 there is a pdf called SDLC (System Development Life Cycle) which was not covered in the Week-6 lecture and I cannot find the lecture recording where it was covered. Can someone tell me where to find the recording where this topic was dis...

UWA week 43 (2nd semester, study break) ↓

Theory test answer (all 3)

7:13pm Fri 25th Oct, ANONYMOUS

Even if you follow the ERD the correct answer for Question 2 is b-One to Many. In the ERD it's given as Client(1..1) Hires (0.. )HiredVehicle. So it is One to Many as each client can hire 0 to MANY vehicles and each vehicle can be hired by ONE client...

UWA week 41 (2nd semester, week 11) ↓

Suggestion for take Home Test and some complaints 👍x2 (all 10)

2:28pm Mon 7th Oct, ANONYMOUS

But how do you even do question 8 without joining HiredVehicle and Insurance? Shouldn't the insuranceID be placed as FK in HiredVehicle allowing us to perform a join?

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

Midsem 👍x1 (both)

2:57pm Mon 23rd Sep, ANONYMOUS

It's because the Staff table has a BranchID value D200 which is not present in the Branch table. So referential integrity is violated.

MIDTERM MARK (all 10)

10:20am Mon 23rd Sep, ANONYMOUS

Same here my marks should go up but now the form is unavailable. What should I do?

Midterm Question 7 👍x4 (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 ...

UWA week 36 (2nd semester, mid-semester break) ↓

Project 1: Primary keys (all 4)

8:14pm Tue 3rd Sep, ANONYMOUS

Hi, let's say for a certain entity the primary key could be a combination of some attributes which includes a foreign key. In ERD we are not supposed to note down foreign keys so in this case should I create a surrogate key?

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