ch 4, 6 and 7

Suppose that Tiny College offers several courses; each course has several classes. It is possible for the department to create the entity COURSE first and then create the CLASS entity after making the teaching assignments. In this case, what cardinality will appear for CLASS in the ERD?

(0,1)

What cardinality is indicated by the Crow's Foot symbol that contains a line beside a crow's foot shape?

(1,N)

In the ERD, cardinality is indicated using the ________ format.

(min, max)

What is the ideal number of attributes used to make up a primary key?

1

The preferred way to represent multivalued attributes in a DBMS is to create a new entity composed of the original multivalued attribute's components in a(n) ________ relationship with the original entity.

1:M

A table that is in 2NF and contains no transitive dependencies is said to be in ________.

3NF

For most business database design purposes, ________ is as high as you need to go in the normalization process.

3NF

Most designers consider Boyce-Codd normal form (BCNF) as a special case of ________.

3NF

Which 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

Which ERD design activity comes first?

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

____ refers to the level of detail represented by the values stored in a table's row.

Granularity

Which of the following would be the best name for a column representing the charges per hour in a table named JOB?

JOB_CHG_HOUR

________ attributes are attributes that can have several values.

Multivalued

________ participation means that one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

Optional

When loading data into two entities with a 1:M relationship, how should the data be loaded?

The 1 side must be loaded first.

reserved words

Words used by a system that cannot be used for any other purpose. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.

Which of the following might be represented with a single-valued attribute?

a serial number

In a normalized database, what is represented by each table?

a single subject

A table that displays data redundancies yields ________.

anomalies

The normalization process involves assigning ________ to tables based on the concept of determination.

attributes

A ________ relationship exists when two entities are associated.

binary

Connectivities and cardinalities are established by very concise statements known as ________.

business rules

When a table contains only one ________ key, the 3NF and the BCNF are equivalent.

candidate

A ________ attribute is an attribute that can be further subdivided to yield additional attributes.

composite

A ________ identifier is a key that is composed of more than one attribute.

composite

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

composite

The bridge entity is also known as a ________ entity.

composite

A ________ key makes it more difficult to write search routines.

composite primary

The conflicts between design efficiency, information requirements, and performance are often resolved through ________.

compromises that may include denormalization

The entity relationship diagram is used to graphically represent the ________ database.

conceptual

How is a derived attribute indicated in the Chen model?

dashed line

Remember that the nature of the relationship is often determined by the ________, who must use professional judgment to determine which relationship type and strength best suit the database transaction, efficiency, and information requirements.

database designer

A database design must conform to ________ standards.

design

A ________ is any attribute whose value determines other values within a row.

determinant

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

domain

A relationship is an association between ________.

entities

In an ERD, the focus is on the ________ and the relationships between them.

entities

The existence of 1:1 relationships often indicates a misidentification of attributes as ________.

entities

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

existence

If an entity's existence depends on the existence of one or more other entities it is said to be ________-dependent.

existence

The process of database design is ________.

iterative

When designing a database you should ________.

make sure entities are in normal form before table structures are created.

Knowing the ________ number of entity occurrences is very useful at the application software level.

maximum and minimum

The database may have to sacrifice some of its "clean" design structures and/or some of its high transaction speed to ensure ________.

maximum information generation

What type of attribute should not be implemented in a RDBMS?

multivalued

A derived attribute ________.

need not be physically stored within the database

Identification of the ________ will let you know where you are in the normalization process.

normal form

If no ________ symbol is depicted with an entity, the entity exists in a mandatory relationship with the related entity.

optionality

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

optionality

Dependencies based on only a part of a composite primary key are called ________ dependencies.

partial

Which of the following should be a derived attribute?

person's age

Which of the following might be represented with a multivalued attribute?

person's educational background

A ________ relationship is one in which a relationship can exist between occurrences of the same entity set.

recursive

A ________ attribute is an attribute that cannot be subdivided.

simple

A ________ attribute is an attribute that can have only one value.

single-valued

In the Crow's Foot model, the composite entity is identified by the ___ relationship line between the parent and child entities.

solid

The Crow's Foot model depicts the strong (identifying) relationship with a ________ line between the entities.

solid

Another word for an existence-independent entity is a ________ entity.

strong

A ________ relationship exists when three entities are associated.

ternary

Cardinality expresses ________ number of entity occurrences associated with one occurrence of the related entity.

the minimum and maximum

A 2NF table can exhibit ________ dependency.

transitive

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

unary

In an ER diagram identifiers are indicated by ________.

underlining

Unnormalized tables yield no simple strategies for creating virtual tables, which are also known as ________.

views

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

weak

A(n) ________ entity is existence-dependent.

weak

A(n) ________ relationship is also known as a non-identifying relationship

weak

When the PK of a related entity does not contain a PK component of the parent entity, the relationship is ________.

weak