<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Modeling relational databases
12 posts, Page 1 of 2
1
2
»»
Modeling relational databases
Rate Topic
Display Mode
Topic Options
Author
Message
river1
river1
Posted Monday, May 10, 2010 1:24 PM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
Hi,
At the company we are being Audited by some entity...
This entity is asking for the ERD Model of each database.
When we develop the databases we do it directly in relational form, not first in ERD model and only then pass it to relational.
What are you guys doing?
Do you use ERD model first?
Is it wrong no to have a ERD model of each database?
We just have the SQL Server Diagram of each DB.
Can you please help?
What are you using to model and to present your relational database models to clients?
Post #919270
Greg Roberts-134214
Greg Roberts-134214
Posted Monday, May 10, 2010 3:55 PM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, May 20, 2013 9:12 AM
Points: 88,
Visits: 257
When I started here the first thing I did was model the DB, as one did not exist. Fortunately we have Visio 2007, and I was able to reverse engineer the DB. That atleast got the tables and views for me. And it made our auditors happy when they came thru.
ERWin is probably the class of the field, but it can be expensive.
Regarding development process, it's a coin flip. A small shop can get away with creating the objects as you go. but once more than 3 people have to develop in the DB, a model is worth its weight in gold. Easy reference when writing queries because your relationships are visible. And when new objects are created it allows the entire team to know what to expect. My preference? Model 1st.
Just my .02 worth.
Greg Roberts
Post #919346
dmoldovan
dmoldovan
Posted Tuesday, May 11, 2010 3:50 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 360,
Visits: 1,261
Database models are useful even if you work in a small shop. And not only for auditing purposes
Post #919547
river1
river1
Posted Tuesday, May 11, 2010 3:52 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
Do you guys use Erwin to model? or other tool? or make every think in paper (work, etc..) and pas it to visio?
My question is, do you have help from a modeling tool like Erwin? or do you make by your own?
Post #919549
dmoldovan
dmoldovan
Posted Tuesday, May 11, 2010 4:38 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 360,
Visits: 1,261
MS Visio
Post #919569
river1
river1
Posted Tuesday, May 11, 2010 5:00 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
does Erwin help people that have some difficulties in modeling? Does it point you in the right way when you do mistakes?
Post #919574
river1
river1
Posted Tuesday, May 11, 2010 5:01 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
you say that you model and then pass it to visio.
Do you make the ERD model?
Post #919575
Greg Roberts-134214
Greg Roberts-134214
Posted Tuesday, May 11, 2010 9:05 AM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, May 20, 2013 9:12 AM
Points: 88,
Visits: 257
I reverse engineered the database using Visio's built in tools. Then as changes are developed they are first added to the model.
Greg Roberts
Post #919766
marvin.elder
marvin.elder
Posted Thursday, June 30, 2011 3:57 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, January 21, 2013 1:51 PM
Points: 6,
Visits: 33
The auditing entity is asking for an ERD, or Entity Relationship Diagram. In database modeling terms, an ERD represents a Conceptual Model (this is the highest level in a three-level 'schema architecture', followed by a Logical Model and lastly by a Physical Model). Sql Server and other RDBMS's have a "Relationship" feature which can reverse engineer the database into its Physical database model, but this can usually suffice as both the Logical Model and the conceptual ERD. At the Concept Model level, "Entities" represent the database tables and "Attributes" represent columns in a Logical Model. ERDs allow naming the tables and columns with friendly names (e.g., "Last Name" instead of "LName", "Customer" instead of "tblCUST", etc.). The best database modeling tool, in my professional opinion, is Embarcadero's ER/Studio. Better (and less expensive) than ER/Win.
You should probably send the auditors your Sql Server Relationship Diagram: that should suffice.
Post #1134312
TheSQLGuru
TheSQLGuru
Posted Friday, July 01, 2011 12:37 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 3,581,
Visits: 5,123
I think ERStudio from Embarcadero is WAY better for SQL Server modelling. Much better pricing too.
But for what this OP needs, I would just slap something together for the auditors using Visio if you have it or even the modelling tool from within SSMS. No need to pay money for nebulous external requirements.
I DO think it is valuable to have a good ERD and good ERD tool, however!!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1135301
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
