Ch. 3 & 4

The _____ relationship should be rare in any relational database design.

1:1

The _____ relationship is the "relational model ideal."

1:M

In a natural join, the column on which the join was made occurs twice in the new table.

False

In implementation terms, an entity is existence-dependent if it has a mandatory primary key.

False

Only a single attribute, not multiple attributes, can define functional dependence.

False

Referential integrity and participation are both bidirectional, meaning that they must be addressed in both directions along a relationship.

False

The entity relationship model (ERM) is dependent on the database type.

False

The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.

False

Date attributes contain calendar dates stored in a special format known as the _____ date format.

Julian

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

M:N

The _____ constraint can be placed on a column to ensure that every row in the table has a value for that column.

NOT NULL

A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.

True

An entity in the entity relationship model corresponds to a table in the relational environment.

True

Connectivities and cardinalities are established by concise statements known as business rules.

True

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.

True

In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the entity's name.

True

The entity relationship diagram (ERD) represents the _____ database as viewed by the end user.

conceptual

The first step in building an entity-relationship diagram (ERD) is _____.

creating a detailed narrative of the organization's description of operations

A(n) _____ is the set of possible values for a given attribute.

domain

Knowing the minimum and maximum number of _____ occurrences is very helpful at the application software level.

entity

In organizations that generate large number of transactions, _____ are often a top priority in database design.

high processing speeds

In a database context, the word _____ indicates the use of the same attribute name to label different attributes.

homonym

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.

optional to

A _____ attribute is one that cannot be subdivided.

simple

When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.

symbols