necessary revision to relational schema
added model validations
added proper dropdown menus