A database is a...
persistent store of un-organised data.
persistent store of organised data.
persistent store of carefully selected and well organised data.
Persistent storage is...
non-volatile storage on a secondary storage medium such as a hard disk.
volatile storage on a secondary storage medium such as RAM.
storage on a secondary storage medium such as a hard disk.
Data duplication (also known as data redundancy) is...
where the same data is stored more than once, unnecessarily.
where the same data is stored only once, unnecessarily.
where the same data is stored unnecessarily.
Data inconsistency is...
where different versions of data become different because duplicate versions have been stored.
where different versions of data become different because duplicate versions have been updated differently.
where different versions of data become different because duplicate versions have been stored and updated differently.
A Database Management System (DBMS)...
separates the applications from the data and provides features that allow database systems to be created, interrogated and maintained.
separates the applications from the data and provides features that allow database systems to be interrogated and maintained.
separates the applications from the data and provides features that allow database systems to be created and maintained.
A flat file database is...
a persistent organised store of data where data is stored in a single file organised into fields.
a persistent organised store of data where data is stored in a single file organised into fields and records.
an organised store of data where data is stored in a single file organised into fields and records.
A relational database is...
a persistent organised store of data where data is stored as a collection of tables to minimise data redundancy.
a persistent store of data where data is stored as a collection of related tables to minimise data redundancy.
a persistent organised store of data where data is stored as a collection of related tables to minimise data redundancy.
An entity is a real world object, about which data is stored in a database and corresponds to...
a table in a relational database.
a field in a relational database.
a primary key in a relational database.
A table is a collection of data organised into records and fields within a relational database. A table represents a...
foreign key
real-world entity.
report.
Data stored about one instance of an entity, i.e. one particular person or object is called...
table.
a record.
a field.
One specific data item being stored such as a surname or shoe size is called...
a primary key.
a table.
A field in a table that uniquely identifies a record is called a...
foreign key.
primary key.
entity key.
A field in one table that is a primary key in another table and is used to create a relationship between those two tables is called...
a foreign key.
a relationship key.
A database form is...
an interactive window used for data entry that doesn't include validation routines.
an interactive window used for data entry that always includes validation routines.
an interactive window used for data entry that usually includes validation routines.
When the computer software checks that data entered is sensible.
Validation
Verification
Verify
Validate
Where data is entered twice and checked that each version is the same, to avoid data being entered with typing mistakes.
A feature of a DBMS that allows the database to be interrogated. It selects records from the database based on specified criteria.
Report
Query
Search
Data from a database that has been processed and presented on a page in a way that makes it information. Designed for hard copy.
Letter
