Kizspy.me
You are asked to build a web application using the given database and given project.
Your tasks:
1. The user can access your page via url /filter (/ represents your web application context path) to access
Show Coach Page:
Choose an option: All positions Head coach Fitness coach
List of Coachs:
CoachID CoachName Experience Year Position
C01
Zinedine Zidane 6
Head coach
C02
Phillip Inzaghi 5
Fitness coach
C03
Pep Guardiola
10
Head coach
C04
Harry Poster
4
Fitness coach
SORT
Figure 1. Interface of page
Display the interface as shown in Figure 1. (excluding data taken from the database) (0.5 point)

The option radios must load data from [Positions] with [Type]="2" and show [PositionName]
(include "All positions" option) (0.5 point)
The table "List of Coachs" must load data from [Coachs] (0.5 point) and "Position" column is
taken in the [PositionName] of the [Positions] table that corresponds to the PositionID in the
[Positions] table. (0.5 point)
2. When users choose an option, load all information of the coachs that their positions equal to the option
to the table, as shown in Figure 2. (If users choose "All positions" option, load all information of the
coachs in database). (1.0 point):
Zoom
Choose an option: All positions
Head coach Fitness coach
+100%
Close