☑Kizspy.me
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):
Choose an option: All positions Head coach Fitness coach
List of Coachs:
CoachID CoachName Experience Year Position
C01
Zinedine Zidane 6
C03
Pep Guardiola
10
SORT
Head coach
Head coach
Figure 2. Output the result after choosing an option
(If option is not displayed after choosing an option, 0.5 points will be deducted)
Zoom
+ 100%
Close
