Foreign Key Redundancy
Posted by: Kevin Kowitski
Date: December 12, 2016 10:05PM

I have a schema with several many to many relationships. I have a few tables which have redundant foreign keys. see below:

OverallScore_Event_id
OverallScore_Event_EventProducer_id
OverallScore_Event_Company_id
Event_id
Event_EventProducer_id
Event_Company_id

is this a setup I should keep for simpler query writing, or would it be better design to remove some of these redundant keys and use a query path through one of eh foreign keys to obtain information; "daisy chain" type of data mining?

Options: ReplyQuote


Subject
Written By
Posted
Foreign Key Redundancy
December 12, 2016 10:05PM
December 12, 2016 11:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.