Computer Science
Senior High
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.
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.
More on Relational database model
Other resources you can find on TudHub.