Relational Databases

The relational database is one of the most common methods of storing large amounts of complex data. Beyond just storing data, a relational database organizes data and creates a structured way of retrieving the portion of the data you need. Relational databases are not terribly flexible, so you need to spend time planning and designing your database before you dive into building it. To make these abstract concepts more concrete, let’s go through an exercise in which we design a database for a library.

Tables

As with the data structures we used before, a database is used to model something in the real world. We will be modeling a library here, so we need to consider what entities in a library we should include in our model. ...

Get Learning to Program 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.