The flashcards below were created by user
on FreezingBlue Flashcards.
A ___________ is a logically organized collection of related data designed and built for a specific purpose.
The data hierarchy consists of the level of data stored in a computer in this order:
A character is made up of ______.
A _____ _______ is a field that is chosen to uniquely identify a record so that it can be easily retrieved.
Program files are files containing ________ _________.
Two types of program files are a ________ program and an ________ (executable) program.
_______ ____________ is a method of removing repetitive elements from the file so that the file requires less storage space and sends faster.
Two data file types are:
- Master File
- Transaction File
A ________ file contains relative permanent records that are generally updated periodically by the transaction file.
A ________ file is a temporary holding file that holds all the changes to be made to the master file.
_______ _______ methods are the methods or way that a file or database allows access to the records stored within it.
This type of data access method is slow because you always have to start with the first record and move through the file in sequence to find the record you want:
This type of data access file is the one that means the computer can go straight to the location where record is stored:
Four types of databases:
Five types of database organization:
- Object Oriented
A data _________ is a special database of cleaned up data.
Data _________ is the computer assisted process of shifting through and analyzing large volumes of data in order to extract meaning and discover new knowledge.
________ _________takes a particular set of numerical data and develops a mathematical formula that fits the data, and then applies that formula to future data to predict future situations.
________ ________ is a statistics pattern recognition process that is applied to data with more than just numerical data.
A Database Management System (DBMS) consist of programs that ________ the _______ of a database and the ________ to the data.
6 features of a DBMS are:
- File Sharing
- Reduced data Redundancy
- Improved Data Integrity
- Increased Security
- Data Dictionary
- System Recovery
A ___________ __________ coordinates all the related activities for an organization's database.
Database Administrator (DBA)
_______ ________ is a feature of DBMS that means all authorized users can shore or work on the same set of files.
_________ data _______ is a feature of DBMS that reduces the occurrence of the same data appearing in multiple files.
Improved ________ ________ is a feature of DBMS that helps to insure that data is accurate, up to date and consistent.
Increased __________ is a feature of DBMS that means access to specific information can be limited to specific users.
A ______ ___________ is a feature of DBMS that contains definitions for the individual data fields.
__________ __________ is a feature of DBMS that allows the database administrator the ability to recover contents of a database in the event of a hardware or software failure.
An ___________ database is a collection of integrated files used by one person.
A ________ database is one that is shared by individuals at one company or organization.
A _________ database is one that is stored on different computers in different locations connected by a network.
A __________ database is one that is available to the general public.
In ____________ database organization, fields or records are arranged in related groups resembling a family tree, with child (lower level) records subordinate to a parent (higher level) record.
In _________ database organization, each child record can have more than one parent.
With __________ ___________ database organization, software is written in small reusable chunks, as elements within the database.
With ______________ database organization, data is modeled as facts, dimensions, or numerical measures for use in interactive analysis of large amounts of data.
With _________ database organization, data is connected in different files through the use of a key field or common data element