Produce a SQL query to form a junction table called movies_actors . A junction table is
Fantastic news! We've Found the answer you've been seeking!
Question:
Produce a SQL query to form a junction table called "movies_actors". A junction table is basically a table that contains foreign keys of different tables together so that they form transaction table. This table have 2 variables only (movie_id and actor_id). The features of these variables (that should be considered while creating these variables) are provided below. As can be seen, a sample is given (below) from the "movies_actors" table.
- movie_id isnumeric that has the "integer" typing and is a foreign key that should be referenced to the movie_id from the movies table.
- actor_id isnumeric that has the "integer" typing and is a foreign key that should be referenced to the actor_id from the actors table.
- Finally, note that both columns are the primary keys of this newly created table.
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date: