implement more methods in DBConnection
update schema diagram (MySQL Workbench)