Search code examples
databaseentity

Can weak entity have multiple identifying strong entities?


Can a weak entity in databases have multiple identifying strong entities?

The primary key for the weak entity would be the summation of the primary keys of the identifying keys (which exist as foreign keys in the weak entity).

What are the implications of such a design?


Solution

  • Combing two unique key values to create one is a valid method as long as both unique keys combined have a one to one relationship, Meaning the combination of the two unique keys would never result in the same value.