1. Understanding Concepts


Introduction to Databases - Concepts

Introduction to Databases



Why do we use a Database?

Why have a database?


Relational Databases - What is a Relationship?

Defining table relationships



Relational Database Explanatory Video 1

Database Fundamentals





Database Schematic Diagram or Schema

Schema shows the organisational structure of a database. It should show the entities (the tables in the database), and their characteristics (ie their properties/attributes/fields). It should clearly identify the primary key in each table and the links and relationships between tables. 

Primary Key is a grouping or arrangement of characters (letter, numbers etc) which is used to identify a unique record in a database.

Foreign Key is a field in a relational table that matches the primary key column of another table. This foreign key can be used to cross-reference tables.

Relational Database Explanatory Video 2

Relational Database Concepts