updated er diagram and added foreign keys to db