Database Modeling and Joins
Most databases do not store all the data in a single table, but use multiple tables. In this video, we learn that each table has a primary key, and that these tables interact with each other by using foreign keys. Then we discuss how to depict the relations between various tables, by using an entity relationship diagram. And finally we learn how to query a database with multiple tables, by joining tables together.