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 Check out the following journal article on ER modeling: (1) Batra and Zanakis (1994) A Conceptual database design approach based on rules and heuristics. European Journal of Information Systems, Vol 3 pp 228-239 For conversion of ERD to relations (2) Teorey, Yang and Fry (1986). A logical design methodology for relational databases using the extended entity relationship model. ACM COmputing Surveys. VOl 18 No. 2, pp 197-222. -- Solomon Antony