mysql> select * from actor; +----------+-----------+ | movie_id | person_id | +----------+-----------+ | 1 | 1 | | 2 | 3 | | 3 | 4 | | 3 | 5 | | 4 | 6 | | 5 | 7 | | 6 | 8 | | 7 | 9 | | 8 | 5 | | 9 | 10 | | 10 | 11 | +----------+-----------+ 11 rows in set (0.00 sec) mysql> select * from borrow; Empty set (0.00 sec) mysql> select * from director; +----------+-----------+ | movie_id | person_id | +----------+-----------+ | 1 | 12 | | 2 | 2 | | 3 | 13 | | 4 | 14 | | 5 | 15 | | 6 | 16 | | 6 | 17 | | 7 | 18 | | 8 | 19 | | 9 | 20 | | 10 | 21 | +----------+-----------+ 11 rows in set (0.00 sec) mysql> select * from genre; +----+--------------+---------------------+ | id | name | description | +----+--------------+---------------------+ | 1 | Sci-Fi | Science Fiction | | 2 | Action | Action | | 3 | Family | Family | | 4 | Classic Geek | Classic Geeky Films | | 5 | Comedy | Comedy | +----+--------------+---------------------+ 5 rows in set (0.00 sec) mysql> select * from movie; +----+----------------------------------+---------------------+-----------+ | id | title | acquired | borrow_id | +----+----------------------------------+---------------------+-----------+ | 1 | Hackers | 2011-02-20 11:55:37 | NULL | | 2 | 2001: A Space Odyssey | 2011-02-20 11:55:37 | NULL | | 3 | Ghostbusters | 2011-02-20 11:55:37 | NULL | | 4 | Star Wars Episode IV: A New Hope | 2011-02-20 11:55:37 | NULL | | 5 | Wall-E | 2011-02-20 11:55:37 | NULL | | 6 | The Matrix | 2011-02-20 11:55:37 | NULL | | 7 | Back To The Future | 2011-02-20 11:55:37 | NULL | | 8 | The Blues Brothers | 2011-02-20 11:55:37 | NULL | | 9 | Tron | 2011-02-20 11:55:37 | NULL | | 10 | Total Recall | 2011-02-20 11:55:37 | NULL | +----+----------------------------------+---------------------+-----------+ 10 rows in set (0.00 sec) mysql> select * from moviegenre; +----------+----------+ | movie_id | genre_id | +----------+----------+ | 1 | 4 | | 2 | 1 | | 2 | 4 | | 3 | 1 | | 3 | 3 | | 3 | 4 | | 3 | 5 | | 4 | 1 | | 4 | 2 | | 4 | 4 | | 5 | 3 | | 5 | 5 | | 6 | 1 | | 6 | 2 | | 6 | 4 | | 7 | 1 | | 7 | 4 | | 7 | 5 | | 8 | 3 | | 8 | 5 | | 9 | 1 | | 9 | 4 | | 10 | 1 | | 10 | 2 | | 10 | 4 | +----------+----------+ 25 rows in set (0.00 sec) mysql> select * from person; +----+----------+--------+----------------+--------+ | id | first | middle | last | suffix | +----+----------+--------+----------------+--------+ | 1 | Angelina | NULL | Jolie | NULL | | 2 | Stanley | NULL | Kubrick | NULL | | 3 | Keir | NULL | Dullea | NULL | | 4 | Bill | NULL | Murray | NULL | | 5 | Dan | NULL | Aykroyd | NULL | | 6 | Mark | NULL | Hamill | NULL | | 7 | Ben | NULL | Burtt | NULL | | 8 | Keanu | NULL | Reeves | NULL | | 9 | Michael | J | Fox | NULL | | 10 | Jeff | NULL | Bridges | NULL | | 11 | Arnold | NULL | Schwarzenegger | NULL | | 12 | Iain | NULL | Softley | NULL | | 13 | Ivan | NULL | Reitman | NULL | | 14 | George | NULL | Lucas | NULL | | 15 | Andrew | NULL | Stanton | NULL | | 16 | Andy | NULL | Wachowski | NULL | | 17 | Lana | NULL | Wachowski | NULL | | 18 | Robert | NULL | Zemeckis | NULL | | 19 | John | NULL | Landis | NULL | | 20 | Steven | NULL | Lisberger | NULL | | 21 | Paul | NULL | Verhoeven | NULL | +----+----------+--------+----------------+--------+ 21 rows in set (0.00 sec)