Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/24

Click to flip

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