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

We will create domains in ER/Studio in Chapter 11, Data Dictionary.

 

              Key Points

·          An attribute is a property of importance to the business whose values contribute to identifying, describing, or measuring instances of an entity.

·          A key is an attribute or set of attributes that helps us find entity instances.

·          A candidate key consists of one or more attributes that uniquely identify an entity instance. The candidate key that is selected as the best way to identify each unique record in the entity becomes the primary key. The other candidate keys become alternate keys. Keys containing more than one attribute are known as composite keys.

·          A surrogate key is a primary key ...

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