ISDS Chapter 11 – Flashcards
37 test answers
Unlock all answers in this set
Unlock answers 37question
Field
answer
group of related characters
Unlock the answer
question
Record
answer
a collection of related fields
Unlock the answer
question
Table
answer
a collection of related records
Unlock the answer
question
Database
answer
an integrated collection of logically related tables
Unlock the answer
question
Key field
answer
each record has a distinctive field
Unlock the answer
question
Primary key
answer
the field that uniquely identifies the record
Unlock the answer
question
Batch processing
answer
data is collected over several hours, days, or even weeks, and collected all at once
Unlock the answer
question
Real time processing
answer
occurs when data is processed at the same time the transaction occurs
Unlock the answer
question
Data redundancy
answer
when records from the same customer appear in different files in different departments
Unlock the answer
question
Data integrity
answer
maintaining and assuring the accuracy and consistency of data over its entire life-cycle
Unlock the answer
question
Sharing, security, less data redundancy, data integrity
answer
Advantages to having databases
Unlock the answer
question
Database management system (DBMS)
answer
software that allows one to create, modify, and gain access to a database
Unlock the answer
question
DBMS engine
answer
provides a bridge between the logical view of the data and the physical view of the data
Unlock the answer
question
Data definition subsystem
answer
defines the logical structure of the database by using a data dictionary—defines the type of data for each field
Unlock the answer
question
Data manipulation subsystem
answer
provides tools for maintaining and analyzing data
Unlock the answer
question
Application generation subsystem
answer
provides tools to create data entry forms and specialized programming languages that interface or work with common programming
Unlock the answer
question
Data administration subsystem
answer
helps to manage the overall database
Unlock the answer
question
Hierarchal database
answer
fields or records are structured in nodes—one-to-many relationship—one parent node has several child nodes
Unlock the answer
question
Nodes
answer
points connected like the branches of an upside-down tree
Unlock the answer
question
Network database
answer
hierarchal but it has a many-to-many relationship—each child node can have more than one parent node
Unlock the answer
question
Relational database
answer
elements are stored in different tables, each of which consists of rows and columns
Unlock the answer
question
Multidimensional database
answer
contains data cubes having three or more sides and consisting of cells—significant advantages are conceptualization and processing speed
Unlock the answer
question
Object-oriented database
answer
more flexible and store data as well as instructions to manipulate the data
Unlock the answer
question
Classes
answer
general definitions
Unlock the answer
question
Objects
answer
specific instances of a class that can contain both data and instructions to manipulate it
Unlock the answer
question
Attributes
answer
data fields that an object possesses
Unlock the answer
question
Methods
answer
instructions for retrieving or manipulating attribute values
Unlock the answer
question
Individual database
answer
collection of integrated files primarily used by one person—data and DBMS are under the direct control of the user and are stored on the user's hard-disk or a LAN file server
Unlock the answer
question
Company database
answer
may be stored on a central database server and managed by a database administrator—users in the company have access to the database—many are the foundation for management information systems
Unlock the answer
question
Distributed database
answer
data is stored in several locations and made accessible through a variety of communications networks—not all the data is physically located in one place—typically database servers on a client/server network provide the link between data
Unlock the answer
question
Commercial database
answer
generally an enormous database that an organization develops to cover particular subjects
Unlock the answer
question
Data warehouse
answer
collected data from a variety of external and internal databases is stored here
Unlock the answer
question
Data mining
answer
a technique used to search data warehouses to look for related information and patterns
Unlock the answer
