Exercise in Design and Implementation of a Database System

1. Exercise in Design and Implementation of a Database System By Brett Stirling Audimed is a company that specializes in producing hearing aids and tinnitus combating devices. They currently have no central database for storing client records and other information such as audiograms. To solve this problem a new database is to be written that will contain all the data from all programs that are currently used. The database must be access compatible and therefore will be written in SQL. Its interface will be written in HTML, which will be generated by a Java Servlet. A small amount of XML will also be needed in order to facilitate the use of the servlets, as Tomcat will be being used as the web server. The aim of the project is to produce a database management system which runs as follows: Audimed employees access an SQL database through a Tomcat server. This enables them to call up client data. Once called up it can be modified and saved. New records can also be added and obsolete ones deleted. The system will also offer an option of printing out data required for an audit, as currently this must be done by hand. Once the project is completed, Audimed staff will be trained in the use of the database to help with the migration between systems. The current computerized system for storing data is using NOAH (below) however this is only really useful for tuning hearing aids to specific audiograms (see above). Project written using… Project in co-operation with