[Rapiddude]

I'm trying to understand relationship dependencies at the moment (in the context of ER/ERD diagrams). And I have one question that I can't seem to find an answer to.

Say I have a one to many relation ship (1:N). Is it possible for the entity on the 1 side of the relationship to be dependent to the N entity?

[Haibundadam]

Yes.

In either a Parent (1) or Child(N) dependancy.

[Rapiddude]

Cheers for the answer!

Althought its left me rather confused. I haven't yet seen an example of such a dependency- could anyone recommend any good websites on the topic?

[Haibundadam]

This is just stuff that I've picked up with my job, soI don't know of any specific books, sorry.

An example of your situation might be:

Table of Customers -< Table of Customer Transactions

Let's say you want to delete a customer, if you had the transaction table with a foreign key of the customer table key they are now independant.

If you make the transactions table key a child key then anything you delete off the customer table can be automatically deleted without your intervention.

It works the other way around too.

Hope that helps.