Exam 8: Data Modeling and Analysis

The relationship between a student entity and a curriculum entity would be classified as recursive.

In a one-to-many relationship, the parent is the entity on the "one" side.

A concatenated key is a group of attributes that uniquely identifies an instance of an entity.

A recursive relationship identifies a relationship that may exist between different instances of the same entity.

An entity:

A group of attributes that uniquely identifies an instance of an entity is called a(n) __________________________________.

Which of the following statements is false?:

An entity is in third normal form (3NF) if it is already in 2NF and if the values of its nonprimary key attributes are not dependent on any other nonprimary key attributes.

A descriptive property or characteristic of an entity is:

_______________________________ is a technique where the attributes are grouped to form entity supertypes and subtypes.

A subsetting criteria is an attribute or concatenated attribute whose finite values divide all entity instances into useful subsets.

The number of entities that can participate in a relationship is known as:

An enterprise data model typically identifies only the most fundamental of entities of the enterprise.

A subsetting criteria is also known as an inversion entry.

__________________________ codes provide a top-down interpretation for an entity instance.

One form of 3NF makes sure that transitive dependencies exist in each entity.

An entity subtype is an entity whose instances inherit some common attributes from an entity supertype and then add other attributes that are unique to an instance of the subtype.

A subsetting criteria is a domain of attributes whose values are limitless to allow for a variety of subsets to be constructed from a database.

A concatenated key is also known as a composite key or a compound key.

A primary key is that candidate key that will most commonly be used to uniquely identify a single entity instance.