Data Modeling
Explore how data modeling organizes tables, columns, and relationships within relational databases. Understand the structure of databases managed by an RDBMS and how tables represent business entities with attributes. This lesson helps you grasp key concepts essential for designing efficient databases using SQL and MySQL.
We'll cover the following...
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_dbreporting_db
Each database has its tables: ...