I agree with Neil/Frank
When I was at UHG
We did a Agile post-mortem with David Spann and he advocated using a massive
whiteboard in a room (which everyone has access to) detailing
core functionalities
ancillary functionalities
import/export functionalities
so as an example in our case we had 'core functionalities' defined as
Hospital Class (parent table/class)
|
-----------------------
| | |
EmergencyRoom Surgery Outpatient (child tables/classes of
Hospital)
whereas every node (table) has HospitalID embedded into the Primary Key for
to Level2 (ER, Surgery,Outpatient) classes
R.N could be resourced to ER or Surgery or Outpatient depending on Load
ER would have patients assigned HCPCS/DRG/CPT codes with constraint Not null
(so that a patient must be coded to be entered into system)
Analyst could make any changes anywhere..but if Analyst changes signed
/dated and reason why
DBA would make changes to DB structure to Analyst's changes
Project Lead would make sure changes were reflected into underlying class
with accessors/mutators in place
Basic stuff ...easy to get the picture if its on a giant whiteboard..
Martin-
----- Original Message -----
From: "Neil Aggarwal" <[EMAIL PROTECTED]>
To: "'Struts Users Mailing List'" <user@struts.apache.org>
Sent: Tuesday, October 04, 2005 12:57 AM
Subject: RE: database design
Frank:
I agree with you in that a big whiteboard is the best place for
data design.
I had an old boss that used to tell me that if you can't do it
on paper, you can't possibly hope to tell the computer how to
do it.
I think people nowadays are too impatient to design things well.
They just start hacking stuff together and hope it will all work
at the end.
I think that is why there are so many crappy systems out there.
Regarding you room - I think I would need a padded room next
to it!
Neil
--
Neil Aggarwal, JAMM Consulting, (214) 986-3533, www.JAMMConsulting.com
FREE! Valuable info on how your business can reduce operating costs by
17% or more in 6 months or less! http://newsletter.JAMMConsulting.com
-----Original Message-----
From: Frank W. Zammetti [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 11:25 PM
To: Struts Users Mailing List
Subject: Re: database design
I think the smartest thing I ever did was this...
I have an office at home... just one of the bedrooms that is my
sanctuary of geekdom... about 6 months ago we were walking
through Home
Depot... no, sorry, Lowes... we were looking for some sort of
paneling
to spruce the place up a bit.
What I found is a panel that is made out of whiteboard material. So,
picture an entire 15'x16' room (is ' or " feet? I never remember!)
where every single wall is whiteboard, floor to ceiling.
*THIS* has become *THE* way I do most of my design work.
It's great...
any time I have an idea I simply find a blank area of wall
and have at
it! I put in a chair rail around the entire room and I keep various
colored markers on it.
My only problem is keeping the kids from scribbling all over
my work :)
I don't have this at work (yet... talking to the building
manager!) but
I still find a giant whiteboard to be the best for database
design, or
any other kind of design work. Once I have a fairly solid idea where
everything is going, I usually break out Visio. As a general-purpose
diagramming tool I find it to be second to none. I can create just
about any UML diagram, flowchart or whatever else in it.
True, I can't
spit code out of it, but I don't generally like letting tools
write my
code for me anyway.
But, forget all that... go buy that paneling and pick a room! :)
Frank
Graham Reeds wrote:
> Rafael Taboada wrote:
>
>> Hi folks. When u design a database... What soft do u use??
What's the
>> best??
>> I use Embarcadero E/R... Is there any program better than
embarcadero?
>>
>> --
>> Rafael Taboada
>> Software Engineer
>>
>> Cell : +511-97753290
>>
>> "No creo en el destino pues no me gusta tener la idea de
controlar mi
>> vida"
>>
>
> I use pen, paper, and brain power:-)
>
> When the first round of requirements discussions are
complete I then use
> SQLyog (http://www.webyog.com/), MySQL Query Browser and MySQL
> Workbench. DBDesigner 4 was the old MySQL Workbench which
is getting
> rewritten from the ground up. Haven't installed DBDesigner
4 before
> since Workbench just about works for me (at least to
visualise and check
> I haven't missed any foreign keys).
>
> There is a Windoze and Mac OSX version of Workbench but no
Linux yet.
>
> G.
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
--
Frank W. Zammetti
Founder and Chief Software Architect
Omnytex Technologies
http://www.omnytex.com
AIM: fzammetti
Yahoo: fzammetti
MSN: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
