May I have access to review my lab4, I cannot review it at this point in time? Helpful for my SQL research.

credit https www.cs.uct.ac.za mit notes database htmls chp07.html For anyone that was looking at the anonymous superclass inquiry on here.... I found this useful but it probably reinforces the lecture notes. Method 1 All the entities in the relationshi...

Staff ... StaffID Name Salary BranchID P100 Bluey 5000 A100 P200 Peppa Pig 10000 D200 null DanielTiger 8000 A200 In the above table, can BranchID be candidate key given StaffID as primary key?

The subquery question in the midsem. I found that one a difficult one to answer because there was a video on the subquery content of that question but the lab was not released until 4 September, so we were not really drilled on it. That is we reall...

Hi, Thanks for your prompt response However, when I try converting the .db file into .sql or .txt format (by using .output in terminal or simply renaming the file format from .db to .txt or .sql), the contents often break or show up as unreadable tex...

Did anyone figure this out?

When it says "Include the relevant DROP statements" in Project 2, does that imply that for each table we have created we include the DROP statements for itself and any other tables that it depends on, or do we have one big sequential DROP statement t...

Hi Team, I have already completed most of the 2nd part of the project, however I have a major issue with it. 1. Since we are basing our SQL on the ERD, would it not work since the model we have been given is not in 3rd Normal Form which creates lots o...

Well, the student office would refer me to the UC as far as an appeal on a MCQ test, is a guess. All I can say is, that to write down 1 and 3 on the exam paper and then mark D on both the exam paper answer sheet, which is not A or E or both, was a s...

Hi, I followed up on the form. The answer for Q7 is c. You have been given a mark for that. For Q18, the answers were either A or E. That was not a guess game. As far writing the correct answer on question paper is concerned, it will not be accepted ...

ANONYMOUS wrote Sorry, it is off by 60 seconds. It is 03 Oct 11 59 pm. If you want, you can put a screenshot, but it is not required. No videos please ). We are going to invite about 10 students for an interview. If you have a thorough submission, ...

Hi, You cannot submit a .db file because in a .db file we cannot see your code. Please create either a .sql or a .txt file to run your queries. Eventually, the final submission will be in .txt file. You can simple rename your .sql file. Cheers

Hi Teaching Team, I have a question regarding how to translate superclass subclass related relationship types into SQL. Take the following relation as an example PropertyForRent propertyNo street city postcode type room rent ownerNo P...

Hi everyone, I m a bit confused about the submission format for our work. According to the submission webpage, it mentions that we need to submit a file in .txt format. However, when I convert my .db file to .txt, it only displays the tables and the...

Hi I have following questions related to part-2 1- On Moodle, deadline appears as Friday, 4 October 2024, 12 00 AM. Announcement page says 3rd Oct Midnight. which one is correct? 2- I understand it is not mandatory, however if I want to have some test c...

DR Nasim, I thought that was the basis of filling in the form? No-one has followed it up. I have my examination paper whereby I actually wrote down 1 and 3 as correct, but 3 is not correct, I crossed out 2, but on the answer sheet for some reason I...

Date and ClientID, together may work, but you can also create a new ID attribute.

Please follow the instructions mentioned in the title for that recording.

The recordings are located in the lecture slides section (.mov files).

Respected, The lecture recording of week 9 seems to be not working. I checked if it was my end, but no it was the same for my friend as well. All the lectures except it was fine.