Term
|
Definition
Raw Facts
Must be formatted for storage, processing and presentation |
|
|
Term
|
Definition
The result of processing raw data to reveal meaning
Requires context to reveal meaning |
|
|
Term
|
Definition
| Shared integrated computer structure that stores a collection of data |
|
|
Term
|
Definition
| Raw facts of interest for end user |
|
|
Term
|
Definition
Data about data
Expands value of data |
|
|
Term
|
Definition
Software
Collection of programs that manage the structureand control access to data
Never lets the user touch the raw data |
|
|
Term
|
Definition
Single User DB
Multi User DB
Centralized
Decentralized
Transactional
Data warehouse |
|
|
Term
|
Definition
Desktop Database
Supports only one user at a time |
|
|
Term
|
Definition
| Supports multiple users at the same time |
|
|
Term
|
Definition
| Supports 50 users or less |
|
|
Term
|
Definition
| Supports more than 50 users |
|
|
Term
|
Definition
| Data located on a single site |
|
|
Term
|
Definition
| Data distributed across several different sites |
|
|
Term
|
Definition
| Supports a company's day to day operations |
|
|
Term
|
Definition
Stores data used for tactical or strategic decisions
Not updated everyday
Extremely large |
|
|
Term
|
Definition
A character or group of characters that has a specific meaning.
Used to define and store data |
|
|
Term
|
Definition
| Logically connected set of one or more fields that describe a person place or thing |
|
|
Term
|
Definition
| A collection of related records |
|
|
Term
|
Definition
|
|
Term
|
Definition
Composed of collection of file folders
Each tagged and kept in cabinet |
|
|
Term
|
Definition
| Required the programmer to use 3GL |
|
|
Term
|
Definition
| Must specify what must be done and how it is to be done |
|
|
Term
|
Definition
| Specify what must be done without specifying how it must be done |
|
|
Term
|
Definition
| Access to a file dependent on its structure |
|
|
Term
|
Definition
| Change file structure without affecting data access |
|
|
Term
|
Definition
| Data access changes when data storage characteristics change |
|
|
Term
|
Definition
| Data storage characteristics do not affect data access |
|
|
Term
|
Definition
| Same data stored unnecessarily in different places |
|
|
Term
|
Definition
| Different and conflicting versions of same data occur at different places |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Defines and regulates the collection, storage, management, use of data |
|
|
Term
| Major Parts of a Database System |
|
Definition
Hardware
Software
People
Procedures
Data |
|
|
Term
|
Definition
|
|
Term
| Three types of Software required |
|
Definition
Operating System
DBMS
Application programs and utility software |
|
|
Term
|
Definition
System and database administrators
Database designers
System analyst and programmers
End users |
|
|
Term
|
Definition
| Instructions and rules that govern the design and use of the database system |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Activities that make the database perform more efficently |
|
|
Term
|
Definition
Non procedural language
Specify what must be done without specifying how it must be done |
|
|
Term
| Structured Query Language |
|
Definition
De facto query language
4GL |
|
|
