Ch. 11 Logical Data Flashcards

question

1. Physical 2.Logical
answer

data views (Know 2 views – ways of viewing)
question

Physical view
answer

A data perspective that focuses on the actual format and location of the data.
question

Logical view
answer

A data perspective that focuses on the meaning and content of the data.
question

field
answer

A group of related characters.
question

record
answer

A collection of related fields.
question

database
answer

An integrated collection of logically related records or objects.
question

primary key / key field
answer

A database has at least one distinctive field that uniquely identifies the record.
question

batch processing
answer

Data is collected over several periods, and then processed all at once.
question

real-time processing / online processing
answer

Data is processed at the same time the transaction occurs
question

data redundancy
answer

Records for the same data entity may appear in different files.
question

Data integrity
answer

Database characteristics relating to the consistency and accuracy of data.
question

data definition subsystem
answer

Defines the logical structure of the database.
question

query-by-example
answer

A database tool that supports viewing all or selected parts of the data
question

SQL
answer

A specialized database programming language.
question

1.Hierachical 2.Network 3.Relational 4.Multidimensional 5.Object-oriented
answer

DBMS structures (Know 5 models)
question

Hierarchical database
answer

Field or records are structured in nodes in a one-to-many relationship.
question

Network database
answer

A database structure that uses a many-to-many relationship.
question

Relational database
answer

A database structure where data elements are stored in different tables, each of which consists of rows and columns.
question

Multidimensional databases
answer

A data model that include additional or multiple dimensions.
question

Object-oriented database
answer

A database that can store data as well as instructions to manipulate the data, and is able to handle unstructured data.
question

1.Individual 2.Company 3.Distributed 4.Commercial
answer

Types of databases (Know 4 types)
question

Individual database
answer

A collection of integrated files primarily used by just one person (AKA a personal computer database).
question

Company database
answer

Databases companies create for their own use.
question

Distributed database
answer

A database that is located in a place or places other than where users are located.
question

Commercial database
answer

An enormous database that an organization develops to cover particular subjects.
question

CSI – example of commercial database
answer

Offers consumer and business service, including electronic mail.
question

Dialog Information Services – example of commercial database
answer

Offers business information, as well as technical and scientific information.
question

Dow Jones Interactive Publishing – example of commercial database
answer

Provides world news and information on business, investments, and stocks.
question

LexisNexis – example of commercial database
answer

Offers news and information on legal, public records, and business issues.
question

data warehouse
answer

Data collected from a variety of internal and external databases and stored in one location.

Get instant access to
all materials

Become a Member