Key Database Concepts

Front

Database

Back

A structured set of data held in a computer, usually in a way that is accessible by multiple concurrent users.

Front

Database Management System (DBMS)

Back

Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access.

Front

Table

Back

A data structure in a relational database that is comprised of fields (columns) and records (rows).

Front

Query

Back

A method of asking questions about the data stored in a database.

Front

Form

Back

A graphical interface that allows users to query a database by filling in information on the form.

Front

Report

Back

An easy-to-read listing of the results of a query.

Front

Relational Database

Back

A database that holds data on multiple related tables.

Front

Field

Back

A single attribute of each record in a table.

Front

Record

Back

A single instance of an entity stored in a database table.

Front

Primary Key

Back

A field in a table that uniquely identifies a record.