Information Technology Reference
In-Depth Information
10. The commands used to access and report information from
the database are part of the _______________.
a.
14. An information-analysis tool that involves the automated
discovery of patterns and relationships in a data warehouse
is called _______________.
a.
data definition language
b.
data manipulation language
a data mart
c.
data normalization language
b.
data mining
d.
schema
c.
predictive analysis
d.
business intelligence
11. Access is a popular DBMS for _______________.
a. personal computers
b. graphics workstations
c. mainframe computers
d. supercomputers
12. A new trend in database management, known as Database
as a Service, places the responsibility of storing and man-
aging a database on a service provider. True or False?
15. _______________ allows users to predict the future based
on database information from the past and present.
CHAPTER 5: SELF-ASSESSMENT TEST ANSWERS
(1) c (2) database administrator (3) False (4) d (5) entity-
relationship diagram (6) a (7) Joining (8) False (9) schema
(10) b (11) a (12) True (13) data warehouse (14) b (15) Pre-
dictive analysis
The number and types of database applications will continue
to evolve and yield real business benefits.
13. A(n) _______________ holds business information from
many sources in the enterprise, covering all aspects of the
company's processes, products, and customers.
REVIEW QUESTIONS
1. What is an attribute? How is it related to an entity?
2. Define the term database . How is it different from a
database management system?
3. What is the hierarchy of data in a database?
4. What is a flat file?
5. What is the purpose of a primary key? How can it be useful
in controlling data redundancy?
6. What is the purpose of data cleanup?
7. What are the advantages of the database approach?
8. What is data modeling? What is its purpose? Briefly
describe three commonly used data models.
9. What is a database schema, and what is its purpose?
10. How can a data dictionary be useful to database adminis-
trators and DBMS software engineers?
11. Identify important characteristics in selecting a database
management system.
12. What is the difference between a data definition language
(DDL) and a data manipulation language (DML)?
13. What is the difference between projecting and joining?
14. What is a distributed database system?
15. What is a data warehouse, and how is it different from a
traditional database used to support OLTP?
16. What is meant by the “front end” and the “back end” of a
DBMS?
17. What is data mining? What is OLAP? How are they
different?
18. What is an ORDBMS? What kind of data can it handle?
19. What is business intelligence? How is it used?
20. In what circumstances might a database administrator con-
sider using an object-oriented database?
DISCUSSION QUESTIONS
1.
You have been selected to represent the student body on a
project to develop a new student database for your school.
What actions might you take to fulfill this responsibility to
ensure that the project meets the needs of students and is
successful?
2.
Your company wants to increase revenues from its existing
customers. How can data mining be used to accomplish
this objective?
3.
You are going to design a database for your cooking club
to track its recipes. Identify the database characteristics
 
Search WWH ::




Custom Search