Database

What is a record?

A complete row of information about a person or thing.

What is a relational database?

A database comprised of linked tables.

What is a database?

A database is a structured set of data held in a computer, especially one that is accessible in various ways.

What is a flat file?

A database that holds all the information in one file.

What is a field?

A field in a record that holds unique data which identifies that record from all the other records in the file or database.

A relational database helps you avoid making data entry mistakes. [True] / [False]

True.

record

a complete description of all of the fields related to one item in a table.

field

a grouping or category of similar information contained in a table; a unique identifier for a category of information

entry

a single piece of data in a database table.

table

an arrangement of columns and rows. It is the fundamental building block of all databases.

autonumber

used to automatically assign a number to each record and to assist in preventing duplication of data.