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