050. OCR A Level (H046-H446) SLR10 – 1.3 Introduction to database concepts
About this video
OCR Specification Reference
AS Level 1.3.1a
A Level 1.3.2a
This video provides a basic introduction to the concepts of databases, it covers: Relational, Flat file, Primary key, Foreign key, Secondary key, Entity relationship modelling, Normalisation and indexing.
Key question:
- What are the key terms associated with databases?
00:00 Introduction to database concepts
00:14 Intro
00:19 What is a database?
00:46 From paper-based to electronic databases
01:17 Basic database concepts and terms
01:56 Flat file database
03:16 Relational database
05:08 Primary and foreign keys
06:08 Types of relationship and entity-relationship diagrams (ERD)
07:51 Relational database continued
09:10 Using indexing and secondary keys with database tables
10:21 Key question
10:33 Outro
Last updated: 08.05.26
