Computer Science

Senior High

Preview

Imagine a shop that writes every sale on paper: the customer's name, phone number, address and what they bought. A loyal customer who buys fifty times has their address written fifty times, and if they move house, all fifty entries are wrong. A relational database fixes this by storing each fact once, in the right table, and linking the tables together. This note explains how.

NotesFree

The Relational Database Model: Tables, Keys and Relationships

Topic: Y2-3 Relational database model

How relational databases organise data, explained step by step: why they matter for e-commerce, tables, fields and records, entities and attributes, one-to-many and many-to-many relationships, primary, foreign and composite keys; creating a database and tables in MySQL with XAMPP and phpMyAdmin, data types, and querying.

View resource Free to join

More on Relational database model

Other resources you can find on TudHub.

The Relational Database Model: Tables, Keys and Relationships (Computer Science) · TudHub