Relational Databases (AQA GCSE Computer Science): Flashcards

Same info repeated multiple times in a database table

Same info stored differently, creating conflicting data

Multiple smaller tables that are connected to each other

Field that uniquely identifies each record in a table

Field in one table that refers to primary key in another

Data redundancy and data inconsistency

Wastes storage space and creates maintenance problems

Creates conflicting and unreliable data

Each piece of info stored in only one place

Only need to update in one place, applies to all

Connect tables by referencing primary keys in other tables

Each value is unique - no two records can have the same