One of the tools offered by pgAdmin is to create ERD projects which facilitate the creation of logical data models in the ER diagram fashion. It offers many other tools and utilities as a part of its suite of tools. Azure offers Azure Database for PostgreSQL service as its offering for hosting PostgreSQL database on Azure cloud, and pgAdmin is one of the most popular tools used for working with Postgres database. There are many industry-leading tools available commercially for ER modeling. Arguably, the entire conceptual and logical model can be represented in the form of a diagram which is famously known as the Entity-Relationship Diagram a.k.a., ERD. The next phase is the modeling process is creating the logical data model where data attributes and related details like normalization, cardinality, etc. This is the first phase in the data modeling process. When this detail is represented in any form, it becomes a conceptual data model. Then the relationship between these entities is identified. Functional subject matter experts first identify the business entities that make up the ecosystem within the scope of business being considered, for which the database is expected to host data. In this article, we will learn how to use the ERD Project feature of pgAdmin to work with an instance of Azure Database for PostgreSQL for data modeling.ĭata modeling is the process of figuring out the organization of entities and the relationships between those entities.
0 kommentar(er)
