Many-to-many relationships in Flask - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a many-to-many relationship in databases?

It is a connection where multiple records in one table relate to multiple records in another table. For example, students can enroll in many courses, and courses can have many students.

beginner

How do you represent a many-to-many relationship in Flask with SQLAlchemy?

You create a helper table called an association table that holds foreign keys from both related tables. This table links the two tables without extra data.

beginner

What is the role of the association table in many-to-many relationships?

It acts like a bridge connecting two tables by storing pairs of foreign keys. It does not usually have its own data but helps link records.

intermediate

In Flask-SQLAlchemy, which argument is used to define a many-to-many relationship in a model?

The 'secondary' argument in the relationship() function points to the association table that links the two models.

beginner

Why is it important to use many-to-many relationships instead of duplicating data?

It keeps data organized and avoids repetition. This makes the database easier to maintain and faster to query.

In Flask-SQLAlchemy, what does the 'secondary' parameter in relationship() specify?

A The association table linking two models

B The primary key of the model

C The foreign key of the model

D The name of the database

The 'secondary' parameter tells SQLAlchemy which table acts as the bridge for the many-to-many relationship.

What does an association table usually contain?

A Only primary keys

B User login information

C Foreign keys from both related tables

D Application settings

An association table stores foreign keys from the two tables it connects to represent the many-to-many links.

Which of these is a real-life example of a many-to-many relationship?

A Students and courses

B Employee and employee ID

C Country and capital city

D Book and ISBN number

Students can enroll in many courses, and courses can have many students, making it many-to-many.

Why avoid duplicating data when modeling many-to-many relationships?

A To confuse users

B To make the database bigger

C To slow down queries

D To keep data consistent and easier to update

Avoiding duplication keeps data clean, consistent, and easier to maintain.

In Flask-SQLAlchemy, how do you define the association table?

A Using a function

B Using db.Table with foreign keys

C Using a class with no columns

D Using a string

The association table is defined with db.Table and includes foreign keys to the related tables.

Explain how to set up a many-to-many relationship in Flask-SQLAlchemy with an example.

Think about how two tables connect through a third table.

Why is using an association table better than duplicating data for many-to-many relationships?

Consider the problems caused by repeating the same data many times.