Chapter 4

Tiny College offers several courses and each course has several classes. If it is possible for a department to create the COURSE entity first and then create the CLASS entity after making the teaching assignments, which of the following cardinalities will appear for CLASS in the ERD? a. (1,N) b. (0,1) c. (0,N) d. (1,1)

(0,N)

In an entity relationship diagram (ERD), cardinality is indicated using the ________ format. a. {min|max} b. (max, min) c. [min ... max] d. (min, max)

(min,max)

Which of the following is most likely to be represented with a single-valued attribute? a. Person's Social Security number b. Household contact information c. Employee's educational background d. Car's color

A Person's Social Security Number

A(n) ________ is composed of the primary keys of each of the entities to be connected. a. binary entity b. associative entity c. unary entity d. composite entity

Associative Entity

A ________ exists when two entities are associated. a. non-identifying relationship b. higher-order relationship c. ternary relationship d. binary relationship

Binary Relationship

Connectivities and cardinalities are established by concise statements known as ________. a. relationships b. business rules c. relational schema d. assertions

Business Rules

Which of the following attributes makes up the primary key in the table definition CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)? a. CRS_CODE b. CLASS_SECTION c. PROF_NUM d. CLASS_ROOM e. CLASS_TIME

CRS_CODE

The term ________ is used to label any condition in which one entity occurrence does not require a corresponding entity occurrence in a particular relationship. a. connectivity b. participation c. cardinality d. optionality

Cardinality

A bridge entity is also known as a ________ entity. a. composite b. recurring c. strong d. weak

Composite

A ________ is a key that is composed of more than one attribute. a. domain identifier b. unique identifier c. composite identifier d. entity identifier

Composite Identifier

An attribute that can be further subdivided to yield additional attributes is known as ________. a. multivalued attribute b. composite attribute c. single-valued attribute d. simple attribute

Composite attribute

The term ________ is used to describe the relationship classification. a. relationship participation b. cardinality c. relationship degree d. connectivity

Connectivity

As an important part of the job, a ________ is responsible to make sure that all appropriate business rules are identified. a. database designer b. database administrator c. end user d. system analyst

DatabaseDesigner

________ helps designers keep track during the design process and pick up the design thread when the time comes to modify the design. a. Conceptualization b. Implementation c. Abstraction d. Documentation

Documentation

The set of possible values for an attribute is known as a ________. a. group b. domain c. set d. range

Domain

________ are underlined in an entity relationship (ER) diagram. a. Relationship degrees b. Business rules c. Identifiers d. Domains

Identifiers

The process of database design is ________. a. linear b. optional c. iterative d. sequential

Iterative

Which of the following types of attribute should not be implemented in an RDBMS? a. Composite attribute b. Derived attribute c. Simple attribute d. Multivalued attribute

Multivalued Attribute

A car's color is an example of a ________. a. multivalued attribute b. derived attribute c. single-valued attribute d. simple attribute

Multivalued attribute

________ means that one entity occurrence does not require a corresponding entity occurrence in a particular relationship. a. Indirect participation b. Dependent participation c. Optional participation d. Required participation

Optional Participation

Which of the following is an example of a derived attribute? a. Person's phone number b. Person's name c. Person's social security number d. Person's age

Person's Age

Which of the following is most likely to be represented with a multivalued attribute? a. Book title b. Person's name c. Bank account balance d. Person's educational background

Person's Educational background

A ________ is one in which a relationship can exist between occurrences of the same entity set. a. composite relationship b. recursive relationship c. mandatory relationship d. dependent relationship

Recursive Relationship

A ________ can exist apart from one or more related entities a. weak entity b. regular entity c. associative entity d. defined entity

Regular Entity

The concept of ________ is based on how the primary key of a related entity is defined. a. relationship degree b. relationship strength c. entity composition d. business rules

Relationship Strength

A ________ cannot be subdivided. a. single-valued attribute b. simple attribute c. defined attribute d. complex attribute

Simple Attribute

A manufactured part's serial number is an example of a ________. a. optional attribute b. derived attribute c. single-valued attribute d. simple attribute

Single-valued attribute

Existence-independent entities are also known as ________. a. strong entities b. weak entities c. higher-order entities d. solitary entities

Strong Entities

A ________ exists when three entities are associated. a. identifying relationship b. unary relationship c. ternary relationship d. optional relationship

Ternary Relationship

In the Chen notation, ________. a. multivalued attributes are shown by a solid line connecting an attribute to an entity b. the implementation-oriented approach is favored c. the database representation consumes lesser space than the Crow's Foot notation d. the cardinalities are placed on the side of the related entity

The implementation-oriented approach is favored

A ________ exists when an association is maintained within a single entity. a. weak relationship b. unary relationship c. optional relationship d. identifying relationship

Unary relationship

When the primary key of a related entity does not contain a primary key component of the parent entity, the relationship is ________. a. unary b. missing c. strong d. weak

Weak

A ________ has a primary key that is partially or totally derived from the parent entity in the relationship. a. composite entity b. strong entity c. business entity d. weak entity

Weak Entity

A(n) ________ is existence-dependent. a. related entity b. strong entity c. undefined entity d. weak entity

Weak Entity

A(n) ________ is also known as a non-identifying relationship. a. indirect relationship b. strong relationship c. direct relationship d. weak relationship

Weak Relationship

________ often indicates a misidentification of attributes as entities in an ERD. a. The existence of 1:1 relationships b. The mapping of a M:N relationship to a set of 1:M relationships c. The presence of composite keys d. The placement of cardinalities on the side of a related entity

a. The existence of 1:1 relationships

In the Crow's Foot modeling notation, ________. a. cardinalities are placed next to the entity to which they apply b. associative entities are identified as weak relationships c. specific cardinalities and numeric cardinality range are depicted on the entity relationship diagram d. weak relationships are depicted by placing a solid relationship line between the entities

a. cardinalities are placed next to the entity to which they apply

To maximize information generation, database should ________. a. sacrifice some of its "clean" design structures b. maximize the number of logically desirable relationships c. use a design that places emphasis on higher transaction speed d. reduce the number of derived attributes

a. sacrifice some of its "clean" design structures

Which of the following is the first step in building an ERD? a. Identify the attributes and primary keys that adequately describe the entities. b. Create a detailed narrative of the organization's description of operations. c. Develop the initial ERD based on the main entities and relationships. d. Identify the business rules based on the description of operations.

b. Create a detailed narrative of the organization's description of operations.

In the Crow's Foot notation, ________. a. specific cardinalities are depicted on the ER diagram b. an associative entity is identified as a strong relationship c. both single-valued and multivalued attributes are identified d. conceptual modeling is favored over an implementation-oriented approach

b. an associative entity is identified as a strong relationship

The preferred way to represent multivalued attributes in a DBMS is to ________. a. create a single attribute in the original entity for the most recent value of the original multivalued attribute b. create several new attributes for each component of the original multivalued attribute c. create a new entity composed of the original multivalued attribute's components d. create a new entity in an M:1 relationship with the original entity

b. create several new attributes for each component of the original multivalued attribute

The Crow's Foot model depicts the strong (identifying) relationship with a ________. a. double line between the entities b. solid line between the entities c. circle on the relationship line d. hash mark across the relationship line

b. solid line between the entities

The best design process produces an ERD that: a. depends on derived attributes to reduce access time. b. possesses the highest processing speed possible. c. is flexible to meet the demands of adjustment and growth. d. combines two tables to avoid the use of an additional relationship.

c. is flexible to meet the demands of adjustment and growth.

Which of the following is true of a derived attribute? a. It must be based on the value of three or more attributes. b. It decreases data access time when it is not stored. c. It always yields historic values. d. It need not be physically stored within a database.

d. It need not be physically stored within a database.

A weak entity is one that ________. a. has a foreign key attribute that can be null b. inherits a part of its primary key from its counterpart in a relationship c. can exist without the entity with which it has a relationship d. has a primary key that is not derived from the parent entity in a relationship

d. has a primary key that is not derived from the parent entity in a relationship

An entity is assumed to exist in a mandatory relationship with a related entity if ________. a. the relationship is an identifying relationship b. no optionality symbol is depicted with the entity c. the relationship is a weak relationship d. the minimum cardinality is 0 for the mandatory entity

no optionality symbol is depicted with the entity

Which of the following cardinalities is indicated by the Crow's Foot symbol that contains a line beside a crow's foot shape? a. (1,N) b. (0,1) c. (0,N) d. (1,1)

(1,N)

An attribute that can be left empty is known as ________. a. single-valued attribute b. derived attribute c. composite attribute d. optional attribute

Optional Attribute

The inclusion of derived attributes in a database design ________. a. saves CPU processing cycles b. reduces coding complexity c. always yields current value d. increases data-retrieval speed

a. saves CPU processing cycles

Cardinality expresses ________. a. the maximum and minimum number of entities or participants associated with a relationship b. the classification of relationships as one-to-one, one-to-many, or many-to-many c. the existence of a database only when it is associated with another related entity occurrence d. the minimum and maximum number of entity occurrences associated with one occurrence of the related entity

d. the minimum and maximum number of entity occurrences associated with one occurrence of the related entity