SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Modeling relational databases


Modeling relational databases

Author
Message
river1
river1
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10255 Visits: 1680
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?
Greg Roberts-134214
Greg Roberts-134214
Say Hey Kid
Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)

Group: General Forum Members
Points: 702 Visits: 328
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. :-D




Greg Roberts
dmoldovan
dmoldovan
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2982 Visits: 1499
Database models are useful even if you work in a small shop. And not only for auditing purposes :-)
river1
river1
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10255 Visits: 1680
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?
dmoldovan
dmoldovan
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2982 Visits: 1499
MS Visio
river1
river1
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10255 Visits: 1680
does Erwin help people that have some difficulties in modeling? Does it point you in the right way when you do mistakes?
river1
river1
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10255 Visits: 1680
you say that you model and then pass it to visio.

Do you make the ERD model?
Greg Roberts-134214
Greg Roberts-134214
Say Hey Kid
Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)

Group: General Forum Members
Points: 702 Visits: 328
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
marvin.elder
marvin.elder
SSC-Enthusiastic
SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)

Group: General Forum Members
Points: 115 Visits: 36
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.
TheSQLGuru
TheSQLGuru
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69528 Visits: 8844
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 on googles mail service
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search