If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Database design

Task is to make a Database and a web based user interface for components and products Life Cycle Costs.

User logs in, selects needed product type and components, and fills in all needed values for calculations. The values are inserted in separate pages, like User information insertion page, elevator information page etc. A preview page for all inserted values would be nice, but not mandatory if this is too difficult. How this could be implemented? A temporary table maybe?
Program makes the calculations annually for the next 10 years for each component and component group. Program calculates the values also separately for each category, like Environmental costs, maintenance costs, Investment costs etc.
All the projects are of course saved to the database and modification of the older projects should be possible too.

ALL THE CALCULATIONS ARE MADE IN VIEWS / SELECT STATEMENTS FROM GIVEN VALUES, SO NO RESULTS ARE SAVED TO THE DATABASE!