I, too, would chime in to offer caution about developing a system on
your own, but, if you are committed to that approach, here are a few
thoughts:
1) It is hard to find good resources because relational database
design is not easily learned. I have developed many simple
relational databases, but still do not really understand the theory.
Getting a consultant to help in the data-modeling and design stage
might be a very good long-term investment. Or sign up for a
semester-long database course.
2) The biggest risk with in-house software is that you will leave and
no one else will know how to update your coding. I have been
the-person-who-came-after-the-other-person-left several times and it
is not a good situation. The typical result is to freeze the
application and eventually replace it when the users finally rebel at
the lack of updates. Keep your application simple, and document
everything.
Sorry if I sound preachy. I know that I am also not giving you the
advice you asked for! Good luck!
--
---------------------------------------------------------------
Guy Hermann
Mystic, Connecticut
Home: 860-536-2994
Office: 617-437-6262
Cell phone: 860-857-7363 (leave voice mail)
