databases

A database is an organised collection of data

A field is one piece of information relating to one person, item or object.

A record is a collection of fields relating to one person, item or object.

False. A field is represented by a column in a database table.

A validation rule controls what data can be entered into a field.

A length check is a validation that checks the number of characters entered into a field.

True. A presence check ensures a field cannot be left blank.

A data type is the type of data that can be held in a field and is defined when designing a table.

Examples of common data types are: Numeric, Character/string, Date/time, Boolean.

A database allows easy storage, retrieval, and management of information for large amounts of data.

A primary key is a unique field that can be used to identify a record in a table.

False. A primary key can be any data type, as long as it uniquely identifies each record.

A foreign key is a field in a table that refers to the primary key in another table.

A foreign key is used to link tables and create relationships.

True. Every table must have a primary key to uniquely identify each record

CustomerID

A record is a group of related fields, representing one data entry.

A field is a single piece of data in a record.

True. The primary key can be composed of multiple fields, known as a composite key.

A typical primary key in a school database would be: Student_ID