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