For Expert help and assignment handling,
1
C170 Data Management Applications
Questions and Answers (100% Correct
Answers) Already Graded A+
access planAns: A set of instructions generated at application
compilation time that is created and managed by a DBMS. The access
plan predetermines how an application's query will access the database
at run time.
© 2026 Assignment Expert
algorithmsAns: A process or set of operations in a calculation.
Guru01 - Stuvia
aliasAns: An alternative name for a column or table in a SQL statement.
ALTER TABLEAns: The SQL command used to make changes to table
structure. When the command is followed by a keyword (ADD or
MODIFY), it adds a column or changes column characteristics.
ANDAns: The SQL logical operator used to link multiple conditional
expressions in a WHERE or HAVING clause. It requires that all conditional
expressions evaluate to true.
AREAAns: In DB2, a named section of permanent storage space that is
reserved to store the database.
associative entityAns: An entity designed to transform an M:N
relationship into two 1:M relationships. The composite entity's primary key
comprises at least the primary keys of the entities that it connects. Also
known as a bridge entity or associative entity. See also linking table.
,For Expert help and assignment handling,
2
atomic attributeAns: An attribute that cannot be further subdivided to
produce meaningful components. For example, a person's last name
attribute cannot be meaningfully subdivided.
atomicityAns: The transaction property that requires all parts of a
transaction to be treated as a single, indivisible, logical unit of work. All
parts of a transaction must be completed or the entire transaction is
aborted.
authenticationAns: The process through which a DBMS verifies that only
© 2026 Assignment Expert
registered users can access the database.
automatic query optimizationAns: A method by which a DBMS finds the
Guru01 - Stuvia
most efficient access path for the execution of a query.
AVGAns: A SQL aggregate function that outputs the mean average for
a specified column or expression.
B-tree indexAns: An ordered data structure organized as an upside-
down tree.
base tablesAns: The table on which a view is based.
batch update routineAns: A routine that pools transactions into a single
group to update a master table in a single operation.
BETWEENAns: In SQL, a special comparison operator used to check
whether a value is within a range of specified values.
binary relationshipAns: An ER term for an association (relationship)
between two entities. For example, PROFESSOR teaches CLASS.
, For Expert help and assignment handling,
3
bitmap indexAns: An index that uses a bit array (0s and 1s) to represent
the existence of a value or condition.
Boolean algebraAns: A branch of mathematics that uses the logical
operators OR, AND, and NOT.
Boyce-Codd normal form (BCNF)Ans: A special type of third normal form
(3NF) in which every determinant is a candidate key. A table in BCNF
must be in 3NF. See also determinant.
© 2026 Assignment Expert
bridge entityAns: An entity designed to transform an M:N relationship into
two 1:M relationships. The composite entity's primary key comprises at
least the primary keys of the entities that it connects.
Guru01 - Stuvia
buffer cacheAns: A shared, reserved memory area that stores the most
recently accessed data blocks in RAM. AKA data cache
candidate keyAns: A minimal superkey; that is, a key that does not
contain a subset of attributes that is itself a superkey. See key.
cardinalityAns: A property that assigns a specific value to connectivity
and expresses the range of allowed entity occurrences associated with
a single occurrence of the related entity.
cascading order sequenceAns: A nested ordering sequence for a set of
rows, such as a list in which all last names are alphabetically ordered
and, within the last names, all first names are ordered.
closureAns: A property of relational operators that permits the use of
relational algebra operators on existing tables (relations) to produce
new relations.
1
C170 Data Management Applications
Questions and Answers (100% Correct
Answers) Already Graded A+
access planAns: A set of instructions generated at application
compilation time that is created and managed by a DBMS. The access
plan predetermines how an application's query will access the database
at run time.
© 2026 Assignment Expert
algorithmsAns: A process or set of operations in a calculation.
Guru01 - Stuvia
aliasAns: An alternative name for a column or table in a SQL statement.
ALTER TABLEAns: The SQL command used to make changes to table
structure. When the command is followed by a keyword (ADD or
MODIFY), it adds a column or changes column characteristics.
ANDAns: The SQL logical operator used to link multiple conditional
expressions in a WHERE or HAVING clause. It requires that all conditional
expressions evaluate to true.
AREAAns: In DB2, a named section of permanent storage space that is
reserved to store the database.
associative entityAns: An entity designed to transform an M:N
relationship into two 1:M relationships. The composite entity's primary key
comprises at least the primary keys of the entities that it connects. Also
known as a bridge entity or associative entity. See also linking table.
,For Expert help and assignment handling,
2
atomic attributeAns: An attribute that cannot be further subdivided to
produce meaningful components. For example, a person's last name
attribute cannot be meaningfully subdivided.
atomicityAns: The transaction property that requires all parts of a
transaction to be treated as a single, indivisible, logical unit of work. All
parts of a transaction must be completed or the entire transaction is
aborted.
authenticationAns: The process through which a DBMS verifies that only
© 2026 Assignment Expert
registered users can access the database.
automatic query optimizationAns: A method by which a DBMS finds the
Guru01 - Stuvia
most efficient access path for the execution of a query.
AVGAns: A SQL aggregate function that outputs the mean average for
a specified column or expression.
B-tree indexAns: An ordered data structure organized as an upside-
down tree.
base tablesAns: The table on which a view is based.
batch update routineAns: A routine that pools transactions into a single
group to update a master table in a single operation.
BETWEENAns: In SQL, a special comparison operator used to check
whether a value is within a range of specified values.
binary relationshipAns: An ER term for an association (relationship)
between two entities. For example, PROFESSOR teaches CLASS.
, For Expert help and assignment handling,
3
bitmap indexAns: An index that uses a bit array (0s and 1s) to represent
the existence of a value or condition.
Boolean algebraAns: A branch of mathematics that uses the logical
operators OR, AND, and NOT.
Boyce-Codd normal form (BCNF)Ans: A special type of third normal form
(3NF) in which every determinant is a candidate key. A table in BCNF
must be in 3NF. See also determinant.
© 2026 Assignment Expert
bridge entityAns: An entity designed to transform an M:N relationship into
two 1:M relationships. The composite entity's primary key comprises at
least the primary keys of the entities that it connects.
Guru01 - Stuvia
buffer cacheAns: A shared, reserved memory area that stores the most
recently accessed data blocks in RAM. AKA data cache
candidate keyAns: A minimal superkey; that is, a key that does not
contain a subset of attributes that is itself a superkey. See key.
cardinalityAns: A property that assigns a specific value to connectivity
and expresses the range of allowed entity occurrences associated with
a single occurrence of the related entity.
cascading order sequenceAns: A nested ordering sequence for a set of
rows, such as a list in which all last names are alphabetically ordered
and, within the last names, all first names are ordered.
closureAns: A property of relational operators that permits the use of
relational algebra operators on existing tables (relations) to produce
new relations.
