My code and pdf are in, How do I access the take home test?

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

I too would like some clarification on this; I've heard all sorts of things regarding how certain things impact others and I am just hopelessly confused now.

Hello all, Is part 2 of the project marked or just the take-home test? I've been told different things by my classmates. Thanks for the clarification and have a great day.

Hi, When we insert a new hire to HiredVehicle, what value should we put into the foreign key depotID(returned to)? From the relationship, it cannot be NULL. Am I understanding correctly? - the value (DepotID for returned to) will be updated when client...

are we gonna be provided with a correct solution for part2? just in case we have any mistakes in it, so we can do our take home test correctly.

Yea, It would be great if we could perhaps have a slight extension for the project as there are new topics learned, so, I wanted to implement those as well.

I'm still a bit confused on how we are going to test out SQL databases with sample data. It's mentioned that we must include DROP, INSERT and SELECT statements, so are we making up our own sample data to test out databases with? 'You also need to pop...

Does this mean we have to create our own test data?

Drops, Creates, Inserts, and a few Selects primarily, I believe the wording suggested that you can include triggers and views, but it wasn't compulsory. I would have to check with Mehwish, but if you have your own test data, that may be sufficient, as...

I beleive the assignment description mentions you need test dummy data to make sure the database works, so you would need to include the insert statements, of sufficient numbers to make sure it can test the database (so maybe 10 rows per table? or a ...

When there isnt a suitable natural key present, you would normally make a surrogate key like a unique ID number, so approach 1 would be best.

this may have been solved already by the original poster, but the intent of the 'use .txt .sql' files is to submit a script file (.sql extension but it is essentially just a .txt file and opens in notepad easily), the script file will be able to be r...

I would suggest that in the case of a natural key not being able to be used (like the example mentioned about multiple cars at the same time for the same client), you would create a surrogate primary key, such as HireID etc.

Respected, Are we allowed to use our notes or cheatsheets for finals?

Respected, Are we allowed to have our notes or cheatsheets for finals?

Hi, I m a bit confused about what exactly we need to submit in the .txt file. I understand we have to include the DROP statements and the CREATE TABLE statements, but do we also need to submit the sample data, simple queries, and complex queries? Add...

Hi, I m a bit confused about what exactly we need to submit in the .txt file. I understand we have to include the DROP statements and the CREATE TABLE statements, but do we also need to submit the sample data, simple queries, and complex queries? Add...

Test will have 28-30 theory based MCQs and 10 SQL based questions. If we decide to interview you, it is expected that your code is running and you are able to explain your work.

Does the SQL file we submit have to have the INSERT INTO statements as well, or do we need to only submit the tables we created?