converted koornbeurs data model to use foreign keys