Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
24 Cards in this Set
- Front
- Back
A field in a database.
|
column
|
|
The process of describing the characteristics of data that is to be included in a database table.
|
Data Definition
|
|
The repostory of all data definitions in a dtatabase.
|
Data dictionary
|
|
The accuracy of data.
|
Data integrity
|
|
Protecting data in a database against destruction and misuse.
|
Data security
|
|
The process of ensuring that data entered into a database matches the data definition.
|
Data validation
|
|
A collection of related data that is stored in a manner enabling information to be retrieved as needed; in a relational database, a collection of related tables.
|
Database
|
|
A type of software program used to create, maintain and access databases.
|
Database management system (DBMS)
|
|
A method of arranging data ona a storage medium that uses hashing to specify the exact storage location.
|
Direct organization
|
|
Something in a database system (such as a person, object, or event) that is of importance to the organization.
|
Entity
|
|
A single category of data to be stored in a database, such as a person's name or telephone number.
|
Field
|
|
A small table containing a primary key and the location of the record belonging to that key; used to locate records in a database.
|
Index
|
|
A method for organizing data on a storage medium or in a database that uses an index to specify the exact storage location.
|
indexed organization
|
|
Software used to connect two otherwise separate applications, such as a Web server and a database management system.
|
Middleware
|
|
A type of database in which data can be viewed from multiple dimensions: commonly used with data warehousing.
|
Multidimensional database (MDDB)
|
|
A type of database system in which multiple types of data are stored as objects along with their related code.
|
Object-oriented database management system (OODBMS)
|
|
A special field in a database table that uniquely identifies the records in that table.
|
Primary Key
|
|
A request to see information from a database matching specified criteria.
|
Query
|
|
A collection of related fields in a database. Also called a row.
|
Record
|
|
A type of database system in which data is stored in tables related by common fields; the most widely used database model today.
|
Relational database management system (RDBMS)
|
|
A formatted means of looking at a database table or the results of a query.
|
Report
|
|
A collection of related fields located in a single table in a database.
|
Row
|
|
A popular query language standard for information retrieval in relational databases.
|
Structured query language (SQL)
|
|
In a relational database, a collection of rlated records (rows).
|
Table
|