New ER Diagram

New ER Diagram based on the 3rd update on the spec provided by Michael