Exam Ch.2

An attribute of an entity that must have a value for each entity instance is a(n): A) optional attribute. B) composite attribute. C) required attribute. D) fuzzy attribute.

required attribute.

An attribute that must have a value for every entity (or relationship) instance is a(n): A) composite attribute. B) required attribute. C) optional attribute. D) multivalued attribute.

required attribute.

A good data definition will describe all of the characteristics of a data object EXCEPT: A) subtleties. B) examples. C) who determines the value of the data. D) who can delete the data.

who can delete the data.

Which of the following is NOT a characteristic of a good business rule? A) Declarative B) Atomic C) Inconsistent D) Expressible

Inconsistent

The following figure shows an example of: carries Employees -----------------------<Dependent A) a one-to-many relationship. B) a strong entity and its associated weak entity. C) a co-dependent relationship. D) a double-walled relationship.

a strong entity and its associated weak entity.

A property or characteristic of an entity type that is of interest to the organization is called a(n): A) attribute. B) coexisting entity. C) relationship. D) cross-function.

attribute.

A person's name, birthday, and social security number are all examples of: A) attributes. B) entities. C) relationships. D) descriptors.

attributes.

A ________ defines or constrains some aspect of the business. A) business constraint B) business structure C) business control D) business rule

business rule

The most common types of entities are: A) strong entities. B) weak entities. C) associative entities. D) smush entities.

strong entities.

A fact is an association between two or more: A) words. B) terms. C) facts. D) nuggets.

terms.

In an E-R diagram, there are/is ________ business rule(s) for every relationship. A) two B) three C) one D) zero

two

Which of the following is NOT a good characteristic of a data name? A) Relates to business characteristics B) Readable C) Repeatable D) Relates to a technical characteristic of the system

Relates to a technical characteristic of the system

Which of the following is an entity that exists independently of other entity types? A) Codependent B) Weak C) Strong D) Variant

Strong

An entity type name should be all of the following EXCEPT: A) concise. B) specific to the organization. C) as short as possible. D) a singular noun.

as short as possible.

Data modeling may be the most important part of the systems development process because: A) data characteristics are important in the design of programs and other systems components. B) the data in a system are generally less complex than processes and play a central role in development. C) data are less stable than processes. D) it is the easiest.

data characteristics are important in the design of programs and other systems components.

Customers, cars, and parts are examples of: A) entities. B) attributes. C) cardinals. D) relationships.

entities.

The logical representation of an organization's data is called a(n): A) database model. B) entity-relationship model. C) relationship systems design. D) database entity diagram.

entity-relationship model.

A(n) ________ is the relationship between a weak entity type and its owner. A) member chain B) identifying relationship C) jump path D) chain link

identifying relationship

Business policies and rules govern all of the following EXCEPT: A) managing employees. B) creating data. C) updating data. D) removing data.

managing employees.

An entity type whose existence depends on another entity type is called a ________ entity. A) strong B) weak C) codependent D) variant

weak