ER Diagrams

How To Draw ER Diagram Using ChatGPT

Level Up Coding 89d17f39527cdf9dab61a8192b43a261324dac3d_0

In this story, you’ll be learning all about entity relationship diagrams or ERDs. we are going to start off by discussing a high-level overview. and then together we’ll dive in and build an example to...

Step-by-Step Design of Enhanced Entity-Relationship (EER) in MySQL

Towards AI ca77fdb412f3dbef175e897465dda6326820087d_0

This article will give a clear understanding of the visual representation of tables that are related to each other. EER is a modeling interface in MySQL workbench. In this example, we will make three…...

Entity-Resolved Knowledge Graphs

Towards Data Science 064be3d7d0ca142bad6c57952266bb2f12a6ac57_0

New words. Old concepts. In the end, it’s about data fusion. Entity resolution is a process. A knowledge graph is a technical artifact. And the combination of the two yields one of the most powerful ...

ERD — how to save up to 80% of database refactoring and ERD for Medium

Python in Plain English efd5d493b58ade173e7149caa6ede59501a9cb28_0

ERD — how to save up to 80% of database refactoring and practical example of ERD for Medium Changes in a database very often are painful. It can be just a small change of one field type or major data...

Constructing the Hertzsprung-Russell Diagram

R-bloggers 7ae414159b722d134ba5599a93d336c91fd2f71c_0

Recreating the Hertzsprung-Russell Diagram in R For a few Fridays each year, I teach a course in the American Museum of Natural History’s Masters of Arts in Teaching program to apply and continue thin...

What is an Entity-Relationship Diagram?

Better Programming bac15d4d5afb58aa560fa58d00c96c72d70218f4_0

Programmers often have to deal with big databases. It doesn’t matter what kind of coding language we’re using, there will always be information that we need to store in the backend of our…

Practical Guide to Entity Resolution — part 1

Towards Data Science f92c12cc45549bda5c0de88b2ac5825316a54dbf_0

Entity resolution (ER) is the process of creating systematic linkage between disparate data records that represent the same thing in reality, in the absence of a join key. For example, say you have a…...

Open Source Showcase: Diagrams

Analytics Vidhya 618d89852217e7f59b1432e49a5b55702a6662bb_0

An important piece of every software engineer project are Solution Architecture (SA) diagrams. Not only do they act as efficient, concise, and abstract representations of the code but they also are…

Venn Diagram: A Not So Common Visualization Tool

Towards Data Science 5d8722df8d1960fe297e9eb601090310e2590d50_0

A Venn diagram is a schematic representation of all the possible relationships (union, intersection, difference, symmetric difference) of several subsets of a universal set. Venn diagrams (sometimes…

Easy-to-generate diagrams for data engineers

Level Up Coding 755913d507e99c7ec79383b495ae3a71be55e43e_0

There are instances when diagrams are very powerful and useful, but at the same time annoying or extremely hard to create. When working as a data/software engineer you don’t want to go to PowerPoint…

Generate database documentation

Analytics Vidhya ede18e146828a0cb805085859467a693ec21e6c6_0

ERBuilder is a data modeling tool that also allows the documentation of databases, describes each object of the data model and generates an HTML documentation report...

Practical Guide to Entity Resolution — part 3

Towards Data Science ad13e91bc304c88fff98b349eaaad00dc458566f_0

In the context of ER, featurization means transforming existing columns into derived features that can inform whether disparate records refer to the same thing. Blocking means selecting a targeted…