IT Fundamentals Databases Vocabulary 1

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

• Table

• Database

• Query

• Form

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

• Table

• Database

• Form

• Report

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.

• Database

• Table

• Database Management System (DBMS)

• Form

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

• Table

• Form

• Report

• Query

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

• Report

• Table

• Query

• Form

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

• Table

• Form

• Query

• Report

A single attribute of each record in a table.

• Foreign Key

• Primary Key

• Record

• Field

A database that holds data on multiple related tables.

• Relational Database

• Non-relational database

• Foreign Key

• Primary Key

A field in a table that uniquely identifies a record.

• Record

• Foreign Key

• Primary Key

• Database

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

• Table

• Record

• Field

• Report