Databases

A row in a database.

• Record
• Field
• Entity
• Table

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 method of only displaying records in a table that match specific criteria...

• Filter
• Validation
• Sort
• Verification

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

• Query
• Validation
• Filter
• Verification

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 does DBMS stand for?

• Database Management System
• Database System
• System Management

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

A car sales business wants to find all its customers in Paisley what database tool will it use?

• Report
• Search
• Query
• Form