Hi, yes, please. Kindly provide us with the answer key for the midterm examination, as we want to review where we went wrong and improve on the concepts. Thanks a lot.

Weak entities are the entities that are dependent so can we also say that subclasses are weak entities?

Hi, You are correct, the question appears to be flawed, and includes a situation that could not happen, but adjusting at this stage may cause everyone who attempted and got it right to have to re-do it at this late stage. the answer is still achievabl...

For project part 2, just wondering if there are any missed requirements for trim, model, doors and body? Also wondering if for our database we need the capitilisation to be exact to the ERD provided.

Hi, apart from the score, could we also have the answer together with some brief explanations of the mid term? Wish to review them before the final exam and have a better understanding of those concepts. Thanks a lot.

I thought that I had it with this hint from https stackoverflow.com questions 58451528 parenthesis-in-sqlite-when-combining-union-and-except-statements However; even with reformatting using what is mentioned in that post, and performing an intersect...

Yes, you can do project 2 with someone else.

I did the project part1 alone can i do the part 2 with a someone.

The lecture has been rescheduled to 18 09 2024, announced in last week's lecture..

Hi Dr Mehwish Nasim, I noticed that today's lecture recording on Echo360 is unavailable. This might caused by incorrect lecture schedule in CAS. Could you please resolve it? Best regards, Kai Zheng

Hi, I got the answer right by luck after multiple trials, but I still dont understand why. At the begining, I was referring 'po items'table for the FROM as the question asks to find the 'item ids' in the 'po items' table, however it kept showing error...

I encountered the same problem, I was thinking to UNION first and EXCEPT the descr which INTERSECT both by using subquery, but it keeps showing unnecessary parenthesis, am I doing something wrong?

Mee too I have accomplished to run it on my SQLite3 correctly but it is seems giving me an error about the unnecessary parentheses.

I have constructed a query which when entering into SQLite3 correctly returns the output displayed in the expected results. However when I enter my answer into the lab submission page it gives me some error involving parenthesis. Could there be an issu...

Good day, Would like to confirm that the logic behind this question is to find the item id that only exist once in the po item table? Cheers Yap

Good day Madam, Hope this message finds you well, this is to inform about the attachment submission of Project 1, I have submitted my project last Wednesday, 11 September 2024, at 8 15 PM, however, the document ER diagram and 4 dictionaries have been...

You can use "SELECT FROM" table name to take a look.

You are correct in using EXCEPT with IN, as it achieves the same goal. The hint suggests using UNION likely for clarity or to explicitly combine job types 'R' and 'H' before filtering. It is simply an exercise in using UNION, but both approaches shou...

When will the Mid-Semester Results be released, and will they be released on LMS or csMarks?

According to the hint "Hint use UNION then an EXCEPT operation." But why? Because the table bookjobs has both cust id and jobtype, we just need to use EXCEPT like this SELECT cust id FROM bookjobs WHERE jobtype IN ('R', 'H') EXCEPT SELECT cust id FROM boo...