MySQL TutorialLesson 3Free preview

MySQL RDBMS

This lesson is part of MySQL · All levels

Summary

RDBMS (Relational Database Management System) is the foundation of MySQL: data is represented as a table consisting of rows and columns. Each table has a primary key as a unique marker, and the tables can be linked via a foreign key so that the data remains consistent. The principle of normalization also helps to reduce data duplication so that databases are more neat and easy to maintain.

Key points

Relational models store data as tables (relations) with rows (tuple) and columns (attribute)
The primary key guarantees the uniqueness of each row, while the foreign key connects one table to another table
The relationships between tables make the data quite stored once and then referenced from many places.
Normalization reduces duplication of data so that updates are more secure and consistent

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.