Need Java and database expert-UML diagram-Only IT experts bid

ICTPRG527 – Apply Intermediate Object-oriented

Language Skills

Assessment Agreement:

This assessment has been developed to provide you with the opportunity to demonstrate your skills, knowledge and ability to undertake intermediate level programming tasks using an object-oriented programming language.

To be deemed competent you will be required to:

· Build applications using provided language utilities

· Write programs that interact with a database

· Write a graphical user interface

· Debug application

· Test application

· Create and maintain documentation

· complete all practical and written assessment tasks in this assessment tool

This assessment is written and designed to be undertaken in a simulated workplace environment within your college. Your assessor will provide you access to the following:

· appropriate learning and assessment support when required

· reasonable adjustment to the assessment

· modified equipment for people with special needs

· development environment

· server access

· database server

· browsers

Timeframe

The Assessment Tasks are due on the date specified by your assessor . Any variations to this arrangement must be approved in writing by your assessor.

Assessment is used:

· to measure students' preparedness for further study or professional accreditation;

· to provide feedback on student learning for both students and staff;

· to define and protect academic standards;

· to direct students' learning

Effective assessment for a unit or program of study will typically include a mix of assessment types, selected and designed to meet these multiple and various demands.

Assessment will consist of:

· Evaluation of completed application

· Review of documentation of application

· Written questioning to assess knowledge of

· object orientated programming

· Coding standards

· Methods of accessing a database

Assessment Process:

Competency will be determined after reviewing all of the evidence you have submitted.

Each Assessment Task will be graded S (Satisfactory) or NS (Not Satisfactory). When all evidence has been gathered, your assessor will make a final judgment and sign off with C (Competent) or NYC (Net Yet Competent) . If you have been deemed competent your Assessor will return your copy of the ‘Final Judgment’ as evidence of completion of this unit. Alternatively, you will be advised what further action you need to take to achieve competency.

It’s time to begin!

Student Instructions:

Read the practical instructions provided below. You are required to carry out the exercises and attach any required documentation to this assessment tool. To be deemed satisfactory in this task you must complete all steps outlined below and attach all required evidence to this assessment tool.

Scenario:

A trucking company, ‘Trucks R Us’, has approached you as an application developer. They have requested that you create a desktop application to manage their jobs.

The application must perform the following functions:

1. Maintenance of jobs, this included the creation of new jobs and the maintenance of existing ones.

2. Maintenance of staff.

3. Assign jobs to staff members

All data is to be stored in a Relational Database.

‘Trucks R Us’ employs 3 types of staff members: drivers, supervisors and managers.

Drivers – drive trucks transporting goods

Managers – manage staff and are typically based in the office

Supervisors – are to manage all the drivers assigned to one job Jobs can only be assigned to drivers and supervisors, not to managers.

Drivers are paid $100 for each job that they complete. Supervisors are paid $100/job plus another $10 for each driver that they are responsible for on that job.

The managers receive a Salary.

Your tasks:

To complete this assessment you are required to perform the tasks that follow using the Database Management System (DBMS) and Integrated Development Environment (IDE) provided by your assessor.

Note: Code created must comply with the institutional coding standards and industry best practice.

1. Review the requirements outlined in the scenario and document the program requirements.

2. Design:

a. The required classes. You are to use Multiple Inheritance at least once in this step

b. The database for storing the required data

c. Tests to be applied to ensure that your application functionality and usability.

3. Create a Graphical User Interface (GUI) for your application using the attached wireframes (see appendix 1) the requirements

a. This application is to be built using Object Oriented (OO) techniques and best practices.

b. Use the facilities of the provided IDE to generate the application components.

c. The data is stored in the database designed task 1, use appropriate language components to allow your GUI to interact with the database

d. Implement an appropriate error handling strategy supported by the language chosen.

e. Demonstrate the functionality of your GUI and use a text input field to locate and display a customer’s details on screen.

4. Create an additional window to demonstrate the use of the internal searching and sorting facilities of the target language. Then perform the following

a. Extract all customers from the database and store them in a binary disk file.

b. Load the customers from the binary disk file into an appropriate data structure in memory.

c. Sort the list of customers by surname.

d. Display the sorted list in a list control on screen

e. Using a text input field, enter the name of a customer to be located and display the memory details on screen.

5. Create a window showing the payments each staff member. Keep in mind that payments are made by job, not by the time taken to complete the job. In the step make use of operators, functions or method overloading. For managers just display the word ‘salary’.

6. Use your selected IDE’s debugging tools to demonstrate the tracing of running code, detecting and correcting errors.

7. Use your tests designed in task 1 to test your code for correctness and to ensure that your application complies with the program specifications

8. Create a brief user guide for your created application so that you can provide the document to Trucks R Us.

Student Instructions:

Read the questions provided below. To achieve a satisfactory outcome for this task you must answer all questions in sentence form. Answers are to be typed alongside the questions specified below and attached to this document as evidence.

Questions

1. Explain the diamond problem when using multiple inheritance.

2. List 2 programming languages which support multiple inheritance.

3. List 2 programming languages that do not support multiple inheritance.

4. What are Object Oriented interfaces?

5. What does the term Polymorphism mean?

Evidence collection information:

After the submission of typed questions, assessor will mark your work and indicate the outcome on the following checklist. For practical observation you need to demonstrate each subtask and submit the screenshots (print screens) as required. Assessor will observe/mark the practical and indicate the outcome on the following checklist.

Depending upon your performance of the tasks (satisfactory / unsatisfactory) your trainer will mark you competent / not yet competent respectively.

After marking, your trainer is going to provide you feedback. If there are any gaps he/she will ask you to provide further evidence.

Student Feedback

Feedback:

We adhere to the policy of two-way feedback and your assessor will provide regular feedback during the assessment process. We also invite you to provide your comments on the assessment process for this group of units at the conclusion. We thank you for taking this seriously, as your contribution is greatly appreciated in our attempt to continuously improve our assessment system and processes.

ICTPRG527 – Apply Intermediate Object-oriented Language Skills Assessment Tool

Version 1.2 Updated: Feb 2016 Page 1 of 9

Appendix One – Application Wireframe

Screen Shot 1 Window used to enter new jobs

Screen Shot 2 Dialog used for entering a new customer

Screen Shot 3 Staff Maintenance window

Screen Shot 4 Assign Jobs