Hands-On Software Engineering with Python

Relational databases

Relational Database Management Systems (RDBMSes) are one of the more mature data storage approaches available for applications, with options that have been in common use for decades. They typically store data as individual records (sometimes called rows) in tables (or relations) that define field names (columns) and types for all member records. Tables often define a primary key field that provides a unique identifier for each record in the table. A simple example of a table that defines user records might resemble the following:

Each record in a table is, then, a consistent structure of data—all users in the preceding ...