The Nature and Parks Authority (N&PA) is interested in an information system that will assist in managing its nature and archaeological sites. The requested system, called "Nature Trail", includes details about various sites owned by the N&PA. Each site is characterized by its number, name, and entrance fee. Each site offers trails to explore and activities to participate in. The trails and activities are unique to each site.
For each trail, there is a description, difficulty level (easy/intermediate/challenging), length in kilometers, and type selected from a list of existing trail types. The trail type indicates the intended audience: trails for people with disabilities, pedestrians, cyclists, vehicles, or a combination of them. There may be multiple trails of the same type at a site. Each trail has a list of nature guides who can accompany it, and a nature guide can accompany different trails.
Activities are intended for groups, so for each activity, in addition to its number, name, and price, information is stored about its target audience (youth/adults/elderly/mixed), the minimum and maximum number of participants. Activities are conducted by social guides who are responsible for updating their activity details and the equipment they use. A social guide can conduct various activities on the site, using different equipment such as colors and plaster. When assigned to an actual activity (on a specific date), the guide can pre-order the necessary quantity of each equipment for this activity. 
The site attracts numerous visitors. When a new visitor arrives at the site, a general employee, located at the entrance of the site, enters their information into the system, including the identity number, name, date of birth (for age calculation), email, and country of residence (as free text). Since the number of visits by different visitors to the sites of the N&PA can increase rapidly, there is no need to store details for each visit. Instead, the system keeps track of the number of times each visitor has visited each site in general and in the current year. For example, visitor number 123456789 visited Site1 ten times in general and three times this year.
The entrance fee for each site varies, but uniform discounts can be given to visitors based on their type, as is common in sports and cultural facilities in the country. The N&PA receives regulations from the Ministry of Science, Sports, and Culture (MSSC) specifying the uniform discount percentages for all sites. This information is received in JSON format and includes three types of discounts: a discount for youth (under the age of 21), a discount for elderly (age 60 and above), and a discount for frequent visitors. In any case, the discount is determined as a percentage of the site entrance fee. The system is required to store the history of discount percentages, but there is no need to store the entrance fee history of sites. The frequent visitor discount is applicable alongside an age-based discount and is granted when a visitor visits a predetermined threshold of visits to a specific site within the current year (with unique thresholds defined for each site).
As mentioned, the NP&A has different types of employees: general employees, guides (social and nature), and the authority's manager. The system only stores details for guides, including their ID, name, date of birth, email, phone number, and whether they are social guides or not. For professional considerations, a nature guide cannot perform the work of a social guide and vice versa.
The manager of the N&PA can generate an annual visitor report for any site given as a parameter. The report will display the visitor details, the number of visits to the site for each visitor, and the total income from visitor entries in the current year (taking into consideration the different types of discounts).
The manager is also responsible for managing the various sites, including updating their trails and activities. The allocation of trails and activities to different guides is done by the nature and social guides, respectively. At the beginning of each year, the manager sends an XML file to the hiring company that employs and trains the guides. The file contains information about the actual activities (including equipment) and trails assigned to each guide. 
