data line on the table, 0.5 points will be deducted.
Question 3:
IMPORTANT - before you start doing your solution, MUST do the following steps:
1. Create your MS SQL database named Y24SU1B1 by running code in script Y24SU1B1.sql.
2. You MUST use DBContext.java for your all database connection.
Executionltems
Column Name Condensed Type
Executionite..
Arrayftem
ExecutionID
int
int
Executions
Column Name Condensed Type
ExecutionID
Result
int
int
(4.0 points)
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 /show (/ represents your web application context path) to access Show Execution Page:
List of Executions:
Execution ID
1
2
3
Array Result
124 2
12 1
12
Delete
Delete
Delete
Zoom
Close
Execution ID:
Array:
Result:
• Display the interface as above (excluding data taken from the database) (0.5 point)
The table "List of Executions" must load data from [Executions] and [ExecutionItems] tables (1.5point)
Note: If only display all the information from [Executions] and [ExecutionItems] tables and are not the same as shown above, you will only get 0.5 points.
+ 100%
