4. Create the following unit tests: Test: (assertEquals) Test Data and expected system responses. Developer array correctly populated: The developer array contains the expected test data. Test Data: Developer entry for Test data for tasks 1-4 The system returns: "Mike Smith", "Edward Harrington" , "Samantha Paulson", "Glenda Oberholzer" Display Developer and Duration for task with longest duration. Test Data: Task 1-4 The system returns: “Glenda Oberholzer, 11; Search for tasks Test Data: “Create Login The system returns: “ Mike Smith, Create Login” Search all tasks assigned to Developer Test Data: Samantha Paulson The system returns: Create Reports Delete Task from array Test Data: "Create Reports" The system returns: Entry “Create reports” successfully deleted Display Report The system returns:
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Complete the following in Java
1. Users should be able to use to populate the following arrays:
| Array | Contents |
| Developer | Contains the names of all the developers assigned to tasks |
| Task Names | Contains the names of all the created tasks |
| Task ID | Contains the generated taskID’s for all tasks |
| Task Duration | Contains the Duration of all tasks |
| Task Status | Contains the Status of all tasks |
2. Users should be able to use these arrays to:
a. Display the Developer, Task Names and Task Duration for all tasks with the status of
done.
b. Display the Developer and Duration of the class with the longest duration.
c. Search for a task with a Task Name and display the Task Name, Developer and Task
Status.
d. Search for all tasks assigned to a developer and display the Task Name and Task
Status.
e. Delete a task using the Task Name.
f. Display a report that lists the full details of all captured tasks.
3. Use the following test Data for your unit tests and to populate your arrays:
Test Data Task 1
Developer - Mike Smith
Task Name - Create Login
Task Duration - 5
Task Status - To Do
Test Data Task 2
Developer - Edward Harrison
Task Name - Create Add Features
Task Duration - 8
Task Status - Doing
Test Data Task 3
Developer - Samantha Paulson
Task Name - Create Reports
Task Duration - 2
Task Status - Done
Test Data Task 4
Developer - Glenda Oberholzer
Task Name - Add Arrays
Task Duration - 11
Task Status - To Do
4. Create the following unit tests:
Test: (assertEquals) Test Data and expected system responses.
Developer array correctly populated:
The developer array contains the expected
test data.
Test Data: Developer entry for Test data for
tasks 1-4
The system returns:
"Mike Smith", "Edward Harrington"
, "Samantha Paulson", "Glenda Oberholzer"
Display Developer and Duration for task with
longest duration.
Test Data: Task 1-4
The system returns:
“Glenda Oberholzer, 11;
Search for tasks Test Data: “Create Login
The system returns:
“ Mike Smith, Create Login”
Search all tasks assigned to Developer Test Data: Samantha Paulson
The system returns:
Create Reports
Delete Task from array Test Data: "Create Reports"
The system returns:
Entry “Create reports” successfully deleted
Display Report
The system returns:
Step by step
Solved in 3 steps
