Database Vocabulary

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

• Database

• Data Modeling

• Operational Data

• Analytical Data

A way to help programmers and other related parties make sense of database information.

• Database

• Data Modeling

• Operational Data

• Analytical Data

Data that is produced by an organization's everyday operations. It's gathered in real time to provide a snapshot of what's happening in the present.

• Database

• Data Modeling

• Operational Data

• Analytical Data

Historical data that is used to help people make decisions in the present. It's various categories include market data, transactional data, sensor data, natural language, and machine data.

• Database

• Data Modeling

• Operational Data

• Analytical Data

Match the terms to their definitions.

• Database Management System (DBMS)

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

• Table

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

• Query

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

• Form

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

• Report

• Software that allows users to define, manipulate, retrieve, and manage data stored in a database.

Match the following

• Relational Database

• A field that corresponds to the primary key field in another table.

• Record

• A field in a table that uniquely identifies a record.

• Field

• A single attribute of each record in a table.

• Primary Key

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

• Foreign Key

• A database that holds data on multiple related tables.

A design technique that organizes data in a database in an optimal way. This results in it being easier to add, remove, and update data without introducing errors.

• Normalization

• Direct Access

• Query Builder

A method of accessing a database directly using the database management system itself.

• Normalization

• Direct Access

• Query Builder

A method of accessing a database using a graphical user interface that allows users to select what actions they want to perform on a database.

• Normalization

• Direct Access

• Query Builder

A method of accessing a database using forms that allow users to interact with the database.

• User Interface Access

• Programmatic Access

• SQL

• Data Definition Language (DDL)

• Data Manipulation Language (DML)