The aim of this project write the Logic and Pseudocode for a database consisting of two major sets of tables - personal related and medical related. The personal-related tables will be used to store personal information such as name, age, gender, residence, etc. The medical-related tables will be used to store information such as patient's medical history, family disease history, allergies, medications/treatments, etc.
Information in the personal-related tables such as patients' name, address, telephone numbers, social security numbers will be mostly text based (either string or numbers). On the other hand, information in the medical-related tables will be more multimedia. For example, in addition to text description of patients' medical history, graphic images (i.e. X-rays, pathology slides), video files of doctors' discussion about the disease can also be saved in patients' record.