Please check the folder, it is visible now.

You need to use a union operator between the two queries. And then use orderby. Note Do not attempt this through subqueries.

Please be careful next time. I'll evaluate the existing submission.

Lab 3 is using the same database as Lab 2. I have again uploaded the database files under lab 3. Cheers Mehwish

Yes, you can have a relationship between subclasses. As far as including foreign keys as regular attributes, do not do that. Whenever, you are doubt, check the ERD in the dreamhome case study. Cheers Mehwish

Thanks for pointing that out. I'll fix it. Even if you write lab2 it will not make a difference. Cheers

I read the case study again It says "For each actual patient, their Date of Birth (D) and their Medicare number (S 12) are also recorded, along with which customer is currently responsible for paying for their treatment". For the payee that data is...

In the description, you can write some detail about the entity, relationship, or attribute. In occurrence, you should mention a fictitious sample instance. Please see the recording where we did the data dictionaries for the university accommodation c...

Hi, I have been watching the forums in the past few days. Nice to see people have some questions. I clarified some questions today in the class and later by individual appointments. First of all you need to state your assumptions. After interaction w...

Hi, No, please do not think about normalisation at this point. We are going to look at normalisation in the next part of the unit. Just focus on the stuff till (including) EER. Cheers )

Hi, I will upload a cover page in week 6. The main requirement is that your names and student IDs are there. Cheers

No, please do not include them. The first part is the conceptual model. We will take care of them in logical modelling i.e., in part 2 of the project.

Hi, As discussed in the class on Monday, I want the students to have a discussion with each other (either in person or on this forum) to try to resolve ambiguities. If there are still some confusions, I'll respond after Thursday. Mehwish

Hi Jason, I have divided the project into two parts so that students get a chance to modify their solutions to attempt the second part of the project. Once students have submitted part1, I will discuss the solution to help students rectify errors in ...

Hi, Some of our lab facilitators have Macbooks. Did they try to troubleshoot the problem? Mehwish

ANONYMOUS wrote Dear Anonymous, Thanks for your query. Following instructions is part of the unit and your degree at UWA. Most of you are first year students and playing around with file-extensions, using command prompt, traversing directories will h...

Hi, it can sometimes take up to a few hours. It is available now. In case the recording is not available within 24 hours, you can contact teaching operations.

No, we are going to have sufficient time during Thursday's lecture to cover the contents for the workshop.

Yes, I'll provide the lecture slides at least 1-2 days in advance. Mehwish

Welcome to CITS1402. Please post your queries related to CITS1402 on this forum. The forum will be checked once in the morning and once in the evening from Monday - Friday. We will endeavor to reply to your queries as soon as possible. However, pleas...