Quiz4 Flashcards
An ERD is created through which of the following processes?
a.
prescriptive
b.
iterative
c.
random
d.
conclusive
b.
iterative
Any attribute whose value determines other values within a row is known as a(n) _____.
a.
entity
b.
primary key
c.
surrogate
d.
determinant
d.
determinant
From a structural point of view, 3NF is better than _____.
a.
2NF
b.
3NF
c.
5NF
d.
6N
a.
2NF
In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.
a.
Chen
b.
dependency
c.
functionality
d.
ER
b.
dependency
In order for you to yield a useful ERD, you must combine ER modeling with which of the following entities?
a.
design process
b.
denormalization
c.
granularity
d.
normalization
d.
normalization
Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.
a.
two
b.
three
c.
four
d.
five
b.
three
Raw data in its original state that has data anomalies such as redundant or multivalued data is _____ data.
a.
consistent
b.
normalized
c.
unnormalized
d.
relational
c.
unnormalized
Unnormalized tables yield no simple strategies for creating virtual tables known as _____.
a.
views
b.
attributes
c.
entities
d.
keys
a.
views
What type of dependency is shown during normalization, if the conversion to the second normal form involves removing all attributes dependent on only a part of a composite primary key?
a.
functional dependency
b.
transitive dependency
c.
partial dependency
d.
primary key dependency
c.
partial dependency
According to a standard data-modeling checklist, the non-key entities in an entity-relationship (ER) data model must be fully dependent on _____.
a.
passive verbs
b.
the entity instance
c.
the primary key
d.
constraints
c.
the primary key
In exchange for possible reductions in performance, what unwanted element does normalization reduce?
a.
reporting requirements
b.
business rules
c.
functional dependencies
d.
data redundancies
d.
data redundancies
The main goal of normalization is to eliminate _____. .
a.
dependencies
b.
data anomalies
c.
repeating group
d.
non-key attribute
b.
data anomalies
Dependency diagrams are very helpful in getting a bird’s-eye view of all the relationships among a table’s attributes.
True
False
True
In the context of partial dependencies, data redundancies occur because every row entry requires the duplication of data.
True
False
True
What does normalization help you do?
a.
organize tables
b.
reduce redundancy
c.
improve integrity
d.
accomplish all of these goals
d.
accomplish all of these goals