Find a Tutor Sherpa Study

Sherpa

Find a Private Tutor Become a Tutor SEND & Homeschooling Free GCSE Revision Resources

Blog Revision Plan

Existing user?

Computer Science

GCSE · AQA

QuestionsFlashcards

Representing Algorithms
Efficiency of Algorithms
Searching Algorithms
Sorting Algorithms

Data Types
Programming Concepts
Arithmetic, Relational & Boolean Operations
Data Structures
Input, Output & String Handling
Random Number Generation
Subroutines & Structured Programming
Robust & Secure Programming

Number Bases & Conversions
Units of Information
Binary Arithmetic
- Binary Addition
  3
- Binary Shifts
  6
Character Encoding
Representing Images
Representing Sound
Data Compression

Hardware & Software
Boolean Logic
Programming Languages & Translators
CPU & the Fetch-Execute Cycle
Memory & Storage
Embedded Systems

Network Types & Connections
Protocols & the TCP/IP Model
Network Security

Cyber Security Threats
Social Engineering
- What Social Engineering Is
  4
- Blagging, Phishing & Shouldering
  5
Malware
- What Malware Is
  2
- Viruses, Trojans & Spyware
  3
Detecting & Preventing Threats

Relational Databases
SQL

Ethical, Legal & Environmental Impacts

Sherpa Study
GCSE Computer Science
AQA Flashcards
7. Relational Databases & SQL
Relational Databases
Databases & Relational Databases

Databases & Relational Databases Flashcards

All 4 cards in this deck

What is a database?: A persistent, organised collection of structured data.
What is a relational database?: A database that stores data in more than one table, with the tables linked to each other by key fields (a primary key in one table used as a foreign key in another).
True or false? A relational database links several databases together.: False. It links several tables together within one database.
What is a flat-file database?: A database that keeps all of its data in one single table. A relational database instead splits the data into several linked tables.