The more I delve into project, more clarity I am getting for the topics we studied in lectures. I have worked fair bit on the project, still seems I am quiet far from finish. I see project part-1 had a late submission tab. is there any such option for...

Sure Please make individual submissions (though they will be similar). Also attempt the test individually. Cheers

- Same street address can be in different postcodes so a street address is not determined by postcode (nor vice versa). E.g., 1 Other street Nedlands 6009 and 1 Other street Perth 6000. - Phone numbers Email Follow the rules from the lecture )

Hi, This was likely a glitch. You can access it now

Thanks Mia.

I delved into that particular part in the video, because it was going to be in the mid-term. That video was released before the mid-term.

At the beginning you can include DROP statements for all the tables in your database. This to ensure that when I am going to run your database, I do not have any existing tables with the same name Cheers

Hi, If the vehicles were picked and dropped at the same location, there was no need for two relationships. In reality, one can pick and drop the vehicles to separate depots. Also, this sample ERD is one way of solving the project. Students can offer ...

Hi, The standard approach has been discussed in the lecture under logical modeling. However, it is also possible to deviate from the standard approach. You need to look at the connections between the subclasses superclass with rest of the ER model. I...

Time duration Some students made a valid argument about issues with the internet during this week and were wondering if the situation continues next week, then that may impact their performance. Just to put everyone at ease, I have extended window f...

Time duration Some students made a valid argument about issues with the internet during this week and were wondering if the situation continues next week, then that may impact their performance. Just to put everyone at ease, I have extended window f...

Hi, Yes triggers and views are included. You need them for the project so please practice them. Cheers

In the 2nd paragraph of the case study it does say Depots have an email address each (S 24)

Hi,I just want to know the scope of the take-home test, will it contain content after lecture 9?(for example,nomination and trigger?) or just all about project2? Thank you.

will there be a time limit for doing the takehome test that is when we have started it will we have a limited time such as 1 or 2 hours to complete it?,if so what would be the time limit?

Hi, Could you please advise when the take home test opens and closes in Moodle? Thanks.

I do not know why they would take away access for this, it is very inconvenient.

There is an attribute in the Depot enntity in the ERD model, 'email'. Shouldn't this corrected email attribute be in the Client entity? As the case study specifically said there are one or two email for the client, and none for depot.

I'm not sure if I'm missing something in the case study, but could someone clarify the difference between the Days attribute in the HiredVehicle relation and the hireDays attribute in the Booking relation? Are they referring to the same concept (The ...

I am also interested to know more on this too. And if there are deductions made to our take-at-home test grade what is the most we can lose what is the weighting of each deduction?