implement partial Ping interface; upload db_design digram;