About us
Our services
Essay topics and ideas
Custom essay writing
Flashcards and Quizzes
Tools
Thesis statement generator
Alphabetizer
Conclusion Generator
Essay Rewriter
Free plagiarism checker
Paraphrasing Tool
Read My Essay
Log in
Sign up
Science
Computer Science
IT Quiz 4
Please enter something
FIND ESSAY
IT Quiz 4
Pembroke Jackson
24 July 2022
4.7
(114 reviews)
40 test answers
Unlock all answers in this set
Unlock answers
(36)
question
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
Haven't found what you need?
Search for quizzes and test answers now
Please enter something
Find answers
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy