GEN Database: Schema Constraints
The external RDB schema (or EER Diagram) is first converted to Third Normal Form.
Other attributes that would normally comprise a user-defined (and typically composite) primary key can be removed during schema or EERD conversion to Third Normal Form.
This eliminates redundant attributes that functionally depend on some fkey instead of the pkey attribute.