Databases (AQA GCSE Computer Science): Flashcards

Persistent store of organized data

Data stays until deleted, doesn't vanish when PC turns off

Complete entry about one item or person

Category of info in record, stores one type of data

Special field that uniquely identifies each record

To uniquely identify records, even when other data identical (e.g., same names)

Same info repeated multiple times in database

Larger file, wasted storage, harder to maintain

Same info appears differently in different places

Confusion, errors, unreliable database info

Database splitting info across multiple connected tables

Eliminates redundancy, prevents inconsistency, efficient

Records, fields, and tables