65.
Business intelligence is a component of the overall framework or field of
analytics.
66.
Databases and DBMSs are the technology tools that directly support OLAP.
67.
When you build a data warehouse and use data-mining tools to manipulate
the data warehouse’s information, you are actively engaging in analytics.
68.
The most popular database model is the hierarchical database model.
69.
A relational database model uses a series of physically related two-
dimensional tables or files to store information in the form of a database.
70.
When you create a database, you first create its data dictionary.
71.
A foreign key is also a primary key.
72.
A primary key from one file and a foreign key from another file are used to
create a relationship between two files in a relational database.
73.
You can create logical ties among various files only in the absence of
foreign keys.
74.
If a salesperson attempts to order merchandise for a customer who should
but does not exist in the customer database, the database will typically
generate an error message. This message indicates that an integrity
constraint has been violated.
75.
The physical view of information focuses on how you as a knowledge
worker need to arrange and access information to meet your particular
business needs.
76.
There is only one logical view of information but there may be numerous
knowledge workers who have different physical views of the information in
a database.
77.
The DBMS engine can process virtually any logical information view or
request into its physical equivalent.
78.
When you create a database, you must first use the data definition
subsystem to create the data dictionary and define the structure of the
files.
79.
A report generator allows you to see the contents of a database file, make
whatever changes you want, perform simple sorting, and query to find the
location of specific information.
80.
QBEs rely heavily on the physical relationships within a database to find
information.
81.
Unlike SQL, QBE allows you to query by pointing, clicking, and dragging.
82.
Application generation facilities are most often used by operations
personnel.
83.
Recovery is the process of reinstalling the backup information in the event
the information was lost.
85.
Data warehouses do not support transaction processing.
86.
Orco Corp. would like to determine advertising strategies for customers who
buy high-priced products. It would use OLTP on its data warehouse to
accomplish this task.
87.
Query-and-reporting tools are similar to QBE tools, SQL, and report
generators in the typical database environment.
88.
Multidimensional analysis (MDA) tools are slice-and-dice techniques that
allow you to view multidimensional information from different perspectives.
89.
The digital dashboard is designed uniquely for each individual user.
90.
Data marts focus on the entire organization, while data warehouses focus
on specific needs.
91.
The CSO is responsible for ensuring that only the right people have access
to certain types of information such as financial records, payroll, and health
care.
92.
Data administration is the function in an organization that is responsible for
the more technical and operational aspects of managing the information
contained in organizational information repositories.