Databases (OCR A-Level Computer Science): Flashcards
📚Flashcards
Practise the cards
15 cards from this deck
ShowHide
Practise the cards
15 cards from this deck
Database definition
Database definition
Organised collection of structured data
Relational database structure
Relational database structure
Organises data into tables that can be linked/related
Table in database
Table in database
Structure with rows and columns representing an entity
Field in database
Field in database
Single attribute or piece of information within a table
Record in database
Record in database
Row in table representing a single item or entity
Primary key purpose
Primary key purpose
Unique identifier for each record in a table
Foreign key function
Foreign key function
Field linking to primary key of another table
Flat file database structure
Flat file database structure
Stores all data in single table or file
Flat file database benefits
Flat file database benefits
Simple, suitable for small data, easy to implement
Flat file main limitation
Flat file main limitation
Redundant data and poor data integrity
Relational database organization
Relational database organization
Multiple tables with defined relationships
Relational database main benefit
Relational database main benefit
Reduces redundancy and enhances data integrity
Relational database limitation
Relational database limitation
Complex to set up and resource-intensive
Normalisation purpose
Normalisation purpose
Minimise redundancy and dependency in database structure
How tables relate in relational DB
How tables relate in relational DB
Using primary and foreign keys to connect data