A practical example could be if you had a table of student table with names, degree, and grade, you want to get the average grade for each different degree the students are taking. You would add GROUP BY degree, so it would get the AVERAGE(grade) for ...

I altered the question to give an error message referencing the unnecessary parenthesis as the reason for the error. It does appear SQLite doesn't like the use of them in SET statements and will raise an exception. Adam.

Yes it does appear to be an issue with the parenthesis, I tried adding them into the correct solution on the test interface and it does appear to break it, I'll investigate if this is an SQLite issue, or to do with the testing code implemented on the...

Well the book listed is very helpful with understanding the content, you may be able to find various versions of the text book online too.

Aliases would be any alternative names for the relationship.

How is the relationship data dictionary different to the relationship-entity data dictionary, is it asking for the same information? For relationship name, is it like depot-vehicles. And what does it mean by aliases for relationships

Hello Teaching staff LMS states that a text book is not required for the course. The reading list mentions that we must have it. The text book is mentioned in the class. Do we need to refer to any textbook at all?

You should not write down the Foreign Keys in your dictionaries; all four of your dictionaries should match your conceptual ERD diagram.

Hi, As we discussed in the lecture that you can do the project all by yourself. Please start asap as this is not a project that you can do at the last minute. Cheers

Just replied in that thread.

Hi James, Sorry that we missed this. In the first part of the project, we are focusing on the conceptual design. Now that you have started logical modeling, we are going to create a new table where we see a relationship. While dealing with concept...

It was a server issue. Please check now. Cheers Mehwish

Ideally you should get the notification for both as that is what I have set in the system. Please try to submit again, and if you do not get the notification then let us know here. Cheers

In the case study, it mentions that tariff type and depot should be recorded when a vehicle is hired - am I correct in thinking that these are foreign keys in the Hire entity (which connects Vehicles and Clients) and hence we shouldn't write them int...

Is that different to the "depot's Address (A)"

Hi, You don't need to buy the physical book, an e-book is sufficient.

Hi, Please follow the same structure as the on in the case study.

ANONYMOUS wrote PK and FK can be the same, but it is not a best practice. Can you find a better FK in your table? No. You can have your own decision. It can be blank.

Hi, This question means "finding item ids that are either INK-RESIN or INK-WRSOL but not both in the po items table. I don't think you need to use 'job id'.

Hi there, Is is alright if I colour the Attributes Dictionary to make it more clear which attributes belong to which Entity. Thank you,