Please enable JavaScript.

Coggle requires JavaScript to display documents.

Data Connections - Coggle Diagram

- - - - temperature data (Celsius)
      - UV level
      - Wind Gust Speed (Miles Per Hour)
    - - Air Quality Index (1-100)
- - - - Sport ID
        
        Integer
      - Sport Name
        
        Text
        
        Will be used to display the names of sports in the system
      - Indoor of Outdoor
        
        boolean
        
        As indoor facilities are less affected by some weather conditions than outdoor facilities, the Criteria determining what events must be cancelled will be different. Therefore, the system can just evaluate whether indoor events are off or whether outdoor events are off and then use this field to display what specific sports are off according to if that sport is indoor or outdoor.
      - Venue
        
        Text
        
        Gives the administrator information over what sports are at what venues so that they can manually cancel those sports if there are problems with the venue
    - - Criteria ID
        
        Integer Auto-Incrementing
        
        ID 1 will be the criteria for indoor events and ID 2 will be the criteria for outdoor events, meaning that the indoor criteria and outdoor criteria are separate columns inside of this table
      - Criteria Name
        
        Text
        
        Will share the same names as the weather data so that the weather data and the criteria that uses this data to come to a decision over if indoor/outdoor events will be cancelled can be easily linked.
      - Criteria Value
        
        Integer
        
        The weather data will be compared to the criteria value to see if the sport will be cancelled or not.