Hi, if anyone is having difficulty with the SQL questions on the project sheet where you need to find the most frequent value in an attribute you may find the third answer to this useful (the third answer works even if multiple attributes have the sa...

When I spoke with a lab facilitator they said we could just write it in as a regular attribute.

Hi, I'm a student in the unit. It seems that there should be two foreign keys in HiredVehicle both referencing depotID - one for the depot the vehicle was picked up from and one for the depot it will be returned to. There would be no point to recordi...

We were sent an email with the information.

Hi, Mehwish replied to a post asking about the unspecified data types lengths; She said you can make your own assumptions. The forum post I was referring to is "Project 2 - Data Type Clarifications for Client, Vehicle Type, Vehicle, Insurance, Hired...

You have to specify that a primary key is not null manually. From the SQLite docs (https sqlite.org lang createtable.html the primary key) "According to the SQL standard, PRIMARY KEY should always imply NOT NULL. Unfortunately, due to a bug in some...

Hello - the Sep 23 lecture recording appears in echo but is has no audio or visuals. Thanks, Mia

In the case study, it mentions that tariff type and depot should be recorded when a vehicle is hired - am I correct in thinking that these are foreign keys in the Hire entity (which connects Vehicles and Clients) and hence we shouldn't write them int...