MODERN DATABASE MANAGEMENT
FINAL PAPER FULL QUESTIONS AND
CORRECT ANSWERS DETAILED STUDY
SHEET
●● The relational data model consists of which components?
Answer: Data structure, Data manipulation, and Data integrity
●● A two-dimensional table of data is called a:
Answer: Relation
●● A component of the relational data model included to specify
business rules to maintain the integrity of data when they are
manipulated:
Answer: Data integrity
●● An attribute (or attributes) that uniquely identifies each row in a
relation is called a:
Answer: Primary key
●● An attribute in a relation of a database that serves as the primary key
of another relation in the same database is called a:
Answer: Foreign key
,●● A domain definition consists of the following components EXCEPT:
domain name
data type
integrity constraints
size
Answer: Integrity constraints
●● A rule that states that each foreign key value must match a primary
key value in the other relation is called the:
A. referential integrity constraint.
B. key match rule.
C. entity key group rule.
D. foreign/primary match rule
Answer: Referential integrity constraint
●● In the SQL language, the __________ statement is used to make
table definitions.
Answer: Create table
,●● A relation that contains minimal redundancy and allows easy use is
considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Answer: Well-structured
●● A nonkey attribute is also called a(n):
A) column.
B) unimportant datum.
C) descriptor.
D) address.
Answer: Descriptor
●● All of the following are that main goals of normalization EXCEPT:
A. minimize data redundancy.
B. simplify the enforcement of referential integrity.
C. maximize storage space.
, D. make it easier to maintain data.
Answer: Maximize storage space
●● When all multivalued attributes have been removed from a relation,
it is said to be in:
first normal form
second normal form
Boyce-Codd normal form
third normal form
Answer: First normal form
●● A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains transitive
dependencies is in which normal form?
Answer: Second
●● A constraint between two attributes is called a(n):
A) functional relation.
B) attribute dependency.
C) functional dependency.
D) functional relation constraint
FINAL PAPER FULL QUESTIONS AND
CORRECT ANSWERS DETAILED STUDY
SHEET
●● The relational data model consists of which components?
Answer: Data structure, Data manipulation, and Data integrity
●● A two-dimensional table of data is called a:
Answer: Relation
●● A component of the relational data model included to specify
business rules to maintain the integrity of data when they are
manipulated:
Answer: Data integrity
●● An attribute (or attributes) that uniquely identifies each row in a
relation is called a:
Answer: Primary key
●● An attribute in a relation of a database that serves as the primary key
of another relation in the same database is called a:
Answer: Foreign key
,●● A domain definition consists of the following components EXCEPT:
domain name
data type
integrity constraints
size
Answer: Integrity constraints
●● A rule that states that each foreign key value must match a primary
key value in the other relation is called the:
A. referential integrity constraint.
B. key match rule.
C. entity key group rule.
D. foreign/primary match rule
Answer: Referential integrity constraint
●● In the SQL language, the __________ statement is used to make
table definitions.
Answer: Create table
,●● A relation that contains minimal redundancy and allows easy use is
considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Answer: Well-structured
●● A nonkey attribute is also called a(n):
A) column.
B) unimportant datum.
C) descriptor.
D) address.
Answer: Descriptor
●● All of the following are that main goals of normalization EXCEPT:
A. minimize data redundancy.
B. simplify the enforcement of referential integrity.
C. maximize storage space.
, D. make it easier to maintain data.
Answer: Maximize storage space
●● When all multivalued attributes have been removed from a relation,
it is said to be in:
first normal form
second normal form
Boyce-Codd normal form
third normal form
Answer: First normal form
●● A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains transitive
dependencies is in which normal form?
Answer: Second
●● A constraint between two attributes is called a(n):
A) functional relation.
B) attribute dependency.
C) functional dependency.
D) functional relation constraint
