Hi, in the part 2 spec, it states that "You may also submit an assumption and clarification document...", while "Moodle - Project 2 Submission" only have "Project 2 (code in text file)" and "Relations" for us to upload documents. May I know where sho...

In the lecture on 9th September you mentioned "I'll have a look at your ER model and marks will be deducted if there are no composite attributes". I just got spooked by that so I'm just wanting to confirm that the 20 total potential grade that we can...

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

Thanks, I understand you're explanation and while I agree with the way you have explained it I still find it odd that the depotid is done the way it's done. Because there was no assumption made that the vehicles might be picked up and dropped off to ...

but the HiredVehicle is identified by (clientID, startDate), or (regNum, startDate), and one client can only hire one car on the same day. (according to Case study).

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

Can we create links in the ER model, or can it not be changed

How do you represent finalcost in the logical model since it is a derived attribute. But it is in no way connected to the rental price or the days (since they are not primary keys of their own entities)

Problem solved I ended up using python to generate CREATE TABLE and INSERT Statement.

Hey guys , in project part 1 in the announcement its specified that we can work in pairs and submit the same thing but isnt specified if we can do that in part 2 and we are still under the assumption that we can do that part 2. Are we allowed to work...

while checking Depot table for normalization, have following questions - Postcode depends on street address. and street address is linked to DepotID. does this mean there is a transitive dependency here? should I move address to a new table and then l...

considering practicality of implementation, i would have a combined table with following attributes OwnerNo OwnerType OwnerName 001 Private Joe D 002 Business XYZ PTY LTD 003 Private James and will use OwnerNo as foreign k...

while I was putting dummy data in each of the table to verify - if the table is in 3NF - if the Primary Key need to be changed; for Vehicle Type table, I can see Make Model are taken as composite primary keys, but I can use duplicate values in each of...

ANONYMOUS wrote BranchID wont be unique in some cases. so this alone cannot be a candidate key. imagine having multiple people from same branch appearing in this table of yours.

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

HI, I cannot find the specification of clientID and Insurance policy number like length of string or length of number. It's "generated" according to the documentation. Do we have suggested type of these data items? Thanks

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

Trying again... I am confused as to why Invoice and HiredVehicle has a 1.. relationship. My understanding is that HiredVehicle stores every current and past rental. Since clients can only rent one vehicle at a time, wouldn't there only ever be one in...

Hi, I am confused as to why