Databases

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

A group of related records.

• Entity
• Validation
• Field
• Filter

A rule to make sure that only reasonable and sensible data is entered.

• Filter
• Query
• Validation
• Verification

Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...

• Data Types
• Filters
• Sorts
• Validations

A database search that can be saved as a separate file.

• Query
• Validation
• Filter
• Verification

A data type used for storing numbers with a fractional part e.g. 3.142

• Integer
• Boolean
• Real / Float
• String

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

A data type that can only hold 2 values e.g. Yes/No or True/False.

• Boolean
• Integer
• Real
• String

What is a database?

• A piece of software to do calculations
• A device to load information onto the computer.
• A structured collection of information
• A calculator