Concepts of Database Management Chapter 5 Questions with Correct Answers Fully Solved Latest
2025
Alternate key - Answers A candidate key that was not chosen to be the primary key
Boyce-Codd normal form (BCNF) - Answers A relation is in Boyce-Codd normal form if it is in second
normal form and the only determinants it contains are candidate keys.
Candidate key - Answers A minimal collection of columns (attributes) in a table on which all columns are
functionally dependent but that has not necessarily been chosen as the primary key.
Concatenation - Answers The combination of two or more rows in
an operation, such as a join, or the combination of two or more columns for a primary key field to
uniquely identify a given row in the table.
Dependency diagram - Answers A diagram that indicates the dependencies among the columns in a
table.
Determinant - Answers A column in a table that determines at least one other column.
First normal form (1NF) - Answers A table is in first normal form if it does not contain a repeating group.
Fourth normal form (4NF) - Answers A table is in fourth normal form if it is in third normal form and
there are no multivalued dependencies.
Functional dependence - Answers Column B is functionally dependent on column A (or on a collection of
columns) if a value for A determines a single value for B at any one time.
Functionally dependent - Answers Column B is functionally dependent on column A (or on a collection of
columns) if a value for A determines a single value for B at any one time.
Functionally determines - Answers Column A functionally determines column B if B is functionally
dependent on A.
Interrelation constraint - Answers A constraint that involves more than one relation.
Multidependent - Answers In a table with columns A, B, and C, B is multidependent on A if each value
for A is associated with a specific collection of values for B and, further, this collection is independent of
any values for C.
Multidetermine - Answers In a table with columns A, B, and C, A multidetermines B if each value for A is
associated with a specific collection of values for B and, further, this collection is independent of any
values for C.
2025
Alternate key - Answers A candidate key that was not chosen to be the primary key
Boyce-Codd normal form (BCNF) - Answers A relation is in Boyce-Codd normal form if it is in second
normal form and the only determinants it contains are candidate keys.
Candidate key - Answers A minimal collection of columns (attributes) in a table on which all columns are
functionally dependent but that has not necessarily been chosen as the primary key.
Concatenation - Answers The combination of two or more rows in
an operation, such as a join, or the combination of two or more columns for a primary key field to
uniquely identify a given row in the table.
Dependency diagram - Answers A diagram that indicates the dependencies among the columns in a
table.
Determinant - Answers A column in a table that determines at least one other column.
First normal form (1NF) - Answers A table is in first normal form if it does not contain a repeating group.
Fourth normal form (4NF) - Answers A table is in fourth normal form if it is in third normal form and
there are no multivalued dependencies.
Functional dependence - Answers Column B is functionally dependent on column A (or on a collection of
columns) if a value for A determines a single value for B at any one time.
Functionally dependent - Answers Column B is functionally dependent on column A (or on a collection of
columns) if a value for A determines a single value for B at any one time.
Functionally determines - Answers Column A functionally determines column B if B is functionally
dependent on A.
Interrelation constraint - Answers A constraint that involves more than one relation.
Multidependent - Answers In a table with columns A, B, and C, B is multidependent on A if each value
for A is associated with a specific collection of values for B and, further, this collection is independent of
any values for C.
Multidetermine - Answers In a table with columns A, B, and C, A multidetermines B if each value for A is
associated with a specific collection of values for B and, further, this collection is independent of any
values for C.
