We will create domains in ER/Studio in Chapter 11, Data Dictionary.
· 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 ...