Chapter 4 part 1

Question 1

Database

Answer 1

Set of interrelated, centrally coordinated files

Question 2

Database management system (DBMS)

Answer 2

the interface between the database and the various application programs

Question 3

Database system

Answer 3

the database, the DBMS, and the application programs that access the database through the DBMS

Question 4

Data warehouse

Answer 4

contains both detailed and summarized data for a number of years and is used for analysis rather than transaction processing

Question 5

Business intelligence

Answer 5

using a data warehouse for strategic decision making

Question 6

Online analytical processing (OLAP)

Answer 6

Using queries to guide the investigation of hypothesized relationship in data

Question 7

Data mining

Answer 7

using sophisticated statistical analysis, including artificial intelligence techniques such as neural networks, to “discover” unhypothesized relationships in the data

Question 8

Benefits of database

Answer 8

data integration
data sharing
minimal data redundancy and data inconsistencies
data independence 
cross-functional analysis

Question 9

Logical view

Answer 9

how people conceptually organize and understand the data

Question 10

Physical view

Answer 10

refers to how and where data are physically arranged and stored in the computer system

Question 11

Schema

Answer 11

describes the logical structure of a database

Question 12

Conceptual-level schema

Answer 12

lists all data elements and the relationships among them

Question 13

External-level schema

Answer 13

consists of individual user views of portions of the database, each of which is referred as a subschema

Question 14

internal-level schema

Answer 14

a low-level view of the database, describes how the data are stored and accessed, including record layouts, definitions, addresses, and indexes