This test is run by .
Note that your final mark will not be saved in the system.
Note that your final mark will not be saved in the system.
20 - Databases MatchUp
Target Level
C
Running Total
0
0%
Attempt
1 of 3
Click on a top box, then click on its match below. Or, drag a top box and drop it onto the correct match. Match all pairs before clicking ‘Check’.
Composite primary key
Relational
Foreign key
Query
Record
Client
Attribute
Primary key
Third normal form
Normalisation
A term that refers to the entity accessing a database,
whether that is a person or another system
A field within a table used to uniquely identify each record
A request to access or manipulate data in a database
An instance within a table, typically represented as a row
A key comprised of more than one field, wherein the
combination needs to be unique
Describes data divided into entities, each of which comprises fields that depend on the key, the whole key and nothing
but the key
A type of database that involves multiple interconnected
tables
An aspect of an entity, typically represented as a column
In order to facilitate a one-to-many relationship, there must
be one of these at the 'many' end of that relationship
The process of minimising repeated data within a relational
database