Data Modeling

How does data modeling work?

Let’s take a look at the following diagram. This is something we’ll need to understand very well.

The above diagram explains the following:

• An RDBM server can manage multiple databases at the same time.

• Each database contains one or more tables. A database with no tables is useless.

• Each table contains one or more columns. A table without columns is useless too.

• There are relationships between the tables of a database. That is why we call this system a relational database management system.

Let’s see an example of the above.

In the above example, we have one RDBMS managing the following two databases:

• customer_management_db
• reporting_db

Each database has its tables: ...