Chapter 05

 

 

E-commerce presents a major opportunity for the effective use of data mining.     TRUE

 

Data marts are usually larger than data warehouses.       FALSE

 

One of the goals of a DBMS is to increase data redundancy thereby making it less vulnerable to hackers. FALSE

 

A primary key is a field or set of fields that uniquely identifies a record.    TRUE

 

ER diagrams can serve as reference documents once a database is in use.           TRUE

 

A database is a collection of integrated and related files.  TRUE

 

The use of competitive intelligence is illegal and unethical.            FALSE

 

The smallest piece of data used by computers is called a ____.

a.

byte

b.

character

c.

bit

d.

megabyte

 

A collection of related data fields is called a ____.

a.

byte

b.

record

c.

character

d.

bit

 

A(n) ____ is a generalized class of people, places, or things for which data is collected, stored, and maintained.

a.

record

b.

entity

c.

attribute

d.

file

 

In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n) ____.

a.

attribute

b.

entity

c.

key

d.

object

 

Which attribute would make the best primary key?

a.

Social security number

b.

Last name

c.

First name

d.

Age

 

A more efficient and effective means of organizing data was developed with ____.

a.

the database approach to data management

b.

the traditional approach to data management

c.

the network approach to data management

d.

the hierarchical approach to data management

 

The database approach to data management requires ____.

a.

at least one flat file

b.

data redundancy

c.

a DBMS

d.

program-data dependence

 

Which of the following is NOT an advantage of the database approach to data management?

a.

Reduced data redundancy

b.

Data and program dependence

c.

Framework for program development

d.

Better overall protection of the data

 

Roger Rotune created an ER diagram that encompassed the requirements of his organization. This is an example of ____.

a.

data warehousing

b.

data systems modeling

c.

organizational data modeling

d.

enterprise data modeling

 

 

A ____ is a diagram of entities and their relationships.

a.

data model

b.

data flow diagram

c.

hierarchical model

d.

file diagram

 

A data model that uses basic graphical symbols to show the relationships between data is a(n) ____.

a.

planned redundancy model

b.

entity-relationship diagram

c.

hierarchical data model

d.

network data model

 

The ____ data model follows a treelike structure.

a.

distributed

b.

hierarchical

c.

network

d.

relational

 

The most popular database model currently in use is the ____.

a.

relational model

b.

hierarchical model

c.

network model

d.

object model

 

 

 

As long as tables in a database ____, they can be linked to provide useful information.

a.

share at least one common element

b.

share two or more common elements

c.

are projected

d.

have been normalized

 

The purpose of ____ is to develop data that is accurate and complete.

a.

linking

b.

joining

c.

data cleanup

d.

data modeling

 

A ____ provides a detailed description of all data used in the database.

a.

network model

b.

data dictionary

c.

data model

d.

schema

 

One of the first steps in installing and using a database involves ____.

a.

data cleaning

b.

determining the schema

c.

training users

d.

writing SQL for data manipulation

 

A ____ allows the database's creator to describe the logical access paths and logical records in a database.

a.

DDL

b.

DML

c.

data model

d.

data dictionary

 

 

To speed up processing, Pill's Pottery Company sends a copy of important data to each of its five warehouses. At the end of the day, any changes are sent back to the main database. Pill's is using ____.

a.

ODBC

b.

OLAP

c.

replicated databases

d.

data warehouses

 

Cranberry Farms, Inc. in Wisconsin has data spread across several smaller databases that are connected via the Internet. They use a ____.

a.

replicated database

b.

distributed database

c.

data file approach

d.

flat file approach