Final Project Essay Example | Topics and Well Written Essays - 250 words - 1

Final Project - Essay Example heir clinic visits, store and retrieve information on the patient’s current diagnosis and to provide user interface for performing the above stated tasks. Considering the above stated requirements, the database structure will be designed in such a way that it has a table for registering new patients, a table that stores diagnosis information for the patients and finally, a table that stores booking information for the patients. The registration table will have the following fields; Patient Identification number, patients first name, patients surname, patients phone number, patients email address, patients location, patients ZIP address, patients Date of Birth, and patients date of registration. On the other hand, the table that stores diagnosis information will contain the following fields; Patient Identification number, patient name, Date of the diagnosis, diagnosed condition and the recommended treatment. Finally, the table that stores scheduling information will contain the user identification number, the patient’s name, and the patient’s date of visit, the name of the doctor to visit and the room number to visit. To prevent data redundancy and to normalize the database, the patients Identification number will be utilized as the primary key in all the tables and also as a foreign key of the database. To retrieve the data, appropriate SQL statements will be used together with a chosen scripting