IT Quiz 4
Making sure all ____ are identified is a very important part of a database designer's job.
Business Rules
The ____ 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
A ____ attribute can be further subdivided to yield additional attributes.
Composite
A ____ identifier is composed of more than one attribute.
Composite
The associative entity is also known as a ____ entity.
Composite
Some ____ database modeling concepts can be expressed only using the Chen notation.
Conceptual
The ERD represents the ____ database as viewed by the end user.
Conceptual
The step, ____, occurs first in the process of building an ERD.
Create a detailed narrative of the organization's description of operations
A derived attribute is indicated in the Chen model by a ____.
Dashed Line
Attributes may share a ____.
Domain
The set of possible values for an attribute is a ____.
Domain
A relationship is an association between ____
Entities
An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
Existence
Knowing the ____ number of entity occurrences is very helpful at the application software level.
Maximum and Minimum
In the ERD, cardinality is indicated using the ____ notation.
Min,Max
The ____ type of attribute cannot be created in a DBMS.
Multivalued
____ attributes can have many values.
Multivalued
A ____ attribute is one that cannot be subdivided.
Simple
Some attributes are classified as ____.
Simple
A ____ attribute can have only one value.
Single-Valued
Another word for existence-independent is ____.
Strong
A ____ relationship exists when three entities are associated.
Ternary
A ____ relationship exists when an association is maintained within a single entity.
Unary
In an ER diagram, primary keys are indicated by ____.
Underlining
A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Weak
When the PK of one entity does not contain the PK of a related entity, the relationship is ____.
Weak
The Crow's foot symbol with two parallel lines indicates ____ cardinality.
1,1
A(n) ____ entity is composed of the primary keys of each of the entities to be connected.
Associative
A ____ relationship exists when two entities are associated.
Binary
____ relationships are most common.
Binary
If an entity can exist apart from one or more related entities, it is said to be ____-independent.
Existence
____ might be represented with a multivalued attribute.
Household Phone Numbers
Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.
Information
The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.
Mandatory
A derived attribute ____.
Need not be physically stored within the database
Ideally, an entity identifier is composed of ____ attribute(s).
One
The term "____" is used to label any condition in which one or more optional relationships exist.
Optionality
A ____ should be a derived attribute.
Person's Age
A(n) ____ might be represented with a single-valued attribute.
Person's Social Security Number
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.
Recursive
