Term
|
Definition
A collection of information stored in an organized form in a computer |
|
|
Term
|
Definition
In a database, a collection of related information |
|
|
Term
|
Definition
In a database, the information relating to one person, product, or event |
|
|
Term
|
Definition
Each discrete chunk of information in a database record. |
|
|
Term
|
Definition
The characteristic of a field that determines the kind of information that can be stored in that field. |
|
|
Term
|
Definition
A field that contains data the uniquely identifies the record. (SSN, student IDs, book #s) |
|
|
Term
|
Definition
Looking for a specific record. |
|
|
Term
|
Definition
|
|
Term
|
Definition
Arrange records in alphabetical or numeric order based on values in one or more fields. |
|
|
Term
|
Definition
A complex query structure supported by most search engines; one example is “American AND Indian BUT NOT Cleveland” |
|
|
Term
|
Definition
A view of the database that shows one record at a time. |
|
|
Term
|
Definition
Showing data by displaying many records in lists similar to a spreadsheet. |
|
|
Term
|
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
|
Definition
A relatively simple database system in which each database is contained in a single table |
|
|
Term
|
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
|
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
|
Definition
A reference to the validity of data |
|
|
Term
|
Definition
The discovery and extraction of hidden predictive information from large databases. |
|
|
Term
|
Definition
Compiling profiles by combining information from different database files by looking for a shared unique field |
|
|
Term
|
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
|
Definition
ATMs, filght reservations, computerized inventory systems, computerized library systems |
|
|
Term
|
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
|
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
|
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 |
|
|