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

How about getting some software that has workflow and using something like ERWin to translate their database to an ER for you. Documentum has a decent workflow model. I can't send you a model through our firewall, but I think there are plenty of modelers out there who could do this. route table task table sendto table, start, stop, reroute, add to route, when received, finished receiving, before receive event, after receive event, whole lot of good stuff. Another idea would be to check out OCX's designed to help create workflows. They may already have a database model in a sample. Good luck, Tim TalentSoft <info@TalentSoft.com> wrote in article <01bc8cd1$4fdcdfa0$652e5fcf@tonytong>... > 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 > >