Designers should seek a balance to avoid an excess. When only a sub-set of the foreign keys comprise the full primary key of the fact table, it is not unusual for developers, or query writers, to ...