Cardiology Clinic Database - Essay Example

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, patient first name, patient surname, patient's phone number, patient's email address, patient's location, patient's ZIP address, patient's Date of Birth, and patient 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, 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 patient's 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 language.