Prev
Next
All data stored in one table
Data stored across multiple tables
Diagram showing relationships between entities
Process of removing data redundancy
When a table does not contain any repeating attributes
When a table does not have any partial key dependencies
When a table does not have any non-key dependencies
When incorrect data is present in a table
When data is repeated unnecessarily in a table
Used to uniquely identify each record in a table
A primary key using only one field
A primary key using two or more fields
Copy of a primary key, used to link tables.
Table without any normalisation
High level language used to manipulate databases
Part of SQL used to edit and query data
Part of SQL used to manipulate the structure of the database
Selection of database, obtained using SQL based on certain conditions
A saved query
One record from table A is linked to one in table B, and one from table B is linked to one from table A
One record from table A is linked to many in table B, and one from table B is linked to one from table A
One record from table A is linked to many in table B, and one from table B is linked to many from table A
