IT Quiz 4

A ____ attribute can be further subdivided to yield additional attributes.

Composite

A ____ attribute can have only one value.

Single-Valued

A ____ attribute is one that cannot be subdivided.

Simple

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Weak

A ____ identifier is composed of more than one attribute.

Composite

A ____ relationship exists when an association is maintained within a single entity.

Unary

A ____ relationship exists when three entities are associated.

Ternary

A ____ relationship exists when two entities are associated.

Binary

A ____ should be a derived attribute.

Person’s Age

A derived attribute ____.

Need not be physically stored within the database

A derived attribute is indicated in the Chen model by a ____.

Dashed Line

A relationship is an association between ____

Entities

A(n) ____ entity is composed of the primary keys of each of the entities to be connected.

Associative

A(n) ____ might be represented with a single-valued attribute.

Person’s Social Security Number

An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

Existence

Another word for existence-independent is ____.

Strong

Attributes may share a ____.

Domain

Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

Information

Ideally, an entity identifier is composed of ____ attribute(s).

One

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.

Recursive

If an entity can exist apart from one or more related entities, it is said to be ____-independent.

Existence

In an ER diagram, primary keys are indicated by ____.

Underlining

In the ERD, cardinality is indicated using the ____ notation.

Min,Max

Knowing the ____ number of entity occurrences is very helpful at the application software level.

Maximum and Minimum

Making sure all ____ are identified is a very important part of a database designer’s job.

Business Rules

Some ____ database modeling concepts can be expressed only using the Chen notation.

Conceptual

Some attributes are classified as ____.

Simple

The Crow’s foot symbol with two parallel lines indicates ____ cardinality.

1,1

The ERD represents the ____ database as viewed by the end user.

Conceptual

The ____ attribute(s) make up the primary key in the table definition:
CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

CRS_CODE and CLASS_SECTION

The ____ type of attribute cannot be created in a DBMS.

Multivalued

The associative entity is also known as a ____ entity.

Composite

The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

Mandatory

The set of possible values for an attribute is a ____.

Domain

The step, ____, occurs first in the process of building an ERD.

Create a detailed narrative of the organization’s description of operations

The term "____" is used to label any condition in which one or more optional relationships exist.

Optionality

When the PK of one entity does not contain the PK of a related entity, the relationship is ____.

Weak

____ attributes can have many values.

Multivalued

____ might be represented with a multivalued attribute.

Household Phone Numbers

____ relationships are most common.

Binary