For my scenario i actually do want entry in table C to be deleted. Because c only exists in the lifetime of a. So if a goes, so does c.

How can i achieve my scenario. It has to be many -many relationship.