defined database relationships, created user signup form, html templates