We are planning a new system with a new DB (MS SQL Server).
We have the following entities and the following relations:
Entities: Clubs, Chains, PaymentTypes, etc...
Relations: Clubs-Chains (M-M); (Clubs_Chains)-Commission (1-1); Clubs-Chains-PaymentTypes (M-M);
- Commission is a numeric field containing perecentage value , and is not an entity.
We would like the DB to be normalized. We thought about the following option, but we are not sure if it is the best solution for the scenario:
Clubs_Chains table: ClubChainID PK int not null, ClubID FK int not null, ChainID FK int not null, Commission int
Clubs_Chains_PayMethod table: ClubChainID PK int not null, PaymentTypeID PK int not null