DRM chap2

business rule

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

identifying relationship

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

composite

An attribute that can be broken down into smaller parts is called a(n) ________ attribute. Question options: A) simple B) complex C) associative D) composite

associative entity.

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n): Question options: A) gateway entity. B) build entity. C) associative entity. D) smush entity.

A department can have more than one employee.

For the relationship represented in the figure below, which of the following is true? Question options: A) An employee can work in more than one department but does not have to work for any department. B) An employee has to work for more than one department. C) A department must have at least one employee. D) A department can have more than one employee.

two

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

Years_Employed

In the figure below, which attribute is derived? A) Employee_ID B) Address C) Years_Employed D) Skill

a strong entity and its associated weak entity.

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

entity-relationship model.

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

strong entities

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

cardinality constraint

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. Question options: A) limit B) cardinality constraint C) degree D) counter constraint

attribute

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

Unary

A relationship between the instances of a single entity type is called a ________ relationship. A) ternary B) unary C) primary D) binary

many-to-many

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. Question options: A) one-to-one B) strong C) one-to-many D) many-to-many

time stamp.

A value that indicates the date or time of a data value is called a: Question options: A) check counter. B) value stamp. C) checkpoint. D) time stamp

weak

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

Skill

In the figure below, which attribute is multivalued? A) Years_Employed B) Employee_ID C) Skill D) Address

degree

The number of entity types that participate in a relationship is called the: Question options: A) counter. B) identifying characteristic. C) degree. D) number.

derived

The total quiz points for a student for an entire semester is a(n) ________ attribute. Question options: A) mixed B) addressed C) stored D) derived

Relates to a technical characteristic of the system

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