Computer Chapter 10
Order by
37 terms
Terms | Definitions |
|---|---|
 Database | A Collection of Data |
| Information | Processed Data |
| DBMS - Database Management System | Add, modify, delete, sort, or retrieve data |
| Data integrity | Identifies the quality of the data |
| GIGO | Garbage in, garbage out |
| Accurate information | Error-free data |
| Verifiable information | Data that can be proven to be correct or incorrect |
| Timely information | Data that has an age suited to its use |
| Organized information | Data that is arranged to suit the needs and requirements of the user |
| Accessible information | Data that is available when the user needs it |
| Useful information | Data that has meaning to the user |
| Cost-effective information | Data that gives more value that it costs to produce |
| Database hierarchy | Databse contains files which contain records which contain fields which contain characters |
| Character | A number, letter, space, punctuation mark, or symbol |
| Field | A combination of one or more related characters |
| Field name | Uniquely identifies each field |
| Field size | Defines the maximum number of characters a field can contain |
| Data type | Specifies the kind of data a field can contain |
| Common data types | Text, numeric, autonumber, currency, date, memo, yes/no, hyperlink, object |
| Record | A group of related fields |
| Primary key | A field that uniquely identifies each record in a field |
| Data file | A collection of related records |
| File maintenance | Procedures that keep data current |
| 2 Reasons to modify a record | 1) to correct inaccurate data, 2) to update old data with new data |
| Validation | Comparing data with a set of rules or values to find out if the data is correct |
| Validation checks | alphabetic/numeric, range, consistency, completeness, digit |
| Benefits of using a database | reduced data redundancy, improved data integrity, shared data, easier access, reduced development time |
| Data dictionary | Contains data about each file in the database and each field in those files. |
| Query | A request for specific data |
| Form | A window on the screen that provides areas for entering ro modifying data |
| Backup | A copy of the database |
| Recovery utility | Uses backups to restore lost or damaged data |
| Data model | Rules and standards that define how the database organizes information |
| Relational database | Organizes data using tables, columns, rows, and relationships |
| Different types of databases | Multimedia, groupware, computer-aided design, hypertext |
| Multidimensional Database | A database that stores data in multiple dimensions |
| Structure Query Language (SQL) | Allows users to manage, update, and retrieve data in a relational database |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.