CODEWITHSUNDEEP
sqldatabase-designdata-modelingerd
cowabunga1984
cowabunga1984

Reputation: 75

Diagram to model database entries

Do you know a diagram to show the entries of an database? I guess something like the object diagram in UML. I know there is the entity-relationship model but it does not show the existing entries of the database.

Upvotes: 2

Views: 688

Answers (2)

Walter Mitty
Walter Mitty

Reputation: 18940

Yacoder mentioned ER diagrams. That's a good place to start. ER diagrams are simpler than UML diagrams. I've seen ER diagrams with well over a hundred boxes, and way more lines between boxes. The paper covers an entire wall.

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

Upvotes: 0

Massimiliano
Massimiliano

Reputation: 16980

I guess it's pretty much uncommon to show database entries in a diagram, because there are usually way too many of them.

And actually, it can be a business-specific diagram, you can think of any DB-based application as a form of such "diagram", showing database entries in a way comfortable to the user.

Another way of making up such diagram is to use some variation of the E-R diagram, but show the data instead of the schema, like in this wikipedia article.

Show the data instead of the schema

Upvotes: 3

Related Questions