In this assignment you will modify your Health Care System that supports patients, doctors and pharmacists. You will store all information at the doctor in an SQL database, rather than in an XML file.

For this assignment, your Health Care System will be implemented as a three-tier distributed application, using Java Database Connectivity (JDBC) and the MySQL database system. You will be provided MySql accounts that you will use for this project.

This assignment requires that you modify your Health Care System to run as a three-tier distributed application with a database in the back-end (third) tier at the doctor. The Doctor application in the middle tier will use the JDBC APIs to encapsulate the SQL commands to the MySQL database system in the third tier.

The Patient in the first tier will have a Graphical User Interfaces (GUI) and provide the same functionality as in the previous project. The Pharmacy application will also be the same as in the previous project (unless you choose to use a database instead of an XML file at the pharmacist). The Doctor application will insert, update and retrieve data from the database in the third tier at the doctor.