reworked the database design and modified the files as necessary