The terms alternate key and candidate key mean the same thing.

More Questions from Data Models into Database Designs

• 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