If we open and analyze the ER (Entity Relationship) diagram that comes with the Sakila installation, we will notice the following tables:
These tables can exist independently of the other tables, and we are going to work with them in this chapter.
When we open the SQL Editor in MySQL Workbench, we can select a table; right-click on it and select Edit Table Data. When we choose this option, a new tab will be opened and it looks like the following:
The preceding table is the actor
table. The idea is to implement screens that look like the preceding screenshot for each of the tables that we selected: Actors
, Categories
, Languages
, Cities
, and Countries
as displayed in the following screenshot (which is the final result of the code that we will be implementing in this chapter):
Our goal in this chapter is to minimize the amount of code to implement these five screens. This means that we want to create the most generic code possible, which will facilitate future code fixes,...