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