Edexcel GCSE Computer Science
3.5.2: understand that data can be decomposed, organised and managed in a structured database (tables, records, fields, relationships, keys)
3.5.2: understand that data can be decomposed, organised and managed in a structured database (tables, records, fields, relationships, keys)
| Keyword | Definition |
|---|---|
| Database | a way of organising data using tables, records, fields, relationships and keys |
| Field | one individual category of data that's stored for each record (e.g. "SongName") |
| Foreign Key | a field that identifies a record in a different table |
| Key | a field used to identify a record |
| Primary Key | a field that is unique for every record in a table |
| Record | a group of related fields that, together, describe one item (e.g. "The National Anthem") |
| Relational database | a database where tables are linked together using foreign keys |
| Relationship | a link between tables to show how records are connected to each other |
| Table | a group of similar records (e.g. songs) |
