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).

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...

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

Yes, I believe that is the typo. From the db schema given in the case study description, it is stated that po items (job id, po id, item id, quantity)

Good day, I would like to know how is the grading system works in moodle? For example on the lab-01 Question 1, setting the primary key with without Not Null will give you the same output unless data is inserted to verify the restriction. Question 1. ...