Creating the FilmsActors table in the Movies database
Complete Programming Challenge 9 before beginning this challenge. In this challenge, you will add a new table named FilmsActors to the Movies database. This table links films to actors, since one film may contain many actors, and one actor may participate in many films. Here are the columns:
Field name | Column type |
FilmId | type int (1000+) |
ActorId | type int (100+) |
When adding rows to this table, be sure you use FilmId values that match those already in the Films table, and ActorId numbers that match rows from the Actors table. Here is a sample row, for example, indicating that Keanu Reeves (ActorId = 100) was an actor in The Matrix (FilmId = 1000): 1000, 100
You will need to create a row in this table for every actor in the Actors table that acted in a film from the Films table. This information is available in online movie databases.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.