while some students are whining for Project exam; I wanted to say thanks to the Unit Coordinator Lab facilitators. You guys have put a lot of effort into teaching labs preparation and that needs appreciation. One can say that you are being paid for ...

Hi, I was wondering if for Q5 of the first part of the take-home test we are supposed to only follow the ERD model and case study, or are we supposed to apply real world common sense for answering it? Thanks

In the earlier forum post, the lecturer replied that you should follw the ERD https secure.csse.uwa.edu.au run help1402?p np opt U505

Hi, I wished to confirm what our source of information should be when answering Part 1 of the takehome test. There is at times contradictory information between the ERD model and the written version of the case study. For ex. the primary key nominate...

You shouldn't use any AS operations here, you only need to select the attribute mentioned, some Questions have Python code embedded using to lowercase sentence case etc. on student answers to standardise output, and attempt to make the questions case...

We have turned off the penalties, you should be able to test repeatedly.

There was a solution provided I believe, and the questions mention any ambiguous attributes entities that may exist. I would suggest trying the questions, and observing the output, that will show what the expected attributes are, and the question woul...

Would it not have been completely valid to make the regNum the PK of Vehicle though? In fact, the provided ERD specifically says that regNum should be the PK. So now that I've made my own schema with that assumption I lost marks for following the ERD...

Here is the Question Find the po ids that have ordered items costing more than the average price of all items, along with the total cost of those items. Hint use a subquery to calculate the average price of items.

It was stated that we are supposed to answer the sql quiz based on our own logical model representations, but if we do that the answers are wrong because we have to follow a certain schema set by the quiz. So are we supposed to answer based on our lo...

In the afternoon, when we made it two attempts, the penalties were removed.

Thank you. We will check that.

Q6.List all vehicles (registration number and fleet number) that have been hired and their associated vehicle types. Only include vehicles that have been hired (use a Join). Hint VehicleID is an attribute VehicleTypeID is an attribute In this Question,...

It was deliberate not to post the schema, so that people do not put it in AI and generate the answers. I also categorically discussed and mentioned in announcements that you were not supposed to discuss the test anywhere. It comes under academic misc...

I am aware of this. We are going to ignore that question.

We have provided the table names that you are supposed to use. They match with the ERD. Any bridging tables have also been named along with PKs.

This is what I have mentioned in the instructions "Please use the case study and ERD provided to you to answer this part."

Except for any general comments, you are not allowed to discuss the test with each other or on the forums. I made that clear. If you have queries, you should email them to the teaching team.

If you remember in the class we had discussions on whether you can create unique PKs or not. A number of students did that and some did not. Hence, where we felt necessary, we have provided some key attributes and PKs.

Hi, You had to derive that schema from the ERD provided to you. Where we felt necessary, we have provided some key attributes.