Exam 8: Data Modeling and Analysis

In the relationship between cities and residents, the resident entity would be:

A nonspecific relationship is a many-to-many relationship.

A good data model should be flexible and adaptable to future needs.

During systems design, the logical data model will be transformed into a physical data model.

A good data model is essentially nonredundant.

A code that assigns sequentially generated numbers to entity instances is known as:

Categories of entities include: ____________, _______________, _______________, _______________________, or ______________________.

Data modeling is a technique for defining business requirements for a database.

A(n) _______________________________ key is a primary key of one entity that is contributed to (duplicated in) another entity to identify instances of a relationship.

A many-to-many relationship is one in which many entities are associated with other attributes of a different entity.

Serial codes assign sequentially generated numbers to entity instances.

In the relationship between US cities and US states, the state entity would be:

A candidate key may be a single attribute or a concatenated key.

The value of a key can be null.

What defines what values an attribute can legitimately take on?

An entity is in third normal form (3NF) if it is already in 2NF and if the values of all nonprimary key attributes are dependent on the full primary key - not just part of it.

If an employee entity had both an EmployeeID attribute and a Social Security Number attribute, the one that was not used as the primary key would be called a(n):

A(n) _______________________________ relationship is where a relationship exists between different instances of the same entity.

Generalization is a technique wherein the attributes that are common to several types of an entity are grouped into their own entity, called a supertype.

The ________________________________ is the value that will be recorded for an attribute if a user does not specify one.