In this stage, we will convert the logical data model into the physical data model of the target RDBMS. As mentioned, we will use MySQL and will create the physical data model using MySQL Workbench.
Here is what we are going to do:
- Create a table for each entity.
- Create a column for each attribute. Besides the name, we will define columns type, length, nullability, and default value.
- Make primary keys auto increment.
- Create indexes.