How does a many-to-many relationship affect the database schema?

It doesn't impact the schema
It eliminates the need for foreign keys
It requires the use of a junction table
It simplifies the schema structure

A many-to-many relationship affects the database schema by necessitating the use of a junction table. This table resolves the complexity of such relationships by breaking them down into two one-to-many relationships, linking the original entities through an intermediary table.

Add your answer