Updated: 06 July 2024
- Non-identifying
- Consider books and owners. A book can exist without an owner or change it’s owner. The relationship between a book and owner is non-identifying. The primary key of the parent is included in the child but not as part of the child’s primary key.
- Identifying
- Consider books and chapters. A chapter only exists when a book exists. The relationship between a book and its chapters is an identifying relationship. The primary key of the parent is included in the primary key of the child entity.