Introduction+to+relational+databases

Introduction
As we have seen, the flat-file database can cause data anomalies.

A better approach to database design is known as the [|Relational Database Model]. In the relational model, the data is stored in multiple tables or relations. These tables are known as **linked tables**.

Let's consider our pupil-teacher example again. Instead of a single flat file, use a relational database to store the data in 2 separate tables.



Relational databases - video
media type="youtube" key="ia4eCxPPc_o" width="560" height="315"