Shared Flashcard Set

Details

Database Vocab
ITGS
27
Other
11th Grade
10/21/2011

Additional Other Flashcards

 


 

Cards

Term
Database
Definition

A collection of information stored in an organized form in a computer

Term
Table
Definition

In a database, a collection of related information

Term
Record
Definition

   In a database, the information relating to one person, product, or event

Term
Field
Definition

Each discrete chunk of information in a database record.

Term
Field Type
Definition

The characteristic of a field that determines the kind of information that can be stored in that field.

Term
Key Field
Definition

A field that contains data the uniquely identifies the record. (SSN, student IDs, book #s)

Term
Search
Definition

 Looking for a specific record.

Term
Query
Definition

An information request.

Term
Sort
Definition

Arrange records in alphabetical or numeric order based on values in one or more fields.

Term
Boolean Logic
Definition

A complex query structure supported by most search engines; one example is “American AND Indian BUT NOT Cleveland”

Term
Form View
Definition

A view of the database that shows one record at a time.

Term
List View
Definition

Showing data by displaying many records in lists similar to a spreadsheet.

Term
Mailing Merge
Definition

A feature of a word processor or other program that enables it to merge names and addresses from a database mailing list onto personalized form letters and mailings.

Term
Flat-file Database
Definition

 A relatively simple database system in which each database is contained in a single table

Term
Relational Database
Definition

A program that allows files to be related to each other so changes in one file are reflected in other files automatically. (eliminates redundancy)

Term
Normalization
Definition

In a relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing the database into two or more tables and defining relationships between the tables

Term
Database Management System
Definition

A program or system of programs that can manipulate data in a large collection of files (the database), cross referencing between files as needed.

Term
Data Integrity
Definition

A reference to the validity of data

Term
Data Mining
Definition

The discovery and extraction of hidden predictive information from large databases.

Term
Record Matching
Definition

Compiling profiles by combining information from different database files by looking for a shared unique field

Term
Identity Theft
Definition

The crime, committed by hackers or other unscrupulous individuals, of obtaining enough information about a person to assume his or her identity, often as a prelude to illegally using the victim’s credit cards.

Term
Example of Database
Definition
ATMs, filght reservations, computerized inventory systems, computerized library systems
Term
Advantages of Databases
Definition
Easier to: store large quantities of information, retrieve info quickly and flexibility, organize and reorganize information, print and distribute info in a variety of ways
Term
Field Types
Definition
text (default), date, currency, number, yes/no
Term
Ways data integrity is invalid
Definition
errors that occur when data is transmitted from one computer to another, software bugs/ computer viruses, hardware malfunctions, human error when data is entered, natural disasters
Term
Ways to minimize threats
Definition
Backing up data regularly, controlling access to data with security mechanisms, designing user interfaces that prevent the input of invalid data
Term
Problems with Record matching
Definition
Data errors, can become immortal, data is not secure
Supporting users have an ad free experience!