Final exam will be closed book. Cheers

I want to do the project by myself what I supposed to do and regarding project what is basically has to be submitted in part 1?

I am aware that foreign keys should not be presented in an ER diagram, but what about the "Attributes Data Dictionary". Do I need to include foreign keys in the table or not?

can i do the project individually?

i am not sure about Relationship name. ex) One branch has many staffs . has is the relationship. also is Has the relationship name as well?

With Project 1 it is stated the submission link is on the Jinhong server (opened on 26 August). I cannot see this link anywhere on the Jinhong server, is it available yet on the RDMS server, if so could it be pointed out. Thanks.

ANONYMOUS wrote Yes you are right The SQL standard requires that HAVING must reference only columns in the GROUP BY clause or columns used in aggregate functions. However this usage of HAVING clause is supported and workable in SQLite MySQL (Yes we a...

They did not take in our question papers in WTLTS G106 exam hall, I thought it was mandatory to submit. I specifically asked an invigilator, and she told me to just take it with me. Is that going to be an issue?

Mehwish stated in an email on Tuesday that Everything that was taught till 11 52 am Monday 26th August will be part of the exam, including labs, lecture slides, worksheets, tutorial, any reading that was given to you as homework, and sql videos. Basc...

Hi, I'm just wondering if ERD's are one of the things we've covered so far that is expected to be in todays mid term exam?

Hey im looking for a project partner, if you still need one email me. My student number is 24224298

In that case, shouldn't the GROUP BY clause also have phone and city in it? In one of the slides I saw that if attributes are not in an aggregate function in the HAVING clause, they must be mentioned in the GROUP BY clause.

Hi, would like to know in advance if the final exam for this unit is closed book, or we can bring note with us?

Hi, Best to check which type of ER diagrams you will need to use, those are crow's feet notation https vertabelo.com blog crow-s-foot-notation If you want to model using UML https www.tutorialspoint.com uml uml basic notations.htm Have a look thro...

Hi, Having guides cheat-sheets can be really useful, so have a look at pages like this for reference https www.tutorialspoint.com uml uml basic notations.htm Thanks, Adam. ANONYMOUS wrote

Hi Harrison, 'Entity Entity is a concept to abstractly represent all instances of a group of similar things . Entity Type It is collection of entity having common attribute. Entity Instance An entity instance is a single occurrence of an entity....

Hi, One obvious way to identify fan traps early, is the M 1 M relations, and for Chasm is there being the presence of optional participations, this is a good post to look over that goes into some detail https stackoverflow.com questions 14328319 fa...

I think the correct answer shoulb be 6. First we compute the projection a,b from R, we can get (1,2) and (2,2)(we will delete the duplicate row), then the projection a,c from T (3,2)(2,2)and(1,2), lastly we perform the Cartesian product,which involves ...

Project will be graded based on the performance in the take home test.

You are encouraged to identify fan trap and chasm trap in the first project. But don't worry, you will be provided a solution ERD after project1. You can proceed with Project 2 using this ERD.