CSE :: Database System 2 - CS
- Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
- When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
- When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
- When the parent entity is required and the parent has a surrogate key, update actions can be ignored.