Good day, I would need some clarification on PK for HiredVechicles. If we use Date as PK, we are unable to uniquely identify the hired vehicles as we will rent out multiple of cars at the same day. Should use a composite PK to uniquely identify each tup...

I think we can understand it as one car can have multiple invoices as the car can rent out multiple times (at different transactions different time).

Could anyone please advise the format of the take home test? I am not sure which lecture recording has the info. Thanks.

Good day teaching team, I would like to clarify some few scenarios before finalize the relations and the scripts. I have read through the case study and just want to confirm the following scenarios 1. The individual client might not be driver and may n...

Respected, I was confused regarding the format and what to expect for the take home test. I re-watched the recordings but i was still confused.

Yes, as you need to create tables and organise data in project part 2. You will apply some concepts of normalisation during the process.

Have not seen any replies on this one?

Hi, Do we require to apply normalisation to the derived relations in project part 2? Thanks

Thanks for pointing out the issues. Let me answer these one by one. This was a human error. I missed it, however, just follow what is there in the ERD. You can use any data type. Yes, there is an extra tab. I'll update that in a while. Sure. You can ...

Why are you lobbying for Q18? Those who selected A, did so because they saw a missing semi-colon in iii. Those who selected E, they looked at the query in whole (iii), which was syntactically correct, except for a missing semi-colon. That is why both ...

I submitted a form indicating I was disputing my mark. I was marked wrong on question 7 when it is now in fact correct, I chose C. I am also lobbying for a mark for question 18, I did not guess any answers, I either knew them or I was completely de...

Hi, Yes please practice some views and triggers on your data. In the take home test there will be at least one question on each of these. We are going to study these topics on Monday 30th Sept. Cheers

Hi, It was a public holiday. Some videos have been provided in the Lecture notes section.

Please check your marks now. cheers

c is the right answer

Hi, It was a public holiday. Some videos have been provided in the Lecture notes section.

Hi, I think you can easily infer the direction of the arrow based on the text. For Invoice it is Invoice --- generated for --- HiredVehicle It is mentioned in this narration "Only after the vehicle is returned an invoice is generated for the vehicle h...

Hi, I actually found some discrepacies and missing information I would like to discuss, I hope this will reach the teaching team to help me and other students to do their projects. Below I have grouped the questions according to the entity for ease of...

When considering the ERD provided, it is really difficult to understand the path of the arrow. Can you clearly give the path? As an example HiredVehicle - Invoice relationship, it is really difficult to understand the path of the arrow. I think this ...

For part 2 of the project, are we allowed to add change the PK or are we just supposed to follow what was given in the ERD provided?