click below
click below
Normal Size Small Size show me how
DSST Computers #9
| Question | Answer |
|---|---|
| Alphabetic Check | Validity check that ensures users enter only alphabetic data in a field. |
| Attribute | Each data element in an object. Also called a property. |
| Backup | Duplicate or copy of a file, program, or disk that can be used if the original is lost, damaged, or destroyed. |
| Character | A number, letter, punctuation mark, or other symbol that is represented by a single byte in the ASCII and EBCDIC coding schemes. |
| Check Digit | Validity check consisting of a number(s) or character(s) that is appended to or inserted in a primary key value. |
| Collaborative Databases | Web database where users store and share photos, videos, recordings, and other personal media with other registered users. |
| Column | Term used by users of relational databases for field. |
| Completeness Check | Validity check that verifies that a required field contains data. |
| Composite Key | Primary key that consists of multiple fields. |
| Consistency Check | Validity check that tests the data in two or more associated field to ensure that the relationship is logical and their data is in the correct format. |
| Continuous Backup | Backup plan in which all data is backed up whenever a change is made. |
| Data | Collection of unprocessed items, which can include text, numbers, images, audio, and video. |
| Data Dictionary | A DBMS element that contains data about each file in a database and each field in those files. Also called a repository. |
| Data File | Collection of related records stored on a storage medium such as a hard disk or optical disc. |
| Data Model | Rules and standards that define how a database organizes data. |
| Data Type | Specifies the kind of data a field in a database can contain and how the field can be used. |
| Data Warehouse | Huge database that stores and manages the data required to analyze historical and current transactions. |
| Database | Collection of data organized in a manner that allows access retrieval, and use of that data. |
| Database administrator (DBA) | Person who creates and maintains the data dictionary, manages security of a database, monitors the performance of a database, and checks backup and recovery procedures. |
| Database analyst (DA) | Person who focuses on the meaning and usage of data, including proper placement of fields, defining the relationships among data, and identifying users' access privileges. Also called a data modeler. |
| Database approach | System used to store and manage data in which many programs and users share the data in a database. |
| Database Management System (DBMS) | Program that allows user to create a computerized database; add, change, and delete data in the database, sort and retrieve data from the database; and create forms and reports from the data in the database. Also called database management software. |
| Database Software | Application software used to create, access, and manage a database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports using the data in the database. |
| Field | A combination of one or more related characters or bytes, a field is the smallest unit of data a user accesses. |
| Field Name | Name that uniquely identifies each field in a database. |
| Field Size | Defines the maximum number of characters a field can contain. |
| File Maintenance | Procedures that keep data current. |
| File Processing System | System used to store and manage data in which each department or area within an organization has its own set of files. |
| Form | Window on the screen that provides areas for entering or modifying data in a database. Also called data entry form. |
| Garbage In, Garbage Out (GIGO) | Computing phrase that points out the accuracy of a computer's output depends on the accuracy of the input. See also GIGO. |
| Information | Processed data that conveys meaning and is useful to people. |
| Log | Listing of activities that change the contents of a database. |
| Multidimensional Base | Database that stores data in dimensions. |
| Numeric Check | Validity check that ensures users enter only numeric data in a field |
| Object | Database item that contains data, as well as the actions that read or process the data. |
| Object-Oriented Database (OODB) | Database that stores data in objects. |
| Primary | Key Field in a database that uniquely identifies each record in a file. Also called key field. |
| Principle of Least Privilege | Policy adopted by some organizations, where users' access privileges are limited to the lowest level necessary to perform required tasks. |
| Query | Request for specific data from a database. |
| Query by Example (QBE) | DBMS feature that has a graphical user interface to assist users with retrieving data. |
| Query Language | Language used with databases that consists of simple, English-like statements that allows users to specify the data to display, print, or store. |
| Range Check | Validity check that determines whether a number is within a specified range. |
| Record | Group of related fields in a database. |
| Recovery Utility | DBMS feature that uses logs and/or backups to restore a database when it becomes damaged or destroyed. |
| Relation | Term used by developers of relational databases for file. |
| Relational Database | Database that stores data in tables that consist of rows and columns, with each row having a primary key and each column having a unique name. |
| Relationship | Link within data in a database. |
| Report Generator | DBMS feature that allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. Also called a report writer. |
| Row | Term used by users of relational databases for record. |
| Structured Query Language (SQL) | Query language used with databases that allows users to manage, update, and retrieve data. |
| Table | Term used by users of relational databases for file. |
| Tuple | Term used by developers of relational databases for record. |
| Validation | Process of comparing data with a set of rules or values to find out if the data is correct. |