Introduction to Relational Databases

This chapter provides an overview of relational database systems, covering core terminology and fundamental concepts.

Acknowledgements

The author consulted the following resources when building out this chapter:

• W3 Schools “SQL Syntax”

• Library Carpentry “Database Design”

• Library Carpentry “SQL”

Peer review and editing was provided by Spring 2021 graduate teaching assistants Aidan Draper, Eric Tsai Sahoo & Subhadyuti Sahoo.

Chapter Table of Contents

• From Table To Database
• Terminology
• Entity Relationship Diagrams
• Relational Schema
• Application

Data

This chapter will work with four tables. Link to access via Google Drive

• transactions

• players

• teams

• locations

You can copy the project to your own Drive workspace and/or download individual sheets as .csv files.

Application

Click here for a Google Doc template for this chapter’s application problems.