Physical data modeling for RDBMS

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.

The naming convention

The naming convention of the physical data model has some differences with the naming convention of the logical data model:

• We will use lowercase for tables, columns, and indexes, for example, the user table. And we will use underscore to connect multiple words, for example, the card_list table.
• For foreign key definition, the key's name starts with fk_. The naming convention of the foreign keys is fk_<referencing table name>_<referenced table name>_<referencing field name>. For example, the foreign...