• Display the interface as above (excluding data taken from the database) (0.5 point)
• The table "List of Executions" must load data from [Executions] (1.0 point) and "Type" column is taken in the [TypeName] of the [Types] table that corresponds to the TypeID in the [Executions] table. (0.5 point)
2. When users click "SORT" button, sort the list of executions in ascending/descending order by 'TypeName', if there are duplicates in 'Type Name', then sort those entries in ascending/descending order by 'Index', and show the result to "List of Executions" table (in interface) as shown below. (2.0 point)
Ascending by TypeName, then Ascending by Index
Sort by Type name:
Ascending
Descending
Then by Index:
SORT
Ascending Descending
Ascending by TypeName, then descending by Index
Sort by Type name: Ascending Descending
Then by Index:Ascending Descending
SORT
List of Executions:
ID
String
Index Type
Result
List of Executions:
ID
String
Index Type
Result
1 FPT University
2
Sub First FPT
3 Computing Fundamental 8
Sub First Computing
3 Computing Fundamental 8
1 FPT University
Sub First Computing
2
Sub First FPT
2 FPT University
4
Sub Last University
4 Computing Fundamental 10 Sub Last Fundamental
5 FPT University
6
Sub Last versity
5 FPT University
4 Computing Fundamental 10
Sub Last Fundamental
2 FPT University
6 Sub Last versity
4 Sub Last University
Descending by TypeName, then Ascending by Index
Sort by Type name: Ascending Descending
Then by Index:
SORT
Ascending Descending
Descending by TypeName, then descending by Index
Sort by Type
name: Ascending Descending
Then by Index:
Ascending Descending
SORT
Zoom
+ 100%
Close
