IS 301 FINAL EXAM QUESTIONS WITH
100% CORRECT ANSWERS { GRADED
A+}
Normalization works through a series of stages called normal forms. T/F -
✔✔True
A determinant is any attribute whose value determines other values within a row.
T/F - ✔✔True
Repeating groups must be eliminated by making sure that each column defines a
single entity. T/F - ✔✔False
In order to meet performance requirements, you may have to denormalize portions
of the database design. T/F - ✔✔True
Denormalization produces a higher normal form. T/F - ✔✔False
,A dependency of one nonprime (non-key) attribute on another nonprime (non-key)
attribute is a partial dependency. T/F - ✔✔False
The combination of normalization and ER modeling yields a useful ERD, whose
entities may now be translated into appropriate relationship structures. T/F -
✔✔False
Dependencies that are based on only a part of a composite primary key are called
transitive dependencies. T/F - ✔✔False
With parrtial dependencies, data redundancies occur because every row entry
requires duplication of data. T/F - ✔✔True
It is possible for a table in 2NF to exhibit transitive dependency, where one or
more non-key attributes functionally determine other non-key attributes. T/F -
✔✔True
Attribute A ____ attribute B if all of the rows in the table that agree in value for
attribute A also agree in value for attribute B.
A) Determines
B) Controls
,C) Owns
D) Derives From - ✔✔A) Determines
A table that displays data redundancies yields ____.
a) Fewer attributes
b) more entities
c) more attributes
d) anomalies - ✔✔d) anomalies
If a table has multiple candidate keys and one of those candidate keys is a
composite key, the table can have ____ based on this composite candidate key,
even when the primary key chosen is a single attribute.
a) Boyce- Codd Normal Form
b) time-variance
c) partial dependencies
d) redundancy - ✔✔c) partial dependencies
, Data redundancy produces ____.
a) data integrity problems
b) efficient storage use
c) robust design
d) slower lookups - ✔✔a) data integrity problems
An attribute that is part of a key is known as a(n) ____ attribute.
a) important
b) nonprime
c)entity
d) prime - ✔✔d) prime
A table that is in 1NF, includes no partial dependencies, but may include transitive
dependencies is said to be in ____.
a) 2NF
100% CORRECT ANSWERS { GRADED
A+}
Normalization works through a series of stages called normal forms. T/F -
✔✔True
A determinant is any attribute whose value determines other values within a row.
T/F - ✔✔True
Repeating groups must be eliminated by making sure that each column defines a
single entity. T/F - ✔✔False
In order to meet performance requirements, you may have to denormalize portions
of the database design. T/F - ✔✔True
Denormalization produces a higher normal form. T/F - ✔✔False
,A dependency of one nonprime (non-key) attribute on another nonprime (non-key)
attribute is a partial dependency. T/F - ✔✔False
The combination of normalization and ER modeling yields a useful ERD, whose
entities may now be translated into appropriate relationship structures. T/F -
✔✔False
Dependencies that are based on only a part of a composite primary key are called
transitive dependencies. T/F - ✔✔False
With parrtial dependencies, data redundancies occur because every row entry
requires duplication of data. T/F - ✔✔True
It is possible for a table in 2NF to exhibit transitive dependency, where one or
more non-key attributes functionally determine other non-key attributes. T/F -
✔✔True
Attribute A ____ attribute B if all of the rows in the table that agree in value for
attribute A also agree in value for attribute B.
A) Determines
B) Controls
,C) Owns
D) Derives From - ✔✔A) Determines
A table that displays data redundancies yields ____.
a) Fewer attributes
b) more entities
c) more attributes
d) anomalies - ✔✔d) anomalies
If a table has multiple candidate keys and one of those candidate keys is a
composite key, the table can have ____ based on this composite candidate key,
even when the primary key chosen is a single attribute.
a) Boyce- Codd Normal Form
b) time-variance
c) partial dependencies
d) redundancy - ✔✔c) partial dependencies
, Data redundancy produces ____.
a) data integrity problems
b) efficient storage use
c) robust design
d) slower lookups - ✔✔a) data integrity problems
An attribute that is part of a key is known as a(n) ____ attribute.
a) important
b) nonprime
c)entity
d) prime - ✔✔d) prime
A table that is in 1NF, includes no partial dependencies, but may include transitive
dependencies is said to be in ____.
a) 2NF
