Posted at 11.02.2018
Every person has to book session in GP or clinic before their trip to organization (unless in emergency). The net based appointment scheduling system simplifies the night out, time, and selection of doctor, changing or modifying patient details. Because the internet has become an important part of the lives, organizations either smaller businesses or big establishments make it part of these business functionalities. The technology is broadening day by day and online options are also increasing too. According to Hacker, "Simple access, increased availability of information, and the prosperity of web services have universally increased output and functional efficiencies (Hacker, 2008)". The online system has changed complete track record of information exchange. This research is also related to develop of web based appointment booking system where individual only must type Link provided and they can get access to it from anywhere in the world and any moment. The system allows patient to sign in, register, and reserving appointment where they'll be in a position to choose time, particular date and choose with their doctor. The introduction of web based system can be quite demanding if the machine was planned prior to design. The system will reduce burden of work load of their employees and staff could be more efficient. The research will hold before start developing a system it can help to choose right tools, systems. The system will certainly reduce queues in GP.
The use of online appointment arranging system allows customer to book appointment anytime for example if indeed they want to reserve appointment at midnight so they will be able to make it without looking forward to GP to open in morning hours and than call to GP because cell phone booking appointment system will continue to work only once GP is available but online appointment scheduling system will continue to work all the time 365 days in a calendar year.
It is important to learn how appointment is performed currently in company. The currently visit done physically or through mobile phone in which the patient receive choice of schedules when they visit their GP or hospital and it should be approved by the member of staff. If patient book their visit through telephone than they need to wait for automated machine to answer and than choose available day and book visit. If patient need confirmation then they have to go to GP personally or choose option to send notice by post. This type of situations business lead to waste products of time, money and it may put load of time and strain on the administrative staffs as well. As there are human beings involved in the whole process there are high likelihood of human errors. The booking visit through mobile phone or personally going there the staff can access wrong details and also when personnel booked the appointment for person then there could be some fault. So by considering all these points the development of online system will help GP's or any company to overcome many of these problems by providing an online service to do their arranging and also to choose their desire date and select them online.
The online arranging system will not work in case there is emergency. In crisis there are always places open to go right there, this technique is wonderful for normal booking to go to to see doctor for regular check-up.
The rational of this research is to build up a online appointment scheduling system and execution of system for GP's and other company. The development of web based visit system is to conquer the problems faced by the users and staffs while scheduling their visit for regular check-up. The appointment booking is very important to any company to deal their user more efficiently. As we talked about in the background of the study there may be some human error. That is why the development of the system is selected which can only help organisation to provide quality service by providing their users online online appointment scheduling system.
The main reason for developing this task is to identify the user needs, to meet those needs by selecting the best method of achieve the goals of the project. The implementation of the project can help the organisation to lessen the time for customer to book visit. It may also reduce newspaper work, queuing at the GP's reception, because the major services will be provided online. The implementation of this system will also help company fiscally as well as for their users and it will saves lots of your energy. The implementations of web based appointment arranging system also support multiple users at the same time so the system will efficient.
Aim: To create and implement the Web based online session reservation system within time.
The research will perform to collect necessary information for designing a system for GP or medical center.
To develop the system, some interviews have to be conducted among people to understand issues with system.
The Feasibility study for implementing the system will conduct and the primary target will be on scalability issues. As the GP keeps growing rapidly the system should support any future expansions such as increasing quantity of users.
The systems that required to develop the system
Client/server architecture (Online consumer server applications), Requirement gathering and analysing techniques (the interviews will be do and also questionnaires), HTML, XHTML, consumer side, server technology (PHP, ASP. NET)
Relation database (Oracle, My SQL), System screening tools
The research will be done to understand the range of project.
The interview and questionnaires will be conducted to acquire user requirements and analyse them to develop a system.
System modelling and prototyping
The programme dialect which going to utilize should be suitable.
The testing condition will identify.
Testing and implementation
The system has to test before deliver to consumer to check on that developed system is working properly and it fulfils requirements. The machine will check confirmation and validation.
The helpdesk will be provided for customer if end user face any problem of developed system.
The current system allows consumer to book appointment throw cellphone or user must go to GP to reserve appointment. This may result such for as long queue at the GP, clinics. Only few GP's using online scheduling system. There are a few possibilities of problems such as users do not know about the web booking of the appointment. In case if end user need to book appointment for repeat visit than they have to go every time to book visit and problem is that users can miss their do it again visit because they didn't have time for you to go or telephone line was busy. The queue at GP's will put pressure on the staff and may take more time.
It is important that complete project should fulfil all the requirements of system and also how system will continue to work, top features of system and features. The system works on the basis of authentications and authorizations which is achieved by providing the initial ID which is username and password to each end user. The patient can select of these desired particular date and time and also in a position to change if they want to. The online booking system will not work in case there is emergency. In emergency there are always places available to go directly there, this technique will work for normal booking to visit and discover doctor for regular check-up.
1. 5 Expected final results:
This is a real time project, therefore the purpose of this project is to develop a online appointment scheduling system for GP and Hospitals where users will in a position to reserve appoint from anywhere in world. This is a customer and server software where customer will be used for just coming into the info and submitting it. The server side will be capable of processing.
This is educational level project, which means structure of the project will be little bit different than the most common professional project. Professional people usually have relevant knowledge about how to help make the project however in academic level scholar first learn then make it into practice than they offer the application form.
Theory Practice Application
1. 6 Risk in this Job and way of minimization:
The recognition of risk in projection development is important because risk can put project on halt or destroy complete project. The project dangers are those which will affect the quality and performance of job (Summerville I 2001). Some of the hazards are highlighted are below.
The event of hardware problem can occur while a whole lot of software has been used to develop a system. So laptop can crash. The virus can be in charge of laptop crash. To conquer this issue the code always saved on another device like (display drive or friend computer). So if the computer crashed than the old code can be taken without sacrificing anything. That is one task risk.
The software installation and making interconnection between them is is actually a problem. Installing Mysql software, apache server and make interconnection between apache, PHP and Mysql. Because of this problem first all software will be use but if there is problem then Xampp where the old code can be generate. This is a project risk.
The Tools and software is always important for development any sort of task. If some software is giving error while development a system then there is always new software is open to use.
The Time period limit into any task is a high risk. If time is not enough then it will lead to have an impact on the performance of system and also quality. For instance if any hardware problem or software problem happen in development of job where at all times is put in then by the end is not enough time to finish job. In his case the introduction of project will keep on and delivered just as much done on 19h of November.
The participation of real human into anything can postpone. If individual is controlling a project you can find chances that person get sick that will delay the job. If this happens then try to finish project on time but if could not then sent on 19th Novemberas much as is possible.
Plan risk management approach
Risk management plan
Project objective achieved
Analyze the task to recognize the resources of risk
Assess the risk in conditions of:
Severity of impact
Likelihood of occurrence
Aim to reduce possible damage
Create contingency plans
Implement risk strategy
Monitor and adjust arrange for possible new risk
Change Management, if possible
Figure Risk Management Process
The technology which is use to build up a system are followed. The machine will develop using back-end and front-end technology.
XHTML: The XHTML will be utilized for web software.
CSS: The CSS use to enhance site for better view.
MySQL: The MYSQL is a repository language, it will be used to store data source.
PHP: The server aspect programming will be done with PHP.
Apache Web Server: This use to test the machine before put into practice system.
Chapter 2 Literature Review
According to Burke "Job management, Control and Management Techniques". This booklet will give idea about "what should be Aims and Purpose of project". This booklet described that how to find a good AIMS and Goal of project. Employing this book it help me to give idea about my task Aims and purpose. The Goals and objective is most important part of task which will lead my project throughout the end. So this e book helps me a lot to achieve perfect Seeks and object for my job.
According to Stein in "How exactly to setup and maintain the web page" is defined about how to create a site and also how to keep up about development. This helps me throughout job to construct web pages. The technology HTML, PHP and JAVA are detailed with illustrations. Stein has defined everything in details about technology which can help full for newbie and also for pros.
The appointment reservation system is very important to perform organisation successfully. The GP's appointment reservation system is important because everyone who would like to be observed by doctor should make appointment. The GP's (NHS) appointment system is always in information for delays, patient were not in a position to see doctor when they want. The federal government always bring in new system to tackle the problem, the federal government introduced SMS system as well as online scheduling for some GP's. Both national study were released in 1998 and 2000 highlighted the issue in being able to access GP's. The federal government was promised that by 2004, patient will be able to see primary care within 24 hours and GP with in 48 hours. The obtain appointment into GP is becoming very important. The brand new GP contract in UK. The National Key Treatment Development Team(NPCDT) was create to deliver the government's modernisation agenda in primary good care by using the national primary care collaborative to put into practice change.
The solution is based on five principles, namely:
understand the access demand on the practice
clear the backlog of appointments
review the session system
develop contingency plans
broaden the method of patient assessment.
" http://www. biomedcentral. com/1471-2296/6/39"
The web based appointment reservation system will help customer sociologically because some people does not prefer to hear machine voices for example mobile phone appointment booking system customer will call and automated machine will answer and that will put customer away because they do not like and online appointment reservation system will appeal to more customer.
The other problem is that if disable person want to reserve appointment with GP or hospital by cellphone than person has to hang on until carer should come and contact for visit because largely GP phone appointment booking system goes in morning hours most GP want their patient to call for appointment in morning hours.
The NHS introduces new Arrange for primary good care in England assures access to healthcare professional within a day and Doctor (GP) within 48 time. The brand new plan is given financial helps to achieve targets. The brand new plan allows patient to see GP of these choice, the main focus on achieving targets may lead to reduced selection of doctor.
The National Main Care and attention Development Team (NPDT) has find out that some general practioner (GP) have used a restricted scheduling. They have limited the choice for pre arranging visits or completely stoped. The NPDT didn't allow that since it will frustration among those individuals who want to book appointment in advance (Uk Journal of General Practice, 2004).
The NPDT evaluation was predicated on interviews conducted in the East Midlands, study centre. The target was on patients and carers. The acceptance has been taken from Leicester Research Ethics Committee, 41 interviewees were recruited through 14 GP and even more 15 were recruited from other group, such as community centres, a charity. At least you have used their GP practice once in last a year. The participants were interviewed in 2002 and 2003 and interviews were noted (British Journal of General Practice, 2004).
The another problem is GP mobile phone appointment booking system will only work until GP is wide open and mobile phone is enroll in by employee after concluding time phone session booking system will not work.
The job development approach is all about that what type of software project going to do and how much information about system already accumulated. According to the project we've idea about problem recognise the business is facing and what can do to new system to appeal to the attention of users towards the business. So it is confirmed that we need to build a site where customer and company can catch the attention of each other. Just for this we have to visit company and try to find out just what they expect and will help them to increase their business. The info which has already been collected will be very useful to build a project.
The project development approach which is known as in development is Incremental Development way. This approach starts off from the initial planning and it will end when development of system is completed. In this process the development is done in small part and it'll help develop next level. The advantage of this approach is that the machine is split into different stages once first stage is completed then the next stage begins. This approach includes Initialization step as of this step the basic idea of system is created and directed at company with some features. If the organization is satisfy then the next level which is redesign and applied and also analyzing the current system. The development of project carries on step by step. The following steps which is important while developing a project.
Designing of project
Writing of coding
Testing of the codes
The development of system and also operation of each section will process step by step. The each step features will be processed and if it's successful then consider as a project part. The strategy give clear proven fact that project, the task is completed at detail by detail as in this way it is straightforward to find error and fix them as compare to by the end when it's very challenging to find and fix.
2. 1 Issues with current system
The problem using phone appointment reserving system is always staff is not absolve to answer call and other is customer must wait around in a queue to be replied call and it could take up to minutes.
The other problem is that sometime operator make a blunder and ignore to book session and without booking appointment disconnect call and customer will think appointment has been booked whatever particular date they want but regrettably when they go for check-up there is absolutely no visit for customer into system because staff did not put into dairy products. Another problem is that the individual can reserve their session only that point when GP is open up they would not be able to book appointment all the time.
The current system only works by a member of staff, it costs more than online appointment system. The business has to retain more staff to run organisation. You will find quantity of other system in place in several locations like in a few GP's automated mobile phone system is also set up which operates 365 days and nights in yr but problem with that some individuals does not like to wait long time for to get answered and also some people does not like to select machine. This kind of system put people off to use that system.
The current system which is mobile phone reservation system people may well not use because it is costly to gain access to for example if patient need to book appointment they have to call plus they need credit in their mobile to call GP. So in this case some people may not like to spend their money, nor use system but as compare to online system they just pay small money and access many things and gladly use new system. The other problem is that the individual do not need to speak their personal details publically so they need to find private destination to cellphone GP and e book appointment.
Integrating system with the various tools to be used
The PHP is a server-side scripting vocabulary that allows website to be truly active (Naramore E. et al, 2005). The PHP can be used widely for standard purpose scripting terminology and it can be used with wide open source HTML. The PHP was at first developed to design a dynamic Sites additionally it is HTML embedded. The PHP can also use as a graphical software. The PHP was made in 1995 by Rasmus Lerdorf and it's been in development regularly.
The PHP works on server so we used WAMP server to run PHP language on computer the PHP is very user friendly terminology. The PHP productivity is mostly in HTML. The PHP is having over 20 million internet domain name (Apr 2007). The PHP used to build up a website it is simple to use and it could be downloaded free and it will give effect quickly.
The PHP used to gain access to database because it provide fast usage of database. The use of PHP is ideal for example if patient demand a page, the server which is apache will implement PHP script and send outcome to show on webpage. The PHP is a only execute code which is written within its delimiters if anything written outside that then it will come as a result as you written. The PHP will be utilized to validation the webpages and it is based on server side and validate demands of users.
The Database is place where all the data will stored about patient details their visit. It is easy to find databases on every type of computer systems i. e. personal computer, large computer. My SQL give a facility to take care of and control a relational database in very useful way.
The Databases Management system is employed to allow data source to create furniture. In addition, it let create relationship, overseas key, and most important key and insert data into stand in form of rows and columns. My SQL will be used as the databases for our project. It is open source database and even more than 10 million copies of My SQL are downloaded by an individual / Programmers. My SQL is owned by sunlight Microsystems. It had been first produced by the Swedes and Fin in Sweden.
Advantages of using MYSQL are implemented.
Performance is great.
Easy to understand and use.
Connectivity with web pages is simple.
Interface is simple.
MySQL, pronounced as "my sequel", stands for My Set up Query Vocabulary. MySQL is a relational database system and free software. MySQL is very fitting software to make use of while producing the proposed system since it is open source software and can work as either a databases management system or a relational repository system.
Because of its open source feature, which means that anyone can download it free of charge, use the software and can adjust it as they please and never have to pay anything. MySQL will allow PHP and the Apache server to interact to be able to get access to data and display them in a far more readable format in a browser.
The WAMP is a server bundle which is individually created program and installed on Microsoft home window. The WAMP offer components are Apache, MYSQL and PHP. The Apache is a server which uses to implement PHP code and MYSQL is a repository which used to build data source for patient and also their appointment booking details.
The WAMP make the computer server and computer serves such as a server to run webpages and helps individual to work with all services on same computer. In some package also include phpmyadmin which can be used to provide a graphical software of MYSQL databases. The WAMP is user friendly which is absolve to download. It really is a minuscule server and works on all servers.
The appropriate structures has to place in and examined that structures. The multi-tier architecture can be acquired (known as n-tier architecture) which is client and server architecture. One of the most communally used architecture is 3-tier architecture because it is a lot secure compare to other architecture (2-tier architecture). The benefit for using tier architecture is that an individual only put in a particular layer alternatively than writing a fully software again. The 3-tier structures uses a middleware. The middleware is a covering which is between consumer and server which does not allow client to access database immediately.
The good thing about using 3-tier architecture is that there is no need of connection with database from every client only from server side. It make sure that only valid data is up to date, So the consumer doesn't have direct access to database it makes business more secure because the repository of customer is located on server part. The task is also customer server centered so 3-tier structures is used to be sure that the machine is much secure and middleware will there be to provide a security to databases. The clients send a get to server then server process it and send back again to client.
The data source need to upgrade only on server part each time if some changes eventually database and it generally does not disturb all clients. The 3-tier program is much difficult to compare to 2-tier application to develop but it is provide much higher security to organisations and their consumer as well. The info or functions which can be critical are not processed on consumer aspect all critical function or data are prepared on server aspect. The 3-tier is associated numerous databases however in this technique the database used is MYSQL which is associated with MYSQL as well.
The information move on both direction between customer and server and one consumer can send a number of get to server and server process them (comer E, 2001). Therefore the 3-tier application can be used which is a lot secure and communally used structures.
Figure 1: 3-tier Architecture Model
2. 7 Web Security
The web security is a crucial component for just about any online business. The web security is very important when developing something which is web based, the developer should consider this. The user must be fully satisfied that all the data which is given is confidential. The net security will identify threats and it will take more time to recover dangers. The client and also server both area have to be guaranteed while they will work with web security. But there are the positive area which offers two protocols to secure the ease of access online through Secure Socket Covering (SSL) and Secure HTTP. "SSL uses open public key authentication and encryption technology and the SSL handshake process should be completed before an application is transmitted or received. Secure HTTP relates to security over the overall socket based mostly communication and facilitates encryption methods at the application form layer.
Chapter 3 Research Methodology
3. 1 Available Researches
The research method is that how the data is going to collect for task. This part will show the technique which has been used to carry out whole research. There are plenty of research methodologies available such as quantitative research, qualitative research, exploratory research, primary data collection, secondary data collection and empirical research.
The main data collection is acquire a data from real world which include concentrate group, taking an experimental methodology, experience gained from history. It also include the formal and casual interviews and combined this with the info which accumulated from secondary method ie, books, publications and internet etc. The data which is accumulated through observation is given less importance because observation is not perfect always
Research Method Used
The research method is important and research method which is utilized for job is Action Research Method. This strategy means simply "learning by doing", identify the situation. The action of system will be looked at and if final result is fine that is good in any other case it'll start process from same point again. The study method is secure and effective in way of accuracy and reliability. This research method is mainly used. This research method will continues working until problem resolved. This kind of research method is also known as qualitative research method. In this technique feasibility research will be taken to establishing interviews and conversations with organisation because they are users.
Chapter 4 Design
The design of project is important so design will be made before start creating a project i. e. the various tools like use case and also use entity relational diagram to show relation.
The use circumstance is a user interface between user and a system. The use case diagram use to display a relationship between celebrities and use situations. The main the different parts of use circumstance diagram are acting professional and use circumstance, an acting professional in this technique is the individual who uses this system to booking appointment.
The user access a web page (website) which uses to see a user about effectiveness and efficiency of the machine. An individual then can click on health news, opening time and session booking to sign in and choose night out and time and also choose of doctor to book their session.
Choose Time and Time
GP Or Hospital
In this diagram implies that patient can Sign-up their details with GP or Medical center, SIGN IN, Visit web page and main thing is they can make session where they can pick night out and time which can be found.
4. 2 Entity Relation Diagram
Primary and overseas secrets are also set up between the entities, in the accounts table primary key has been identified to username As a unique number is allotted to each and every Product in the repository it is taken in to factor for the principal key. In book table main key has been described to ref has been allocated to each appointment. In registration desk also ID is major key.
Screen Shot of Main Page
The display screen shows the main page of web site design.
Chapter 4 Timeline
It is actually important to calculate the time for your project which shows us the length of time the project will take to be completed (Dawson, 2005). Because the project will demand lot of your energy additionally it is very significant to do the planning very well. Amount 2 shows the task breakdown of the entire task and duration for every duties and it describes the basic journey completely from the initiation to the closing of the task.
Figure 2 Gantt graph for the whole project
As proved in the Gantt graph the project is designed to be done in fourteen weeks and six days and nights time which is 73 days and nights in total. You can find ten milestones that require to be performed during the complete project life circuit. After each milestone is achieved the task will reach the closing phase and so the planning is performed.
Chapter 5 Paperwork:
The project is split into these stages to develop
Definition, Planning, Design and Research, Code/structure and Tests.
The classification is first step of job where the challenge is defined and then detects a way for further progress.
The Planning step is vital because planning of any project to lead success of job. In this task the planning is performed of project to solve problem.
The next thing is design of system which is also important in this period different tools to be used to design the system (use case, ERD, Photoshop).
After designing is performed then program writing language used to build up a system.
The evaluation will be done when the system is completed and it is in working condition. The trials will be done to make project mistake free.
Chapter 6 Execution/Testing
Once the project is completed or some function is working than testing will be perform to check on if the function which is established is working. The evaluation will be done while developing web pages because by the end if trials will be achieved than it probably will be hard to find errors within project so error recognition will be done at each stage and sort them. For Implementation and Testing For instance if Registration Page for patient has been created than it probably will be tested to check on if it is working as it ought to be, The screen shot of working function of registration page is adopted.
Screen shot of Enrollment page
There were lots of constraints in this job, as it is difficult to find the professionals and personnel to interview. The other limitation was an usage of resources and the primary limitation was a time that was less. If enough time is given more than the project could be better in performance maybe it's more stuff to research and integrated. If the time is given more than can get help of folks to editing.
Chapter 6 Conclusion
The conclusion is that online appointment reservation system will be advantage for the GP's or clinics. The machine will be developed and will fulfil the user requirements and the system requirements. This research also express the perfect solution is of problem which GP is facing and it will resolved by the proposed system. It will also be time conserving and being able to access system will be easy because the services provided through the data source design and methodology implemented. The system also supports multiple users at a time so it will be also helpful to the users and administrators of the organisation.
Although the developed system may be run into with problems in everyday activity cases, it is significant to store the associated documents carefully so the future researchers can have more knowledge involved with it using their experience. Particularly because of this paper, it will help the reader to understand that how to chose the methodology for the underlying research, how to plan for that and the way the design should be achieved as a developer.
Connolly, T. , & Begg, C. (2010). Database Systems - A Useful Approach to Design, Execution, and Management (5th Model ed. ). Pearson Release Inc.
Elmasri, R. , & Navathe, S. (2007). Basic principles of Database Systems. USA: Pearson Education Inc.
Hacker, A. J. (2008). Need for Web Application Firewall Technology for Protecting Web-Based Resources. ICSA an unbiased Department of verson Business, pp. 2-3.
Harter, D. E. , Mayuram, K. S. , & Sandra, S. A. (2000). Ramifications of Process Maturity on Quality, Routine Time, and Work in Software Product Development. Journal of Management Knowledge, 451-466.
Kaplan, B. , & Duchon, D. (n. d. ). Incorporating Qualitative and Quantitaive Methods in Information Sytem Research: A Case Study. Qualitative and Quantitative Methods, p. 573.
Kerner, S. M. (2010, Sept 13). Developer: InternetNews. Retrieved july 12, 2010, from InternetNews. com: http://www. internetnews. com/dev-news/article. php/3631831/Is-PHP-The-Cure-For-The-Broken-Web. htm
Orfali, R. , Harkey, D. , & Edwards, J. (1999). Customer/Server Survival Guide (3rd Edition ed. ). Canada: John Wiley & Sons Inc.
Peffers, K. , Rothenberger, M. , Tuunanem, T. , & Chatterjee, S. A Design Research Technique for Information Systems Research. Journal of Management Information Systems, 24 (3), 1-3.
Schwalbe, K. (2007). Information Technology Project Management, 5th Model. Thomson Course Technology.
Tutanescu, I. , Sofron, E. , & Ali, M. (2010). Security of Internet-Connected Computer Systems. International journal of Internet Technology and Secured Trades, ii (1/2), 109-121.
Whittaker, B. (1993). What went incorrect? Information Management & Computer Security, 23-24.