Jump to content
Sign in to follow this  
Tokyo-B

How can I make an ERD? (Mac or Win OK)

Recommended Posts

Does anyone know of a good tool for creating ERD's (Entity Relationship Diagrams) for FMP db's? I would prefer it to be on Win, bit MAC is OK as long as I can have a tool to do this. Visio can do it for SQL, I believe, and Access has this feature built in.

Appreciated.

Share this post


Link to post
Share on other sites

Waves In Motion has a Mac-only tool called "Visualizer 1.0", which can create ER-diagrams from existing FMP databases.

I haven't tested the software myself, but judging from the screenshots (www.wmotion.com/visualizer) it looks sufficient only for small projects (maybe < 10-15 related files). I don't know how much you can "tailor" the ER "bubbles" either.

One thing that makes it so hard to write a program that create ER-diagrams from existing FMP databases is that relationships in FileMaker is not the same as relationships in Relational Database Theory (or "joins" in SQL). A FileMaker "relationsship" can be used for many other purposes than just maintaining connections and referential integrity between files. For example, self-joins for display purposes, constant relationships for data transfer, and there are many more uses for a FileMaker "relationship". So, how would the program know what is supposed to be "real" relationships, and which are not (there is no automated way of doing this).

In a traditional ER-diagram, you might use "Crow's feet" to indicate the multiplicity of a relationship (e.g. one-to-many, one-to-one, zero-to-many,...) and write other business rules that apply to them.

I've used Visio 2000 for creating ER-diagrams, and although you can get quite good results in the end, it takes a loooong time to create them, and to keep them updated, since you cannot get it to interact with FMP. If someone finds a software that is better, please let me know!

Good luck!

/Daniel

crazy.gif" border="0

Share this post


Link to post
Share on other sites

Thanks, I did find Waves in Motion and will take a look at Visualizer.

Inspiration is cross platform and good for laying out flow idea. I also use Visio 2002, but Inspiration is easy to draft up quickly.

Cheers,

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.