Smart & Communication Technology INFORMATION & COMMUNICATION TECHNOLOGY

Smart Health ConsultingA PROJECTREPORTSubmitted byDolly Shah. (150320132046)Kavita Pandya. (150320132031)In partial fulfillment for the award of degreeof Bachelor of Engineering in Information & Communication Technology INFORMATION & COMMUNICATION TECHNOLOGY DEPARTMENTL. J. INSTITUTE OF ENGINEERING AND TECHNOLOGYGUJARAT TECHNOLOGICAL UNIVERSITYAHMEDABAD YEAR, 2018-19L.

J. INSTITUTE OF ENGINEERING AND TECHNOLOGYINFORMATION & COMMUNICATION TECHNOLOGY DEPARTMENT YEAR, 2018-19 CERTIFICATEThis is to certify that the Project entitled “Smart Health Consulting” submitted by Dolly Shah, towards the partial ful?llment of the requirements for the degree of Bachelor of Engineering in Information & Communication Technology of L.J. Institute of Engineering and Technology, Ahmedabad, under the Gujarat Technological University, Ahmedabad is the record of work carried out by him under my supervision and guidance. In my opinion, the submitted work has reached a level required for being accepted for examination. The results embodied in this project, to the best of my knowledge, haven’t been submitted to any other university or institution for award of any degree or diploma. Prof.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Ankita TiwariProf. Saurin Dave (HOD – IT/ICT) L. J. INSTITUTE OF ENGINEERING AND TECHNOLOGYINFORMATION ; COMMUNICATION TECHNOLOGY DEPARTMENT YEAR, 2018-19 CERTIFICATEThis is to certify that the Project entitled “Smart Health Consulting” submitted by Kavita Pandya, towards the partial ful?llment of the requirements for the degree of Bachelor of Engineering in Information ; Communication Technology of L.J. Institute of Engineering and Technology, Ahmedabad, under the Gujarat Technological University, Ahmedabad is the record of work carried out by him under my supervision and guidance. In my opinion, the submitted work has reached a level required for being accepted for examination.

The results embodied in this project, to the best of my knowledge, haven’t been submitted to any other university or institution for award of any degree or diploma. Prof.Ankita TiwariProf.

Saurin Dave (HOD – IT/ICT) GUJARAT TECHNOLOGYCAL UNIVERSITYUndertaking about originality of workWe hereby certify that we are the sole authors of this IDP/UDP project report and that neither any part of this IDP/UDP project report nor the whole of the IDP/UDP Project report has been submitted for a degree by other student(s) to any other University or Institution.We certify that, to the best of our knowledge, the current IDP/UDP Project report does not infringe upon anyone’s copyright nor violate any proprietary rights and that any ideas, techniques, quotations or any other material from the work of other people included in our IDP/UDP Project report, published or otherwise, are fully acknowledged in accordance with the standard referencing practices. Furthermore, to the extent that we have included copyrighted material that surpasses the boundary of fair dealing within the meaning of the Indian Copyright (Amendment) Act 2012, we certify that we have obtained a written permission from the copyright owner(s) to include such material(s) in the current IDP/UDP Project report and have included copies of such copyright clearances to our appendix.We have checked the write up of the present IDP/UDP Project report using anti-plagiarism database and it is in the allowable limit. In case of any complaints pertaining to plagiarism, we certify that we shall be solely responsible for the same and we understand that as per norms, University can even revoke BE degree conferred upon the student(s) submitting this IDP/UDP Project report, in case it is found to be plagiarized.Team:Name of Students Enrollment number SignatureDolly Shah 150320132046 Kavita Pandya 150320132031 Place: __________ Date: __________ Guide : Prof.Ankita Tiwari (Signature of Guide) ACKNOWLEDGEMENTI am thankful to and fortunate enough to get constant encouragement, support and guidance from all teaching staffs of I.

T department which helped us in getting our project done. Also, I would like to give respect to all those who provided guidance throughout our project.I owe my deep gratitude to our Head of Department prof.

Saurin Dave and our project guide prof. Ankita Tiwari, who took keen interest in our project work and guided us all along, till the end of our project work by providing all the necessary information for developing a good system. Dolly Shah (150320132046) Kavita Pandya (150320132031)ABSTRACTThis Project “SMART HEALTH CONSULTING” aims at maintaining patient health records and even getting appointments from various doctors for related treatments. The system user must register as a member of this system and keep updating his medical history. Patients then can select from a list of specialized doctors for respective treatments such as(skin specialist, ENT specialist, cardiologist etc.)at particular locations. Patients may also select suitable appointment timings for their meeting. Patients can also order their medicines and perform online transactions.

This system can also provide an audio to text convertor and video conferencing feature. TABLE OF CONTENTSr. No Index Page I Acknowledgement   VIII Abstract   VIIIII Table of Content VIII-IXIV List of Figures   XV List of Tables XIChapter 1 Introduction 1-21.1 Introduction to System. 11.2 Limitation of Existing  System.

(IF ANY) 11.3 Objective of the new system. 11.

4 Problem definition. 2Chapter 2 Requirement Analysis 3-52.1 Feasibility study 32.2 Requirement of System (Functional and Non-Functional) 42.3 Tools and Technology used 52.4 Project Estimation 5Chapter 3 System Design 6-9 3.

1 Use case Diagram   63.2 Activity Diagram 73.3 Sequence Diagram   83.4 State Diagram 9Chapter 4 Data Dictionary 10-144.1 Patient’s database schema 104.2 Doctor’s database schema 114.3 Medicine’s database schema 124.4 Disease’s database schema 134.

5 Feedback’s database schema 134.6 User’s database schema 14Chapter 5 Snapshot 15-16Chapter 6 Future Enhancement 17Chapter 7 Conclusion 18 Chapter 8 References 19 LIST OF FIGURESSR.NO FIGURE NAME PAGE NO.1 Fig 3.1-Use Case Diagram62 Fig-3.2 Activity Diagram73 Fig-3.

3 Sequence Diagram84 Fig-3.4 State Diagram9 LIST OF TABLESSR.NOTABLE NAME PAGE NO.1 4.1-Patient’s table102 4.

2-Doctor’s table113 4.3-Medicine’s table124 4.4-Disease’s table135 4.5-Feedback’s table136 4.6-User’s table14INTRODUCTION Introduction to SystemConsulting a doctor is a quite obvious thing in our day to day life, but the availability of the doctor during the time of our requirement is unpredictable. In order to overcome this issue , we have planned to develop a system that enables the user or the patient to get all the required details like availability, contact information about the nearest located doctors who are specialized in the issues given by the patient.This application allows user to get instant supervision on their health issues through a smart health care web application online.

The application is feed with various symptoms and the diseases associated with those systems. Patients can check their medical record .Hence, this system provides Quality Health Care to everyone and error free and smooth communication to patients.1.2 Limitation of Existing SystemIn the present existing system, consulting any doctor is very tiresome task for the patient. There are many cases where the patient is unable to find out the required doctor for his disease, this become even worse if there is an emergency case especially when the patient is in an unknown area. This situation might harm the patient in the mean time.

Even knowing the proper address, contact details of the doctor for required disease has become a very tough task. Also, sometimes doctor’s schedule may get change during such cases patient’s appointment might be cancelled. This might not be known by the patient due to lack of communication between the patients and the doctor. A doctor can have many patients in a day which becomes even more difficult for the doctor to intimate his schedule to each and every patient.

Because of this time of patient get wasted and in the case of emergency it may cause harm to the patient. 1.3 Objectives of the new SystemTo overcome the tiresome procedure of finding the doctor specialized in the area specified by the patient ,we have come up with the solution of categorizing the doctors according to their specialization.Moreover, it also provides the location of the nearest doctors to the patient.In the event of a change in doctor’s schedule ,we provide a feature of notifying the patient via sms /e-mail. Problem DefinitionThis system aims at maintaining patient health records and even getting appointments from various doctors for related treatments.

The system user must register as a member of this system and keep updating his medical history. Patients then can select from a list of specialized doctors for respective treatments such as(skin specialist, ENT specialist, cardiologist etc.)at particular locations. Patients may also select suitable appointment timings for their meeting. Patients can also order their medicines and perform online transactions. This system can also provide an audio to text convertor and video conferencing feature. REQUIREMENT ANALYSIS2.1 Feasibility StudyTECHNICAL FEASIBILITY: Our system is technically feasible because it satisfies the hardware requirements such as the availability of internet connection, PC, and the software requirements such as the required software (NetBeans), database and various editing tools.

ECONOMIC FEASIBILITY: Since our system offers flexibility to the users regarding consulting the doctors as per their convenience and also other handy features, the number of users and doctors are expected to gradually increase. Also, all the online transactions will be performed through our system.LEGAL FEASIBILITY: For our system to be legally feasible, the admins will allow the registration of only those doctors who have valid degrees.OPERATIONAL FEASIBILITY: Certain features of our system including communicating with the specialized doctors, and getting the treatments on time are operationally feasible. While, other features such as video conferencing between doctor and patient, might not be operationally feasible. SCHEDULING FEASIBILITY: The project might take about 7 to 8 months to become completely functional.2.

2 Requirement of SystemFunctional Requirements: 2.2.1) Patient’s SideRegistration of patient.Search Doctors.Search disease based on symptoms.

Online appointment.Feedback 2.2.2) Doctor’s SideRegistration of doctor.Update personal Details.Notification of appointments.View Patients and disease. 2.

2.3) Admin’s SideAdd/View/Remove Doctors.View/Remove Users.View/Remove Patients.Add/View/Remove Medicines.Add/View Disease.View Appointments.

View/Remove FeedbackNon Functional Requirements:Convenient to useAccessibilityAvailabilityPortabilitySecurityPerformanceMaintainabilityReliabilityConcurrency and CapacityUsability Tools and Technology usedOur system makes use of various software tools like NetBeans IDE, Database, etc.The technologies used are HTML, CSS, Java, Javascript , Jquery , Ajax, and frameworks such as Spring , Hibernate, etc. Project EstimationThe cost estimation of our system includes server hosting cost , tools and technology cost etc.The time estimation includes number of hours required to build this system which nearly will take 7/8 months.

The labour estimation includes the man power involved in analysis, development, testing, validation and maintainance.System Design Use case Diagram(FIG-3.1)3.2 Activity Diagram(FIG-3.2)3.3 Sequence Diagram (FIG-3.

3)3.4 State Diagram (FIG-3.4)Data Dictionary Patient’s Database SchemaFIELD NAME DATATYPE(SIZE) CONSTRAINTS DESCRIPTIONP_id int(10) primary key Primary key of the columnP_fname varchar(20) Not null First name of the patient.P_lname varchar(20) Not null Last name of the patient.P_gender varchar(10) Not null Gender of the patient.

P_dob varchar(10) Not null D.O.B of the patient.P_userid int(10) Unique Unique userid of the patient.P_email varchar(50) Unique Unique email idof the patient.P_mobno varchar(10) Unique Unique mob no.

of the patient.P_bg varchar(3) Not null Blood group of the patient.P_height varchar(5) Not null Heightof the patient.P_weight varchar(5) Not null Weight of the patient.P_CM varchar(50) Not null Current medications of the patient.P_allergies varchar(50) Not null Patient having allergies P_history1 varchar(50) Not null Patient’s historyP_history2 varchar(50) Not null Patient’s historyP_diagnos varchar(50) Not null Patient’s diagnosP_habit varchar(50) Not null Patient’s habit Doctor’s Database SchemaP_id int(10) primary key Primary key of the columnP_fname varchar(20) Not null First name of the patient.P_lname varchar(20) Not null Last name of the patient.P_gender varchar(10) Not null Gender of the patient.

P_dob varchar(10) Not null D.O.B of the patient.P_userid int(10) Unique Unique userid of the patient.P_email varchar(50) Unique Unique email idof the patient.P_mobno varchar(10) Unique Unique mob no. of the patient.

D_degree varchar(10) Not null Degrees of the doctor.D_specification varchar(10) Not null Specialized area of the doctor.D_smc varchar(10) Not null Smc of the doctor.D_regno varchar(10) Unique Registration no.

of the doctor.D_add1 varchar(10) Not null Address of the doctor.D_add2 varchar(10) Not null Address of the doctor.

D_state varchar(10) Not null State of the doctor.D_postcode varchar(10) Not null Postcode of the doctor.D_city varchar(10) Not null City of the doctor.D_country varchar(10) Not null Country of the doctor.

4.3 Medicines Database SchemaFIELD NAME DATATYPE(SIZE) CONSTRAINTS DESCRIPTIONmed_id int(10) primary key Id of the medicine.drugName varchar(20) Not null Drug Name of the medicinesbrandName varchar(20) Not null Brand Name of the medicinesmanufacName varchar(10) Not null Manufacture Name of the medicinescomposition varchar(10) Not null Composition present in the medicinesusedFor varchar(50) Unique Use of the medicinesprescibedFor varchar(10) Unique Medicines prescribed for.desc varchar(10) Not null Description of the medicinesPrice varchar(10) Not null Price of the medicinessideeffects varchar(10) Not null Side Effects of the medicinessubstitute varchar(10) Unique Substitute of the medicinesdosage varchar(10) Not null Dosage of the medicineswarning varchar(10) Not null Warning of the medicines4.4 Disease Database SchemaFIELD NAME DATATYPE(SIZE) CONSTRAINT DESCRIPTIONds_id int(10) Primary key Disease’s Id.ds_name varchar(15) Not null Name of the disease.

ds_symptoms varchar(100) Not null Symptoms of the disease. Feedback Database SchemeFIELD NAME DATATYPE(SIZE) CONSTRAINT DESCRIPTIONf_id int(10) Primary key Feedback Id.f_name varchar(20) Not null Name of the person who submitted the feedback.f_message varchar(50) Not null Feedback message.4.6 User’s Database SchemeFIELD NAME DATATYPE(SIZE) CONSTRAINTS DESCRIPTIONu_id int(10) primary key Primary key of the columnu_fname varchar(20) Not null First name of the user.

u_lname varchar(20) Not null Last name of the user.u_gender varchar(10) Not null Gender of the user.u_dob varchar(10) Not null D.

O.B of the user.u_email varchar(50) Unique Unique email idof the user.u_mobno varchar(10) Unique Unique mob no. of the user.u_add1 varchar(50) Not null Address of the user.

u_add2 varchar(50) Not null Address of the user.u_state varchar(20) Not null State of the user.u_postcode varchar(10) Not null Postcode of the user.u_city varchar(20) Not null City of the user.u_country varchar(20) Not null Country of the user.u_role varchar(10) Not null Role of the userSNAPSHOT FUTURE ENHANCEMENTOnce the basic layout and functionalities of our system are designed, we plan to inculcate certain extra features into the system such as audio to text convertor feature, a video conferencing feature, feature to provide the facility of paying online to buy medicines, etc.

7. CONCLUSIONThe “Smart health consulting” Web Application is helpful for patients to search and consult the specialized doctors and get appropriate medicines . This application simplifies the task of a patient and the doctor. This application facilitates the interaction between patient and doctor. It helps to optimize the work of patient and doctor. Installation of the application in the Smartphone is quite simple. Smart health consulting system is an effortless, efficient and influential web application for the society.REFERENCESnevonprojects.comsmart health consulting.pdf

x

Hi!
I'm Casey!

Would you like to get a custom essay? How about receiving a customized one?

Check it out