Anyone know this ERD question? (2 Viewers)

[MrBrightside]

Thanks.

 

[MrBrightside]

It's 12:30am here so i may get this wrong but i'll go for D.

How did you come to that conclusion?
specifically for Video to Movie?

 

[fakermaker]

I got D as well, but I suck at these so it was largely a guess. My logic:

Customer - transaction = One to Many. One customer can make many transactions, but one transaction cant have many customers.
Transaction - video = Many to one. Many barcodes can be used in the transaction process (for many videos), but each only link to one video barcode.
Video - Movie = Many to One? This is the only possible answer from my deduction. However, I would have assumed the correct answer would be Many to Many (which isn't up there).

Would love confirmation and suggestions.

 

[MrBrightside]

I got D as well, but I suck at these so it was largely a guess. My logic:

Customer - transaction = One to Many. One customer can make many transactions, but one transaction cant have many customers.
Transaction - video = Many to one. Many barcodes can be used in the transaction process (for many videos), but each only link to one video barcode.
Video - Movie = Many to One? This is the only possible answer from my deduction. However, I would have assumed the correct answer would be Many to Many (which isn't up there).

Would love confirmation and suggestions.

D is correct. I suppose It's many Videos (i.e Many Movie IDs to one Movie title) because they said they have duplicates, therefore Many Movie IDs can only have one movie title, but cannot have many movie titles, as each ID represents 1 Movie Title, but each Title has duplicates of the same film. That's why it's many to one. I.e One movie to many Video Copies - going reverse order. Get me?

 

[fakermaker]

D is correct. I suppose It's many Videos (i.e Many Movie IDs to one Movie title) because they said they have duplicates, therefore Many Movie IDs can only have one movie title, but cannot have many movie titles, as each ID represents 1 Movie Title, but each Title has duplicates of the same film. That's why it's many to one. I.e One movie to many Video Copies - going reverse order. Get me?

Yeah that sounds about right, Not sure how I'd handle it in the HSC though :/