erd

Database design for dynamic form field validation

In my application, I allow users to create a form containing any HTML form field they want (e.g. text input, textarea, select, etc.). I want to give the users the ability to define 0 or more cumulative validation rules for each field (there might be up to 25 different validation rules). How should I model this? Here's a potential soluti...

2 XML Imports - Database design

SQL Server 2008. Morning, If someone could offer their advice it would be very much appreciated. Currently I’m looking to import two XML files, Donation amount and Donation Maker. The Donation Amount file would comprise of an Amount field and a DonationMakerID, and the Donation Maker file would comprise of a Name field and Donation...

Text to ERD tool

I'm looking for a tool that allows me to create Database ERDs via text in similar way that http://www.websequencediagrams.com/ allows for creating sequence diagrams. ...

ERD diagram and SQL relationships linking user, project and dataset tables.

Hi guys, I have several tables in my ERD which which I would like to combine in a relational manner. I have several use cases, but I completely lost track of what kind of relations to use between the tables. Every user can work on multiple projects. Every user has one specific role per project (Manager, Contributor, User) Every proje...