Foreign Key Redundancy
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?
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.