Clever Geek Handbook

Chart for modeling database records

Do you know a diagram showing database records? I think something like an object diagram in UML. I know there is an entity relationship model, but it does not map existing database records.

+2


source to share


2 answers


I guess it is quite rare to show database records in a diagram because there are usually too many of them.

And in fact, it could be a business-oriented diagram, you can think of any database application as a form of such a "diagram", displaying database records in a user-friendly way.



Another way of making such a chart is to use some variation of the ER chart, but display the data instead of the chart, for example in this wikipedia article .

Show the data instead of the schema

+3


source


Jacoder mentioned ER diagrams. This is a good place to start. ER diagrams are simpler than UML diagrams. I've seen ER diagrams with over a hundred boxes and even more lines between boxes. The paper covers the entire wall.



If you think this is too complicated, it is still easier to understand a hundred tables than a hundred thousand lines of code.

0


source






More articles:


All Articles