If I need some more Associative Tables (which are not drawn in the ERD) for 2 or 3 entities, it is possible for this Part 2? In addition, is driversNum written in PersonalClient license number or quantity? Thank you and best regards.

For the submission of part 2 of the project, should i just paste my sql code into a txt file and submit that? Will it be tested by copying from the txt file and running that code in the terminal after running the sqlite3 command?

I have seen the results posted in the announcement section. However, I am not entirely satisfied with the marks I received. To gain a better understanding, I would like to compare my answers with the official answer sheet. Is it possible to request a...

I have been waiting for the result of mid sem exam for a long time. Is it published or yet to be? Given that the exams were conducted using OMR sheets, which are generally quicker to process, I am curious to know what might be causing the delay. Any i...

Hi everyone, I'm looking to stay up to date with the latest news, trends, and insights in computer science and data science. Does anyone have recommendations for reliable websites, blogs, or newsletters where I can find high-quality articles and repor...

In a case study discussed , I am confused about the multiplicity between lease and room. I as per my point of view, a room will be under zero or one lease agreement at a time(legally). A room can have multiple records of lease agreement(some may be d...

Hi, Are we expected to write the full logical model representation first and then all the paragraphs of how we derived our relations Or on the other hand write the logical model representation for one entity then followed by the corresponding paragrap...

hi everyone, just wanted to check if we were meant to individually submit the part 1 of the project? Or was it sufficient for 1 person in the pair to submit for the two?

Hello Teaching Staff, I submitted the project part 1 on time, one day early, but it was not until I attempted lab4 that I noticed there were two different submission links. I submitted it as one pdf file, both the ER diagram and the data sheets. Do I ...

Dr Nasim, I have a few questions for the project - Is driversNum in the PersonalClient referring to the drivers licence number?or is it referring to the number of nominated drivers? - What does cName in the CompanyClient entity refer to?Does it refer t...

Hi, I would really appreciate it if i could get some clarifications regarding the project? I have 4 questions 1.Why would make and model in the VehicleType be the primary keys? Any two cars could have the same make and model(eg. Both cars are Hondas a...

As the final exam approaches, I wanted to kindly ask for some clarification regarding the format of the exam and the maximum marks it will carry. I m reaching out early so that I can plan and prepare efficiently.

Hi, I did put those attributes under Vehicle type. No you should not need the capitalisation. Cheers

Hi, Subclass is actually a special type of the superclasse. Whereas, a weak entity may be dependent for its existance on another entity, it may still be identified as an entity on its own, in combination of the attributes of another entity.

That's a good idea. I'll post the answers this week and then in the class we can discuss each question )

Hi, The question is incorrect, a more appropriate version of the question would be Find the item ids that are either 'IRN' (INK-RESIN) or 'IWS' (INK-WRSOL) from the po items table, but exclude any items that also exist in other purchase orders. However...

There was no lecture on Monday. The time-table shows that the lecture was on 18th september. You should be able to find the recording now. Cheers

Hey all, Managed to get this to run correctly with some guidance from the lab facilitator What was changed to remove this parentheses error - Removed all parentheses from the query - As such, didn't nest make any subqueries The workflow was with s...

Are we allowed to carry any handwritten notes during the final exam?

Hello, Still am getting the same error with "unexpected parentheses around UNION, INTERSECT or EXCEPT statements" Everything I've tried has worked with sqlite3 and is giving the right output, however the moodle submission just returns this error. Am I d...