Say I have 3 tables in a Tennis Application (stripped down removing irrelevant info):...Competitions...Id (PK)...Matches...Id (PK)...CompId (FK)...CourtAssignments...CompId (PK),(FK)...CourtNumber (PK)...MatchId (FK), (Unique)...To describe the above:
A m...