If we open and analyze the Entity Relationship (ER) diagram that comes with the Sakila installation, we will notice the following tables:
Note
As a reminder, the Sakila database can be downloaded at http://dev.mysql.com/doc/index-other.html, and its documentation with installation instructions can be found at http://dev.mysql.com/doc/sakila/en/.
These tables can exist independently of the other tables, and we are going to work with them in this chapter.
When we open SQL editor in MySQL Workbench (version 6 ) (http://dev.mysql.com/downloads/workbench/), we can select a table, right-click on it, and select Select Rows – Limit 1000. When we choose this option, a new tab will be opened, and it looks as follows:
The table shown previously is the actor table. The idea is to implement screens that look similar to the preceding screenshot for each of the tables that we selected: Actors, Categories, Languages, Cities, and Countries as displayed in the following screenshot (which...