> Do you have a suggestion how one could document this type of > data model? I've since learned I may be making more of an 'data > model|diagram' rather then an entity relationship diagram even though > that is what Visio wants to call it. > > I am trying to create documentation that shows how one ties all these > tables together to create queries when wants 'all the records for > Sacramento County where pesticide XYZ was used between 1975 > and 2006' > This would involve invoking the relationship with these Pesticide Use > (PUR) tables with the normally associated tables of Products and > Chemicals and Counties. But it also involves knowing how all these > versions of the PUR tables are constructed and how that has > changed from version to version.
There's really nothing you can do with diagramming tools here. I suggest you write documentation just using text in this case, and maybe provide some sample queries or views. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
