database almost completed. need to implement remaining update cascades.