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

Final Project - Essay Exampleheir clinic visits, store and determine information on the patients current diagnosis and to provide user interface for perform the above stated tasks. Considering the above stated requirements, the database structure bequeath be designed in much(prenominal) a way that it has a tabularise 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 long-suffering Identification number, patients first name, patients surname, patients phone number, patients email address, patients location, patients ZIP address, patients employment 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 patients name, and the patients 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 chance on 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