Hello, Vista. I know your area very well.

First, define the requirements specification. Then design a data model. Does your model match the original? There are many data models, and sometimes we get projects that could be designed better. The problem is getting the data from the old app to the new. Look into Codd's relational model. First order, second order, etc.

Tom