Re: Please Help! Workflow Management System E-R Diagram, Relational Database Design.

TalentSoft wrote: > > We are in the process of designing a generic web-based workflow management > system prototype. We have studied numerous workflow books, white papers, > and the Workflow Management Coalition's Workflow Reference Model. We have > read about many high level design concepts, such as the event trigger > model, SAP's EPC (event driven process chain) model, etc. However we have > not found any published information on exactly how to translate the > high-level model into a Entity-Relationship model, and eventually into a > relational database design. > > If you have any experience in the database modelling for a generic workflow > management system and are willing to share with us, we'd appreciate it very > much. Thank you in advance. > > Victor Tong, Brian H. > TalentSoft - Talent Information Management, LLC. > Headquarters: 900 Nicollet Mall Suite 700, Minneapolis, MN 55402,USA. > Mailing Address: PO Box 2997, Minneapolis, MN 55402-0997, USA. > Telephone: (612) 338-8900 > Fax: (612) 904-0010 > E-mail: Info@TalentSoft.Com > Web: http://www.talentsoft.com You might take a look at the book "Data Model Patterns: Conventions of Thought" by David Hay. It describes database model patterns for modelling various aspects of businesses. Martin Fowler also has a similar book but I don't recall the title. Hope this helps. ----------- Roger Tomas AG Communication Systems