Lesson Objective
- Define the term database.
- Understand the concept of a relational database.
- Explain the structure of a database using the concepts of Tables, Records, Fields, Data Types, Primary and Foreign Keys.
mrahmedcomputing
KS3, GCSE, A-Level Computing Resources
Lesson 1. Database Fundamentals
Lesson Notes
Databases
A database is a collection of data stored in an organised and logical way. It should have little to no repetition of data within it. Databases can be in a paper or digital from.
Database: Components
Computerised Databases store data in tables. A table a set of fields and records that model that store data.
A single flat-file table is useful for recording a limited amount of data. But a large flat-file database can be inefficient as it takes up more space and memory.
Relational databases allow data to be stored in a clear, organised manner across multiple tables. Links, known as relationships, are formed to allow the data to be shared across the tables.