Composite Primary Keys

Owned by Computer Science Department
Aug 01, 2023
1 min read

  • Composite primary keys are useful in the following two cases:

    • As identifiers of composite entities, in which each primary key combination is allowed once in M:N relationship

    • As identifiers of weak entities, in which the weak entity has a strong identifying relationship with the parent entity

      • Represents a real-world object that is existence-dependent on another real-world object

      • A real-world object that is represented in the data model as two separate entities in a strong identifying relationship

Â