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