CS50 SQL - Lecture 2 - Designing

In this episode of CS50's introduction to databases with SQL, Carter Zanke discusses database schema design, focusing on creating tables, defining columns, and specifying data types and constraints. The episode uses the example of the Massachusetts Bay Transportation Authority (MBTA) subway system to illustrate how to normalize data, create relationships between tables (such as riders and stations), and apply constraints like primary keys, foreign keys, not null, unique, check, and default. The discussion covers how to use SQL commands like CREATE TABLE, DROP TABLE, and ALTER TABLE to define and modify database schemas, and it distinguishes between storage classes and type affinities in SQLite, providing practical examples and addressing common design considerations.