Ken Robertson's Blog

Ramblings of a .NET developer

Love spending my nights mending ERDs

ERD on wall

Got the go-ahead on a new project at work, which is to build an addon for another one of our products. So, since I don't know the product all that well yet, and it was becoming a pain to look over the whole ERD in Visio, I figured I'd print it out and hang it up on my wall. Fit quite nicely at 4 pages wide and 3 down. Lot easier to look at the whole thing now when I'm brainstorming.

Always wanted to have a job where I'd put big ERDs and object models on my walls. :)

Anyone guess what application the database is for? It is open source and used by quite a few people.
Posted: Aug 05 2004, 09:14 PM by qgyen | with 8 comment(s)
Filed under:

Comments

Kulin said:

umm... the asp.net forums? PK "ForumID" was the dead giveaway ;-)
# August 6, 2004 12:23 AM

Ken Robertson said:

Damn! First guess and you got it. :)
# August 6, 2004 12:25 AM

Ron K said:

Ken, you have a relationship floating in space - the one near Forum_moderationAction <hard to read>
# August 6, 2004 12:45 AM

Rajesh Singh said:

Hey Ken,
From where you have got this ASP.NET forum ER diagram??
Thanks
# August 6, 2004 3:23 AM

denny said:

Looks like it came from SQL server's print function...

it also looks like he has added relations.

I installed 2.0 the other day and just looked at the relations....

there are a *BUNCH* of tables that have no links "out-of-the-box" after installing
# August 6, 2004 9:30 AM

Brian Carroll said:

Here's a little tip...when taping ERDs together I tape from the backside. I find that it not only looks neater, it also makes it easier to write all over it.
# August 6, 2004 9:43 AM

K.E. McFeely said:

Nice tape job...you need a plotter! Or are they calling them Large-Format Printers these days?
# August 6, 2004 1:16 PM

Ken Robertson said:

Ron - The floating relationship is because I accidentially trimmed off the top of the arrow. :) Had to draw it back in.

Rajesh - I work at Telligent Systems, with Rob Howard. The ERD was a part of some of the documentation that he had. You download the source, create the DB, and use SQL Server to print it or use Visio to reverse engineer it.

Denny - I didn't add the relationships in this one. I know more work is being done on v2.0 to get it ready for www.asp.net. They might be adding tem in still. The ERD itself wasn't from SQL Server, it was in Visio. You can use Visio to reverse engineer an existing DB into an ERD. Works very nicely.
# August 6, 2004 1:48 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)