Surrogate keys have much meaning for users.

More Questions from Data Models into Database Designs

• When the parent entity is required, a new child row can always be inserted.
• When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
• When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
• An ideal primary key is short, numeric and seldom changing.
• Intersection tables are ID-dependent on both their parent tables.
• The terms alternate key and candidate key mean the same thing.
• 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.
• (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

Discussion & Comments