In Attribute Dictionary do I need to write down the Foreign Keys or not? Thank You

No, the depot itself is the loaction. What it means is location address is written per depot.

In Attribute Dictionary do I need to write down the Foreign Keys or not? Thank You

I m having trouble understanding the meaning of Q5 in Lab 4, particularly the phrase, "but not both in the po items table." Based on the data given, no job id has both item ids in po items, and no po id has both item ids in po items. Am I working w...

I thought I would add some late mail to this. The code runs because SQL likes it ? However the rule that was introduced in the lecture states that with select a, b then a and or b must be either grouped or an aggregate function. B is the correct an...

Hi everyone, I m currently looking for a teammate to work with for our CITS1402 project. If you re interested and happen to have no mate at the moment, feel free to reach out I m organised, collaborative, and eager to get started. My student ID ...

1. I understand we cannot put FKs as a listed attribute on the ER diagram attribute dictionary, but what if this FK would be a part of a PK? Is it okay to not have an attribute identified as the PK or do we have to find some other PK? 2. In the occere...

Hello Teaching Staff Does our ERD have to follow the same structure as the one in the case study? My extended research has found some other methods that include the same information. I found one that I thought was easier to implement and included al...

Hello Teaching staff LMS does say there is no text book required for the course. Then there is the readings section on LMS which does say that that we have a "should buy" for the text book x 2. We have also been advised to read chapters. I think we...

Hello Teaching staff Could someone please give me an update on my second query from Wed 4th Sept, relationship attributes? The reason for this is that the alternate diagram structures from lesson 4, ER modelling are confusing me. There is an instanc...

Yes, that is a very good point Though you do not have to include invoice right now, in the second part, I'll show that business requirements can change and suddenly the client realises that they have missed some requirements. Invoice is coming in pa...

1. What should i do about this error for both the ERD and dictionaries pages? I uploaded my PDFs for both, but afterwards it would come up as text with an error message when i try viewing it again, and am not sure if anyone else is experiencing this ...

Hi there, Just wondering as I've received only confirmation email of ERD model, but not for Data Dictionaries. Please advise if we will receive both confirmation emails of assignment submissions. Thank you

Yes, you can have your own assumptions.

You can include superclasses and subclasses separately in the workbook. You can use normal attributes as you mentioned above.

Can any assumption attribute can be added in subclass?

Hi, Personally, I prefer the number of available hire cars in every depot. Kind regards,

Hi all, I'm confused about formatting the answer. If there are subclasses (a1 and a2) in an entity(A), should I demonstrate them in the "Attribute Data Dictionary" workbook as 2 entities (a1 with attributes x1, y1, and a2 with z2, v2), or do I have t...

GROUP BY in SQL is to group rows that share a common value in one or more columns so that you can apply aggregate functions (like AVG(),COUNT(), etc.) on each group separately. Without GROUP BY, aggregate functions will operate on the entire result s...

could you give a hint why we need to use GROUP BY ?