Database Systems Chapter 1 (Lecture)

What is a key characteristic of knowledge?

"new" Knowledge can be derived from "old" knowledge.

How many users does a workgroup database usually support?

50

The ________ manages interaction between the end user and the database.

DBMS

The ________ receives all application requests and translates them into the complex operations required to fulfill requests.

DBMS

What is a benefit of using a DBMS?

It helps create an environment for end users to have access to more data.

Which of the following products do not provide an enterprise database?

MS Access

________ is the de facto query language and data access standard supported by the majority of DBMS vendors.

Structured Query Language (SQL)

A data ________ develops when all of the required changes in the redundant data are not made successfully.

anomaly

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.

create a new query

A raw fact such as a telephone number is known as ________.

data

Because all data access programs are subject to change when any of the file's data storage characteristics change (that is, changing the data type), the file system is said to exhibit ________.

data dependence

Where does the DBMS store the definitions of data elements and their relationships?

data dictionary

A ________ focuses primarily on storing data used to generate information required to make Tactical or strategic decisions.

data warehouse

The design of a ________ database recognizes the use of historical and aggregated data.

data warehouse

A ________ system is composed of software, hardware, data, procedures and people.

database

________ are considered database architects.

database designers

The term ________ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

database system

A single-user database that runs on a personal computer is called a(n) ________ database.

desktop

A database that supports data distributed across several different sites is called a(n) ________ database.

distributed

________ are the people who use application programs to run the organization's daily operations.

end users

What is the most common classification applied to a DBMS?

expected type and extent of use

Where was a traditional file system normally stored?

file cabinet

Raw data must be properly ________ for storage, processing, and presentation.

formatted

Which of the following would result in a data anomaly?

inconsistent redundant data

Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

independence

Accurate, relevant, and timely ________ is the key to good decision making.

information

Processed data, or ________, can be used as the foundation for decision making.

information

Wider access to well-managed data promotes a(n) ________ view of the organization's operations and a clearer view of the big picture.

integrated

Data ________ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."

integrity

Human beings view data according to its ________ data format.

logical

What is the name for data about data?

metadata

A(n) ________ allows the user to specify what must be done without specifying how it must be done.

nonprocedural language

________ are the instructions and rules that govern the design and use of the database system.

procedures

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.

query language

What is the name for an answer to a query that the DBMS sends back to the application?

query result set

The word ________ indicates that the facts have not yet been processed to reveal their meaning.

raw

All fields for a specific entity can be grouped together as a ________.

record

________ deals with fixing the database after a failure such as a hard disk malfunction.

recovery

Data ________ exists when the same data are stored unnecessarily at different places.

redundancy

A record consists of a ________.

set of one or more fields

Database management systems, operating systems, applications and utilities are all examples of ________.

software

An ad hoc query is a ________.

spur of the moment question

________ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

structural

Data processing (DP) specialists are in existence because of ________.

the need to track data and produce required reports

Data management is a discipline that focuses on ________.

the proper generation, storage, and retrieval of data

Another name for a production database is a ________ database.

transactional

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.

tuning