Some database designers may feel that it’s OK to arbitrarily assign all dimensional foreign keys as part of a fact’s primary key even when one or more do not actually contribute to the fact table’s ...