Relational Database Management

SQL is the language in which one “speaks” relational database. But just what is a relational database management system?

All database management systems store and manipulate information. The relational approach to database management is based on a mathematical model that includes formidable-sounding components such as relational algebra and relational calculus. Most working definitions of relational database management, however, rely on descriptions and functional specifications rather than on theoretical precision.

Relational expert C. J. Date gives this informal definition of a relational database management system, or DBMS:

  • It represents all information in the database as tables.

  • It supports the three relational ...

Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.