Table relationships in Supabase - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a table relationship in a database?

A table relationship connects two tables so they can share related data, like linking a list of orders to the customers who made them.

beginner

What is a foreign key in table relationships?

A foreign key is a column in one table that points to the primary key in another table, helping link related data between tables.

intermediate

Explain the difference between one-to-many and many-to-many relationships.

One-to-many means one record in a table relates to many records in another (like one customer has many orders). Many-to-many means records in both tables can relate to many records in the other (like students and classes).

beginner

How does Supabase help manage table relationships?

Supabase lets you define foreign keys and use its interface or SQL to create relationships, making it easy to connect tables and query related data.

beginner

Why are table relationships important in cloud databases?

They keep data organized and connected, reduce duplication, and make it easier to retrieve related information quickly and accurately.

What does a foreign key do in a table relationship?

A Links a record in one table to a record in another table

B Stores large files in the database

C Creates a backup of the table

D Deletes duplicate records automatically

A foreign key connects one table's record to another table's record, establishing a relationship.

Which relationship type means one record relates to many records in another table?

A One-to-one

B Many-to-many

C One-to-many

D No relationship

One-to-many means one record in a table connects to many records in another table.

In Supabase, how can you create a table relationship?

A By defining a foreign key between tables

B By uploading CSV files

C By changing the database password

D By deleting tables

Defining foreign keys is how you create relationships between tables in Supabase.

Why are table relationships useful?

A They remove all data duplication automatically

B They increase the size of the database

C They slow down queries

D They help organize and connect data efficiently

Table relationships organize data and connect related information for efficient use.

What is a many-to-many relationship example?

A One product belongs to one category

B Students enroll in many classes, and classes have many students

C One customer has many orders

D One employee has one ID

Many-to-many means both sides can have many related records, like students and classes.

Describe how foreign keys create relationships between tables in Supabase.

Think about how one table points to another.

Explain the difference between one-to-many and many-to-many relationships with examples.

Use simple real-life examples to compare.