Hi guys, I have used select statements to extract the attributes of all the attributes for entities I could think of. If you guys need attributes for anything else let me know and I'll try find them too. HiredVehicle: HireID, Date, CardType, CardNo, Odometer, Days, VehicleID Insurance: InsuranceID, PolicyType, Cost, HireID Vehicle: VehicleID, RegNum, FleetNum, Colour, VehicleTypeID VehicleType: VehicleTypeID, Make, Model, Doors, Body, Trim, Fuel Invoice: InvoiceID, QualityCheck, DatePaid, FinalCost, HireID Client: ClientID, Street, City, State, Postcode Booking: BookingID, StartDate, HireDays, Colour, ClientID, VehicleID, DepotID Depot: DepotID, Street, City, State, Postcode, Email Have a nice day

Bro you’re a legend for posting the schema thank you so much for this! Teaching team why didn’t you guys post the schema? It clearly shows that you guys aren’t doing a good job on creating the assessments for this unit?

And the most ironic thing is you guys say “You should know the schema before doing sql questions” and you guys didn’t even post it for us? Shame on you teaching team remember that we are paying thousands of dollars for this unit don’t forget that! The least you can do is at least make the questions make sense?

Thank you, this definitely should have been provided by the UC prior to the test opening.

You are an absolute legend I hope you have an amazing year

You are a life saver! thank you!

hi, these are the schemas we need to follow?

It was deliberate not to post the schema, so that people do not put it in AI and generate the answers. I also categorically discussed and mentioned in announcements that you were not supposed to discuss the test anywhere. It comes under academic misconduct to discuss and post solutions on the forums when you were explicitly told to figure out the schema yourself. If this "Bro" has figured it out then you all can do it too. Now, let me figure out how the help forums database is implemented :) Cheers Mehwish Cheers

👍