I think these two pictures you provided describe the same concept regarding a 1 1 relationship with mandatory participation on one side. Client is designated as the parent (since every client exists, even if they don't have a preference).Preference is...

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 Ro...

You can have a look at Week 7 slide, these are very helpful.

Hello - the Sep 23 lecture recording appears in echo but is has no audio or visuals. Thanks, Mia

In the lectures it was stated that a bridging table that represents the relationship and its attributes should be made if there is a many to many ( ) relationship, such as that between vehicleType and dailyTariff in the Projects ER Diagram. However...

Hey quick question where did you get your mid-sem test back? I still haven't recieved mine yet and I don't why everyone got theirs do you get your answers in the labs? Please do tell

Can I play the idiot card for this question because I have fooled myself with answer sheets before? I marked the examination paper so that there was no doubt which answer I chose, I chose answer E but then circled D, which makes no sense. I correct...

HI,Mehwish I had the same wrong mark question as other student. But I found a problem that I can't submit the form cause I've already submitted before. So could you help me? How can i handle this question?

Hi, Can anyone please advise why it is a 1 relationship as HireVehicle (1..1) and Invoice (0.. ). I would think it should be a 1 1 relationship because a single hired vehicle identified by (regNum, Date) can only be associated with zero or one Invoic...

Imagine a database and I ask you to find information on room "1234" in the past two years. That room is supposed to be on multiple lease documents in the database to get information about who leased that room. This is the same as leasing a house. A h...

Hi, Yes as discussed in the logical modeling, you may need to create new relations. Cheers

Further to my last reply, I request students not to run their imaginations wild while trying to guess the answers they filled-in during the exam D The scanners are pretty good at UWA. There could be other issues, such as the scanner not recognizing ...

Thanks for letting me know. Can you please fill out the form? Please mention in the description what you have mentioned here. cheers Mehwish

Here are the screenshots mentioned.

Good evening, I have a question about the second part of the project when it comes to resolving relationships between a "mandatory participation on one Side of a 1 1 relationship" scenario. In the lecture for Week 7, it's stated that "entity with opti...

I received an email from Dr Mehwish and she will check it on Wednesday. Those who are facing the same problem, I would suggest to fill up the form as its reopen.

yes I think the same. i choose the same answer and cant think why option c was chosen.

Greetings, This might be a little late but i was cross checking my marks for the mid term and I think there has been some error on how my answer sheet was checked . I was given 13 20 as the final result but when i checked myself maximum of 5 marks sho...

We're in the same boat.

Hi, It states in the notes for week 9 that a recorded lecture will be provided for today (23 September), however I am unsure where to find it. It is not on echo360 at the time of writing. Thanks