Create a database driven application based upon the three tier client/server model

Develop a 3-tier client-server application written in Java that utilizes a MS Access database for persistence. Your project must meet the following requirements: 1. Your architecture must be based upon the 3-tier client/server model. 2. Your user interface layer may be either graphical or character based. 3. The user interface layer must communicate only with the application server. Direct database communication from the user interface layer is prohibited. 4. The system must utilize the request/response model. 5. The system must be able to dynamically locate the database (no hardcoded paths). 6. The system must be able to add a new record. 7. The system must be able to update an existing record. 8. The system must be able to logically delete a record. 9. The system must be able to logically undelete a record. 10. The system must be able to purge (physically delete) a record, but only if it is already logically deleted. 11. The system must support searching for a record by a data field other than the primary key. 12. The system must be able to display a single record to the user interface. 13. All SQL must be parameterized. The concatenation of parameter values directly into SQL is prohibited. 14. All input data MUST be validated both at the user interface and at the server. 15. XML must be validated prior to processing at the server. 16. An operation must not be allowed to fail due to invalid or missing data (error handling must exist to catch such conditions). 17. Helpful messages must be displayed to the user for validation errors or any other system related error. Your project must include the following items: 1. A user’s manual which explains how to use the application from an end-user’s point of view. 2. A request/response guide that illustrates the XML request and response documents. 3. A MS Access database (version 2010). 4. A User interface (client) program. 5. An application server program. Due by