You're tasked with implementing a many-to-many relationship between two tables in a database. How would you achieve this using SQL?
- Create a Junction Table
- Use Foreign Keys and Triggers
- Implement Subqueries
- Utilize Views and Stored Procedures
To implement a many-to-many relationship in a database, creating a Junction Table is a common approach. This involves creating a separate table to represent the relationship between the two entities. The correct option suggests using a Junction Table.
Loading...
Related Quiz
- What does OAuth primarily focus on in terms of user authorization?
- What are access specifiers in OOP languages such as Java and C++?
- Enabling _______ compression can reduce the size of files transferred over the network, improving overall performance.
- What does SQL stand for?
- What is a potential drawback of using a centralized version control system compared to a distributed one like Git in terms of branching and merging?