Chapter 1
Chapter 1
Chapter 1
Entierro St., Angeles City started on August 1996 under sole proprietorship and operated by Dr. Romina Feliciano dela Cruz specialized in teeth whitening, cleaning, check ups, composite fillings, tooth extraction and orthodontics. Basically, patients spend a substantial amount of time in clinics waiting for services to be delivered by the doctor. The degree to which the patients are satisfied with the care received is relative not only to the doctors expertise in their field, but also to the quality of the clinic management. Clinic operates in First come First serve basis. Priority will be given to patients who came first and settled their appointments. The recent patient database system of the clinic was written in an index card and kept in a little cabinet. For some reason, records are overwritten, loss and difficult to retrieve. .Every patients information was recognized, recorded and updated by the manual record system of clinic. Manual inventory system was monitored by the dental clinics assistant. All records of inventories are written in a log book for information retrieval purposes.
Statement of the Problem The propose system is an Online Management System that will develop a web-based application and will minimize all paper works, and advertising procedures. Significant problems that are to be resolve are as follows: Reservation procedures have overlapping records of patient schedules. The recent system has no updating capability. In an everyday scenario some of patient cant keep punctuality, taking other costumer time, leaving their time vacant and some of customers wont come at all. Lack of immediate retrieval and storing of data. The information is very difficult to retrieve and to find particular information. The clinic is not well known thats why theres just a little number of patients coming. The current inventory system cannot be updated easily because it is done manually.
To develop anonline clinic management to support R.P. Feliciano Dental Clinic. Specific Objective: To make an online Reservation System for Dr. Feliciano Dental Clinic. To develop Database System for easy retrieval and storage of information. To upgrade the advertising system of the clinic that will help increase the number of patients. To develop an inventory system that will easily update the doctors assistant from current number of stocks.
Statement of Scope
The focus of this study is for the development of an online management system which computerizes and stores data for accessibility and portability. The system has a secure log-in for doctor and staff. Base on the specific need of the clinic, the proponent decided to use and limit the study on four systems namely; Reservation System, Database System, Advertising system, and Supplies Inventory system, Accounting Management System. o Reservation system is a system which organizes the schedule of the patient and doctor. o Database system secures the retrieving and storing of data. o Advertising system is a system where the main page content can be updated by an admin user. o Inventory systems maintain and provide access to the records, efficiently and timely.
Software Context
The Software Context contains fours systems namely; Reservation, Patient History and treatment performed, Content Manager and materials inventory system.
Patient
Super Admin
Admin
Register
Admin
Database
Log-in
Reservation
Patient
Database
The four systemsare also divided into level of access according to their use. Such as; patient login, Admin and super admin. Patient login is a part of main system where the patient can register and log-in to be able to reserve the intended time. Super admin is also a part of main system in which the admin can add, activate or deactivate an admin. The admin is a part of subsystem where the admin can view reservation and content editing only.
Major Constraint
The Major Constraint brings out the value of the study; the relevance of the results; for whom the results will be relevant; what is already known about your research problem; what has not been adequately answered; how will your research add to knowledge/ practice/ policy; how will it be useful for policy makers.
1.) Socio-economic significance.In this study, the proposed system will inspireother students to develop an effective and efficient system. 2.) Technological significance.The proposed system will introduce technology tothe medical clinics that are until now adapting the manual method of clinic management.The result of this study is beneficial to the following: a.) Clinic.The proposed system will simplify and automate everyday clinic tasksand can help maximize time spent with clients thereby providing better servicemaking itmore profitable. b.) Doctors.The proposed system will make it easier for the doctors to manage theclinic and convenient when it comes to retrieving patient records. c.) Doctors staff.Doctors secretary can benefit a lot from this study, asthey are an integral part of the whole clinic management. d.) Patients.Patients are the doctors principal assets.And the reason why thisstudy is conducted is to provide a solution to doctors need to better serve their patients. e.) Researchers.The researchers have developed their writing, analysis, andinterpretation skills needed to make a good thesis. f.) Future Researcher. The Future researchers have reference in enhancing their own research and further, to help the other researchers as well.
Visual Model
Request Schedule
Take Request
Doctor
The actors are Patient, Assistant and doctor Patient request for the availability of the schedule and summarize by the assistant to present to the doctor. The doctor finalizes the request to produce final schedule of each respective schedule of the patient.
Patient Info
Patient
Super Admin
Admin
Register
Patient Database
Log-in
The Management system involves three entities to use the system. Patient, super admin and admin. Patient need to be registered or login before viewing the reservation. Admin can do all the privileges as super admin except add, activating and deactivating other admin. The admin privileges are updating inventory, content editing, cancelling time schedule in reservation.
Existing Level-0
Patient
Reservation
Reques
Schedule_info
Summary_Info
0
Reservation
Patient _Info
Assistant
Patient request will be forwaded and summarize to the assistant . Summary info will be analyze and schedule info will be generated by the doctor.
Level-1
1 Patient Request_info
Get patient request info
Schedule_info
Patient info 1
Reservation Schedules
Reservation_info
Doctor
Assistant
Reservation_Request 3
Patient request will be processed and summarized by the assistant. The request summary from assistant will be validated from doctor schedule to produced final schedule to the patient.
Patient
Reservation Request
Reservation_info
Reservation _Info
Patient_info
Patient
Reservation_Info
Reservation Request
Doctor Reservation
Schedule_Info
System
Reservatio_Summary_Info
Inventory_info Reservation
Assistant Inventory Summary Request
Patient
History/Treatment
Check
2 Content_Check
Content
Manager
Content_info
Last February 6, 2012, we implemented our system. We prepared for the registration of domain and hosting of our website. We presented the system to the company and we instructed them on how to use it. Fortunately, we heard good comments coming from the dentist and her assistant regarding to the system that we have presented. During the testing of the system, we tried to register an account and we encountered some problems while trying the reservation.
To secure the system, we install captcha in it to protect the website against bots by generating and grading tests that humas can pass but current computer programs cannot. It also restricts various automated programs to sign-up E-mail accounts, prevents spam, protects website registration, hides the e-mail address and asks the users to enter the text in the picture to show the e -mail.This help to prevent scrapers from sending to the e-mails which is known as the Online Polls.