updated db. posting and listing of assignment