C175 Data Management Foundations || 100% Accurate Answers.
alternate key correct answers uniquely identifies each entity in a collection of entities but is not
the primary key
candidate key correct answers set of columns in a table that can uniquely identify any record in
that table without referring to other data
copied to index correct answers what happens to original data in database indexing
DBMS increases effectiveness by correct answers enabling data sharing, permitting storage of
vast volumes of data
affinity grouping occurs correct answers btwn objects
loading correct answers monitor refreshing volume and frequency
referential integrity correct answers reference to data in one relation is based on values in another
relation
first normal form correct answers no repeating groups, every row should be unique
second normal form correct answers no partial key dependencies
unary relationship correct answers An occurrence where one entity type is associated with the
same entity type
Ex: Employees may have trainers, who are also employees, so the EMPLOYEE entity would be
associated with itself
, 1-1 unary relationship correct answers A type of unary relationship where each entity inside the
set is associated with only one other entity inside the set
Ex: Each employee is assigned a sponsor when he is hired. Each sponsor only sponsors one
employee
1-M unary relationship correct answers A type of unary relationship where one entity in the set
can be associated with multiple other entities in the set
Ex: A manager is en employee, but he manages several other employees
M-M unary relationship correct answers A type of unary relationship where many of an entity are
directly associated with many of the same entity
Ex: Many parts of a product are contained by many other parts of the product
third normal form correct answers removes transitive dependencies
three referential integrity control mechanisms provided by modern DBMS correct answers
Delete Rules, Insert Rules, and Update Rules
three different rules inside the delete rule correct answers Restrict, Cascade, and Set-to-Null
foreign key correct answers a column that creates a relationship between two tables, purpose is to
maintain data integrity and allow navigation btwn two different instances of an entity
heap file correct answers An unsorted set of records.
intersection data correct answers describes the relationship between the two entities
alternate key correct answers uniquely identifies each entity in a collection of entities but is not
the primary key
candidate key correct answers set of columns in a table that can uniquely identify any record in
that table without referring to other data
copied to index correct answers what happens to original data in database indexing
DBMS increases effectiveness by correct answers enabling data sharing, permitting storage of
vast volumes of data
affinity grouping occurs correct answers btwn objects
loading correct answers monitor refreshing volume and frequency
referential integrity correct answers reference to data in one relation is based on values in another
relation
first normal form correct answers no repeating groups, every row should be unique
second normal form correct answers no partial key dependencies
unary relationship correct answers An occurrence where one entity type is associated with the
same entity type
Ex: Employees may have trainers, who are also employees, so the EMPLOYEE entity would be
associated with itself
, 1-1 unary relationship correct answers A type of unary relationship where each entity inside the
set is associated with only one other entity inside the set
Ex: Each employee is assigned a sponsor when he is hired. Each sponsor only sponsors one
employee
1-M unary relationship correct answers A type of unary relationship where one entity in the set
can be associated with multiple other entities in the set
Ex: A manager is en employee, but he manages several other employees
M-M unary relationship correct answers A type of unary relationship where many of an entity are
directly associated with many of the same entity
Ex: Many parts of a product are contained by many other parts of the product
third normal form correct answers removes transitive dependencies
three referential integrity control mechanisms provided by modern DBMS correct answers
Delete Rules, Insert Rules, and Update Rules
three different rules inside the delete rule correct answers Restrict, Cascade, and Set-to-Null
foreign key correct answers a column that creates a relationship between two tables, purpose is to
maintain data integrity and allow navigation btwn two different instances of an entity
heap file correct answers An unsorted set of records.
intersection data correct answers describes the relationship between the two entities
