Is a generalized class of people or objects for which data is collected stored and maintained?

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

A collection of related data is called Database. A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields.

Is a collection of fields that contain data about an entity?

Record - a record represents a collection of attributes that describe a real-world entity. A record consists of fields, with each field describing an attribute of the entity.

Is a collection of information that is stored on a computer on a in a highly structured way?

A database is an organized collection of structured information, or data, typically stored electronically in a computer system.

Is a field or set of fields in a record that identifies the record?

A primary key consists of one or more fields that uniquely identify each record that you store in the table. Often, there is a unique identification number, such as an ID number, a serial number, or a code, that serves as a primary key.