The+relational+model+-+an+overview

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.

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.



** Higher Extension **
Higher pupils should understand the relational model in more detail by reading //Higher Information Systems (Love, Charlie)// pp15-17

Scholar Link: [|The relational model]