finalized DBManager methods

added methods in DBManager to perform all functionality.  What is left
to do is indicated in TODO's.  Code hooking the GUI to the database can
be completed now