No marks will be deducted for minor spelling mistakes or missing semicolons. Minor errors in opening closing brackets single double quotes will be ignored if the rest of the query is correct. Please make sure the order of statements is correct. For i...

1. Someone also asked this question on the email. Since all books can be up for sale and loan, you do not need to include a flag. However, if you include a flag, that is also fine. 2. No, you do not need to define alternate keys (recall the lecture)....

Hi, I do not agree with your observation. The first question about multiplicities is from conceptual modeling that was covered before the mid-term. Also, the first few questions in SQL are from topics that were covered before the mid-term. Cheers

No, alternate keys are not important, but you need to include primary keys and foreign keys in the logical model.

Hi I have added a clean copy without solutions. Cheers

I went through the recording and that is all you need for implementing views in sqlite. Hence I made the note under sql videos that the recording is under the lecture recording.

Hi, How strictly will the syntax of the SQL be marked? As this is closed book, there is no guarantee we will remember all the SQL syntax perfectly so it would be great to know what the leeway for that is. Thank you,

Hi, I have a few questions related to the the logical modelling section to discuss. Q1 . When there is mandatory,AND constraints, shouldn't we be putting flag attributes in the single relation? In the sample question it is not included. Q2. Is there ...

In the sample paper provided, there are no theory questions covering the material up to the midterm exam. Will there be any theory questions from that portion in the final exam?

Hello, For question 2 in the provided practice exam, do we need to include alternate keys in the BookLoan relation? Or in general, do we need to include alternate keys in any relation that we write up in the exam? Thanks

Hi, just wondering if there is a clear unmarked practice exam that doesn't have the answers written all over it? Cheers

never mind, I found the answer in a previous help forum post, thank you It's in the October 9th lecture, but the video is only black up until the 49 minute mark so just fast forward to there if anyone else is looking for the same thing.

Hi, just wondering if there is a lecture that covers the practise exam? If so where is it and what label does it have? The last few lectures uploaded on LMS are broken (just black screens). In every other unit I've done so far there is always a final ...

hey can someone please share the answer of lab5 question no 7.I can't figure that one out. Thanks in advance.

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

This would be a correct assumption.

I also found this article that confirms that Mehwish told us to refer to the ERD to complete the take-home test. Link (https secure.csse.uwa.edu.au run help1402?p np opt B505 year 2024)

Hi, In the 30 Sep 2024 lecture, "I can do a recording for those slides, and that stuff is not really in SQL light Three. but I will put a little recording there of I will call it views part two." so can I assume that the content not covered in the lect...

What is the correct cardinality between HiredVehicle and Vehicle in the case study? Question 21 Answer a. One-to-One b. Zero-to-Many c. Many-to-Many d. Zero-to-One Feedback Yeah as correct answer was supposed to be one-to-many but it was not in the options but ...

For the theory test, I was under the assumption that the ERD drawing provided to us would be correct, however, many of the relationship type between entity questions are conflicting. For example "" Question 2 In the case study, what type of relationsh...