O'Reilly logo

Data Modeling Made Simple with ER/Studio Data Architect by Steve Hoberman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

There is a lot of data out there, but how do you sift through it all to find what youre looking for? Thats where keys come in. A key is one or more attributes whose purposes include enforcing rules, efficiently retrieving data, and allowing navigation from one entity to another. This section defines candidate, primary, and alternate keys. Surrogate keys, foreign keys, and their importance are also explained. You will be creating and editing each type in ER/Studio.

A candidate key is one or more attributes that uniquely identify an entity instance. The Library of Congress assigns an ISBN (International Standard Book Number) to every title. The ISBN uniquely identifies each title and is therefore the titles candidate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required