JAVA Haulage and Trucking $($JHT$)$ is a haulage contracting company with offices operating in Kingston and Mo$.$ Bay, Jamaica. Several companies from all parishes utilize their services daily. JHT currently handles all office matters with a manual paper$-$based system but is seeking consultancy from an IT firm to recommend and implement a system to suit their office protocols.

There are two types of employees at JHT$,$ namely administrative staff and contractors. Administrative staff performs the office duties including managing customers, payroll, trips and orders. Contractors include drivers and maintenance workers. Drivers and maintenance workers do not interact with the office protocols, i$.$e$.,$ they are not system users, they only take instructions from the administrative staff.

Data for Staff

Staff ID$,$ Name $($First and Last$),$ DOB, Address $1,$ Address $2,$ Post Office, Parish, Telephone, Email, Position, Status

JHT needs to capture the following information on their customers.

Data for Customers

Customer ID$,$ Company, Contact Person, Address $1,$ Address $2,$ Post Office, Parish, Telephone, Email, Status $($active or inactive$)$ customers with an outstanding balance over $30$ days have their account flagged inactive.

On receiving a request for an order to trip, the administrative clerk needs to add a record to the system if the customer$$s account is active. All requests are assumed to be made in the office.

Data for Trips $/$ Orders

Invoice No$,$ Company, Source Address, Destination Address, rate, driver, billed by

The system should be capable of generating the salaries for all its employees. Administrative and maintenance workers are given a fixed salary for a $30-$day period. Drivers are paid based on the number of trips they make. They are given $30\%$ of the total earnings made from a trip.

Pay ID$,$ Staff $\_$ID$,$ Start Date, End Date, Salary, prepared by

General Instructions:

$1.$ Build a two$-$tier java application using the client$/$server model to handle the operations of JHT$.$

$2.$ SystemName:JAVAHaulageandTrucking

$3.$ GraphicalUserInterfaceshouldbeimplementedasaMultipleDocument

Interface $($MDI$)$

System Requirements:

The system should be able to serve clients from both locations concurrently from a centralized server, keep track of all its staff and customers, record trips and orders delivered by the company$$s drivers. The system should also be able to generate the pay slips for all its employees as well as generate reports for a specified period $($E$.$g$.6/7/202311/8/2023).$

The system should also be capable of dynamically generating reports. Reports should include trips for a particular period $($may be grouped $/$ filtered by driver$),$ all invoices for a particular customer and the total earnings for a particular period.

Getting route charges for invoice generation is a tedious process. The administrative clerk must look at a rate sheet to see what the rates are from a particular source to a destination. Build into the software a module that allows the user to add the routes and rates into the system. On booking a trip the routes will be available in a dropdown list. By selecting the route from the drop down list the rates will be automatically assigned to the invoice for the trip.

The application should have a graphical user interface bearing a form like interface and may consist of grids and tables for displaying data.

The application should be robust and should handle exceptions where errors are prone to happen within the code. Exceptions, error handing and checking should also be put in place where data entry is concerned. For audit purposes the system is to log the activities of users in a rolling file. The file is to roll every $30$ days.

The operational data captured should be stored in a relational database at least up to $3$rd normal form. The database should only be accessible by the server application and the clients make requests to the server for the data.

The system should have at least two accounts for user log in at each location.