My excercise is growing so complicated that I loose oversight. Question is there a software to plan a complete database application (tables, relationship, fields, forms, menus)? Just downloaded yED for Linux but have yet to install and evaluate. Or how would you do it?
The objective is to develop a database application for orthopaedic workshops from the view of the user. This is in order to work effectively as many of us are not computer-experts, even lacking fast internet access.
The result will not be for real use but to show a programmer what a user might want to. E.g. a programmer will no know that in order to create a estimate of cost we will have to use a measuring chart. To demonstrate workflow and data required is the objective, it is then much easier to code it.
If it has commercial potential it might be developed in a different database than base but this is a professionals decision in the future.