SQL for Data Analytics · Reading database designs
Reading database designs
An entity relationship diagram shows the structure of a whole database at once: every table, every column, and how the tables connect. This unit is about reading those diagrams and writing queries from them.
The unit uses two databases you haven't seen yet. The HR database is about a company's employees, their jobs, and their departments. The college database has Green River's real software development classes and instructors, as of October 2026. The students, their enrollments, and their GPAs are made up.
The lessons:
- Diagram structure (10 min). How a diagram shows tables, columns, and primary keys.
- Reading relationships (15 min). Reading the lines between tables, and how they match up with foreign keys.
- Types and nullability (15 min). What a column's data type tells you, and which columns can be NULL.
- Queries from diagrams (15 min). Using a diagram to find the tables and joins a query needs.
When you've finished the lessons, do the Practice. It's fifteen questions in two parts: nine questions about reading the diagrams, then six queries to write from them. This is what you turn in on Canvas.