INSY 3304 Exam 1 questions with verified answers
________ data exist in a format that does not lend itself to processing that yields
information. Ans✓✓✓ Unstructured
_________ is the bottom-up process of identifying a higher-level, more generic
entity supertype from lower-level entity subtypes. Ans✓✓✓ Generalization
_________ provide a description of the data characteristics and the set of
relationships that link the data found within the database. Ans✓✓✓ Metadata
__________ data refer to data whose values change over time and for which one
must keep a history of the data changes. Ans✓✓✓ Time-variant
__________ expresses the minimum and maximum number of entity occurrences
associated with one occurrence of the related entity. Ans✓✓✓ Cardinality
___________ are especially useful when you are trying to determine what values
in related tables cause referential integrity problems. Ans✓✓✓ Outer joins
___________ relates to the activities that make the database execute
transactions more efficiently in terms of storage and access speed. Ans✓✓✓
Performance tuning
____________ databases reflect the ever-growing demand for greater scope and
depth in the data on which decision support systems increasingly rely. Ans✓✓✓
Data warehouse
, ________, a.k.a. RESTRICT, yields values for all rows found in a table that satisfy a
given condition. Ans✓✓✓ SELECT
A ____ is a collection of related records. Ans✓✓✓ file
A _______ is anything about which data are to be collected and stored. Ans✓✓✓
entity
A ________ is bidirectional. Ans✓✓✓ relationship
A _________ is the set of possible values for a given attribute. Ans✓✓✓ domain
A ______________ derives its name from the fact that a collection of multiple
entries of the same type can exist for any single key attribute occurrence.
Ans✓✓✓ repeating group
A data warehouse can store data derived from many sources. Ans✓✓✓ True
A desktop database is a ________ database. Ans✓✓✓ single-user
A noun in a business rules translates to an ______ in the data model. Ans✓✓✓
entity
A partial completeness constraint is represented by a ___________________.
Ans✓✓✓ a single horizonal line under a circle.
________ data exist in a format that does not lend itself to processing that yields
information. Ans✓✓✓ Unstructured
_________ is the bottom-up process of identifying a higher-level, more generic
entity supertype from lower-level entity subtypes. Ans✓✓✓ Generalization
_________ provide a description of the data characteristics and the set of
relationships that link the data found within the database. Ans✓✓✓ Metadata
__________ data refer to data whose values change over time and for which one
must keep a history of the data changes. Ans✓✓✓ Time-variant
__________ expresses the minimum and maximum number of entity occurrences
associated with one occurrence of the related entity. Ans✓✓✓ Cardinality
___________ are especially useful when you are trying to determine what values
in related tables cause referential integrity problems. Ans✓✓✓ Outer joins
___________ relates to the activities that make the database execute
transactions more efficiently in terms of storage and access speed. Ans✓✓✓
Performance tuning
____________ databases reflect the ever-growing demand for greater scope and
depth in the data on which decision support systems increasingly rely. Ans✓✓✓
Data warehouse
, ________, a.k.a. RESTRICT, yields values for all rows found in a table that satisfy a
given condition. Ans✓✓✓ SELECT
A ____ is a collection of related records. Ans✓✓✓ file
A _______ is anything about which data are to be collected and stored. Ans✓✓✓
entity
A ________ is bidirectional. Ans✓✓✓ relationship
A _________ is the set of possible values for a given attribute. Ans✓✓✓ domain
A ______________ derives its name from the fact that a collection of multiple
entries of the same type can exist for any single key attribute occurrence.
Ans✓✓✓ repeating group
A data warehouse can store data derived from many sources. Ans✓✓✓ True
A desktop database is a ________ database. Ans✓✓✓ single-user
A noun in a business rules translates to an ______ in the data model. Ans✓✓✓
entity
A partial completeness constraint is represented by a ___________________.
Ans✓✓✓ a single horizonal line under a circle.
