| 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 |  | 
        |  |