Creating the Actors Table in the Movies DatabaseTutorial 10-14 showed how to create the Mo...

Creating the Actors Table in the Movies Database

Tutorial 10-14 showed how to create the Movies database and insert a table named Films. You may have noticed that the Films table did not contain the names of actors. It certainly would not be practical to add a list of actor names to the Films table, since the number of actors varies between films, and we might accidentally misspell an actor’s name when typing it so many times! Instead, you will create a new table named Actors that holds the names and IDs of actors. Here are the table columns:

Using an online movie database, you can look up names of actors that appeared in the films currently contained in our Films table. Here’s a sample row, for example, that could be inserted into the Actors table, because he was an actor in The Matrix:

100, Reeves, Keanu

Add at least 10 rows to this table.