My NORMA 2010-12 for VS 2008 generates excellent normalized MySQL code except for one thing.
My model contains an entity that plays no roles but its reference scheme. This for the sake of compactness of the model: later it probably will play more roles, but for now, the number is enough.
As a result this entity is absorbed into the table of another entity. The table now contains to entities with an autoincrement column and MySQL cannot handle this, so it doesn't take the code until the autoincrement property is removed. Or the entity is made independent.
My questions are: Is this conceptually incorrect (the fact that it plays no roles but its ref mode)?
Or is it just due to MySQL's limited set of features?
And of course it would be nice if an error message or different generation would catch this condition.
Apart from this, the real-time code generation works fine for me and I've use it quite a bit for the static part of the data model.