I agree. These are probably permanently deferred constraints :->. The PK
issue ties into that. Either they were not motivated to preserve data
quality or simply were clueless on relational theory.
I've had on occation to write nightly batch programs that do missing
validation and mail the results to managers who I nominated as "data
owners". It worked (but I'm a contractor) but didn't make me popular.
/Aaron
----- Original Message -----
From: "Schlieper, Paul" <paul.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, March 25, 2004 2:37 PM
Subject: RE: Entity Relationship Diagram
I have heard of developers requesting DBAs drop referential constraints so
they (developers) wouldn't have to handle these pesky constraints in their
code.
So let's see, no referential integrity in the application (which IMHO is not
enough anyway), none on the back end, either. We're supposed to just take
their word?
One of my developers tried that here once too. I told him he'd better handle
it, because I wasn't dropping FKs for the sake of convenience.
Same guy saw no problem having tables with every column defined NULL except
the identity column. No, really, I'm not joking.
Still shaking my head in disbelief...
As for not using PKs, I can't begin to get my mind around that one...unless
they're all 1 row tables.
P
-----Original Message-----
From: Horton, Joe (LNI) [mailto:[Email Address Removed] Thursday, March 25, 2004 2:00 PM
To: LazyDBA.com Discussion
Subject: RE: Entity Relationship Diagram
Ah - but what makes my task really suck - is the contractors who developed
this 300 SP, 100 tables, 50 views, etc - decided there was no need to use
primary keys nor foreign keys - so there is no tool that will build the
entity relationships.
Can someone tell me why a group of recent developers would think it better
not to use PK and FK when developing a rather large complex system? I can't
really think of any.
__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Thursday, March 25, 2004 10:47 AM
To: Horton, Joe (LNI); [Email Address Removed] RE: Entity Relationship Diagram
Quite welcome..Sorry I couldn't be of help...
-----Original Message-----
From: Horton, Joe (LNI) [mailto:[Email Address Removed] Thursday, March 25, 2004 1:33 PM
To: LazyDBA.com Discussion
Subject: RE: Entity Relationship Diagram
Nevermind - yes Visio does have reverse engineering options - thanks!
__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200
-----Original Message-----
From: Horton, Joe (LNI)
Sent: Thursday, March 25, 2004 10:28 AM
To: LazyDBA.com Discussion
Subject: RE: Entity Relationship Diagram
But wouldn't I have to manually draw the relationships? I thought there
would be some tools out there to reverse engineer my DB.
__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200
-----Original Message-----
From: Kristina Carlton [mailto:[Email Address Removed] Thursday, March 25, 2004 10:26 AM
To: Horton, Joe (LNI)
Subject: Re: Entity Relationship Diagram
Have you tried Visio Professional?
----- Original Message -----
From: "Horton, Joe (LNI)" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, March 25, 2004 12:17 PM
Subject: Entity Relationship Diagram
> I am tasked with printing a database diagram or ERD and am unsure the best
> tool to use to create it. I've been playing with the EM Diagram tool but
> can't seem to get it to show the entity relationships.
>
> Any suggestions of tools?
>
> __________________________
> Joe Horton
> Database Developer / Software Engineer
> WISHA/Legal Services Software Development
> Department of Labor and Industries
> Voice (360) 902-5928 fax (360) 902-6200
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page