How are records tracked?

The PRIMARY KEY

Each record in a table has a primary key or a field that uniquely identifies a given record in a table. This number is never repeated and is unique to that individual record. The primary key helps each record RELATE to other records in other tables.

Vocabulary Word: Primary Key

​The skeleton structure that shows the view of a database with each table having a title is a

database schema.​

​

​Schema

​A search in a database is a query.

​

When you type a search into Google, programmers call this a query.​

​

Query

The most commonly used database query language

SQL

"sequel"​

A simple form of data manipulation between a table of data and another document (paper letters, email, or HTML) is a merge.

​

Vocabulary: Merge

Merge

​

Another way to view data is a view.

View

Forms are used to enter data into a data table. (We have been using Google forms to create our data tables.)

Forms