A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Computer databases typically contain collections of data records or files, containing information about specific entities like people or cars.

Database Tables

A table contains all of the information about an entity within the database like a Customer

Database Records

A record is the name for a row in a table that contains all of the information about an individual Customer in the table. Tables contain multiple records

Database Fields

A field is the name for a column in a table that contains an attribute of a Customer in the table.

Attributes are pieces of information about each Customer like their name or their address.

Tables will contain multiple fields.

Primary Key

A Primary is a field in a table that uniquely identifies an individual record in the table.

Primary Keys are used to prevent duplicate information in a table and to speed up searches.