Chapter 5 MT
Microsoft Access uses ________ to conduct queries.
QBE
A ________ relationship exists when three entities are associated.
Ternary
Databases ________ inconsistency; this means ________.
minimize; various copies of the data do not agree
Database systems minimize ________.
redundancy
Microsoft ________ is a popular example of a relational database.
Access
A ________ relationship exists when two entities are associated.
Binary
________ is an approach to managing information across an entire organization.
Data governance
________ is an example of a source system for a data warehouse.
ERP
Suppose you work for XYZ Corporation. You know you can contribute 6% of your salary to a 401K and the company will match that 100% after 6 years of service because it is in the employee handbook. This is an example of ________.
Explicit Knowledge
________ deals with more objective, rational, and technical knowledge.
Explicit Knowledge
________ is an intellectual asset.
Knowledge
________ are a set of core data that span the enterprise information systems.
Master Data
________ is a process that spans all organizational business processes and applications.
Master data management
Data marts and data warehouses typically use ________.
OLAP
________ is the most popular query language used for interacting with a database.
SQL
Suppose you are a salesperson. You take great pride in knowing each customers' favorite places to eat and their favorite meals. This is an example of ________.
Tactic Knowledge
________ is the cumulative store of subjective or experiential learning.
Tactic Knowledge
A ________ represents the smallest unit of data a computer can process.
a) bit
Your name in your university's database is a(n) ________.
attribute
Which of the following is an accurate representation of the data hierarchy from smallest to largest?
bit, byte, field, record, file, database
A ________ is a group of eight ________.
byte; bits
Functional dependencies are similar to ________ keys.
foreign
The ________ creates links between two tables.
foreign
Database systems minimize ________.
inconsistency
Database systems maximize ________.
independence
A(n) ________ of an entity refers to each row in a relational table, which is a specific, unique representation of the entity.
instance
Intellectual capital is another term for ________.
knowledge
Databases ________ redundancy; this means ________.
minimize; the same data are stored in multiple locations
Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance.
minimum; maximum
Data marts and data warehouses are ________; this means they ________ be updated by users.
non volatile;cannot
The ________ key is an identifier field that uniquely identifies a record.
primary
A ________ generally describes an entity.
record
Each relational database table contains records (listed in _______) and attributes (listed in ______) .
rows; columns
The ________ key has some identifying information but does not identify the record with complete accuracy.
secondary
The relational database model is based on the concept of ________-dimensional tables.
two
Knowledge management is a process that helps organizations manipulate important knowledge that comprises part of the organization's memory, usually in a(n) ________ format.
unstructured