Understanding Relationship Tables3:41 with Alena Holligan
A relational database is all about relationships. When talking about relationships within a database, there are three types of relationship.
2. Many-to-one (also used One-to-many)
Learn More About Relational Databases
A many-to-one relationship can also be referred to as a one-to-many depending on how you are referencing the relationship. Genre_id in our Media table links to a genre table which includes a genre_id and the genre. This is a Many-to-one relationship. Many media items link to one genre. We could also say that One genre has Many media items using a One-to-Many relationship.
You need to sign up for Treehouse in order to download course files.Sign up