Sport

To keep good oversight of sport policy, sport locations in the city are administered. A Sport Location can be a Sports Park with multiple fields, or an Indoor Venue. Line Marking indicates the kind of markings at the location — football, handball, basketball — because locations with different markings are used for different sports and are not readily usable by every sports club. Line Marking therefore belongs to a Sport. Only for Indoor Venues are Sport Materials administered.

Diagram (in Dutch): sport-policy data model — sport locations, line marking, sports and materials.

Sport Locations are used by a Sports Club and/or a School. Often the school rents locations out to the sports club. Schools and sports clubs are Non-Natural Persons. A Sports Club runs one or more Sports.

The next figure shows the relationship of sport object types to District, the BAG and inspection reports. Indoor Venues serve a particular District; Outdoor Venues serve the entire municipality. Indoor Venues are located in a Residence Object, establishing the link with the BAG. Sports Parks and Fields are on an Other Named Terrain.

Inspection reports are recorded in a Document.

Diagram (in Dutch): data model linking sport locations to districts, BAG objects and inspection reports.