However if the database system needs less rules in the structure and more as constraints to allow changing rules later on without re-developing applications, a simple lexicalization will do. This will not optimize the structure but will add all rules as database constraints.

 

Note that the structure will be a column oriented database structure.

It will look like this:

alt

 

watering-plant.png

Idera ER/StudioPowerDesigner-logoMicrosoft SQL Server Logooracle logods-firebird-logo-1000interbase-logopostgresql logomysql-logoSQLite-logoDenodo Logomsaccessrdf w3cjsonschemaXML Schema Definitionumlteradatamongodb