Dr.

Babasaheb Ambedkar Technological University, Lonere

Maharashtra

A PROJECT REPORT ON

Doctors Appointment
In partial fulfilment of the requirement for the award of the Degree of
Bachelor of Technology in Computer Science & Engineering

Submitted by
Student Name : Asha Dandge
: Akash Hajre
PRN : T2021121191005
1921121242010

Under the Guidance of

Guide Name Dr.P.S.Deshpande B.E, M. Tech (Qualification)
Assistant Professor/ Associate Professor/ Professor (Designation)
Department of CS & E

Department of Computer Science & Engineering

Shreeyash College of Engineering & Technology

(Approved by AICTE, New Delhi, Accredited by NAAC, New Delhi & Affiliated to DBATU)
2023
 SHREEYASH COLLEGE OF
ENGINEERING & TECHNOLOGY
(Affiliated to DBATU, Lonere, MAHARASHTRA)

Department of Computer Science & Engineering

CERTIFICATE
Certified that the project work entitled Doctors Appointment is a bona-fide work carried out
by Asha Dandge , Akash Hajre in partial fulfillment for the award of BACHELOR OF
TECHNOLOGY in COMPUTER SCIENCE & ENGINEERING of Dr. BABASAHEB
AMBEDKAR TECHNOLOGICAL UNIVERSITY, LONERE, MAHARASHTRA. It is
certified that all correction/suggestion indicated for internal Assessment have been incorporated
in the report deposited in the departmental library. The project seminar has been approved as it
satisfies the academic requirement in respect of project work prescribed for the Bachelor of
Technology Degree.
Asha Dandge : T2021121191005

Akash Hajre : 192112124201

.........……………………… ...…………………………
Prof. (Guide Name) B. Tech, M.E Vijay Kumar M P B.E, M. Tech
Assistant Professor Assistant Professor
Project Guide Project Coordinator

......…………...…………… ……………………….....
Dr. P. S. Deshpande B. Tech, M.E, Ph. D (IIT Roorkee) Dr. B. M. Patil B. E, M. Tech, Ph. D (IIT Roorkee)
Head of the Department Principal
 The project report entitled

“Title of the Project/ Internship/ Mini

Project/ Seminar

Asha Dandge:T2021131191005
Akash Hajre : 192112124201

Is approved for the degree of Bachelor of Technology (Computer Science & Engineering)
award by Dr. Babasaheb Ambedkar Technological University, Lonere, Maharashtra.

Internal Examiner: External Examiner:

Name: Name:
Sign: Sign:
Date: Date:

Date:

Place:Ch.Sambhjinagar
 INDEX

Sr.No. Name Page No.

1 Synopsis 5
1.1 Introduction to project
1.2 Purpose of the system
1.3 Scope
1.4 Technology Used
1.5 System Requirement
1.6 Overview
2 System Analysis
2.1 Introduction

2.2 Analysis Model

2.3 Study of the system

2.4 System requirement specification

3 Feasibility Report

3.1 Economical Feasibility

3.2 Technical Feasibility

3.3 Operational Feasibility

3.4 Behavioral Feasibility

Sr.No. Fig Name Page No

1 7
 1. SYNOPSIS

1.1 Introduction to project :

The Online Doctor Appointment Booking System PHP and Mysql is a simple project
developed using PHP, JavaScript, and CSS. The project contains an admin and user sides. The
admin side manages all the management like managing schedules, patient records and manage
the appointment time, manage treatment facilities, and so on. The admin has an important role
in the management of this Online Doctor Appointment Booking System PHP and Mysql

1.2 Purpose of website :

Purpose of the website is to simplify appoint between doctor and patients.

1.3 Scope :
The scope of the project is the system on which the website is easily access, i.e. the
project is developed as a website. But later on, the project can be modified to operate
it online. User can easily book an appointment.

1.4 Technology Used:

Language:- PHP
1.4.2 Backend: - My SQL

1.5 Minimum System Requirement:

1.5.1 Minimum RAM: - 256MB

1.5.2 Hard Disk: - 40GB

1.5.3 Processor: - Intel Pentium4

1.5.4 Operating System: - Windows XP ServicePack2

5
1.6Overview :

The Online Doctor Appointment Booking System PHP and Mysql is a simple
project developed using PHP, JavaScript, and CSS. The project contains an admin and user sides.
The admin side manages all the management like managing schedules, patient records and
manage the appointment time, manage treatment facilities, and so on. The admin has an
important role in the management of this Online Doctor Appointment Booking System PHP and
Mysql.

i. User has following rights:

a. View facilities
b. Available Doctors
c. Time
ii. Admin has following rights:
a. Can check records
b. Can make change in records.

2. SYSTEM ANALYSIS:-

2.1 Introduction:
After analyzing of the task to be performed, the next step is to analyze
the problem and understand its context. The first activity in the phase is studying the existing
system and other is to understand the requirements and domain of the new system. Both the
activities are equally important, but the first activity serves as a basis of giving the functional
specifications and then successful design of the proposed system. Understanding the properties
and requirements of a new system is more difficult and requires creative thinking and
understanding of existing running system is also difficult improper, understanding of present
system can lead diversion from solution.

2.2 Analysis Model:

SDLC Methodologies:

In the spiral model, software development is carried out in four main phases which
are shown as the four quadrants.

6
 The first quadrant identifies the objectives of the product and the alternative
solutions possible .In the second quadrant, the alternative solutions are evaluated and the
potential project risks are identified and deal with by developing and appropriate prototype. A
project risk is essentially any adverse circumstance that might hamper successful completion of
the software project. Thus, the spiral model provides direct support for coping with project
risks. The activities in the third quadrant consist of developing and verifying the next level of
the product. Finally, the fourth stage consists of reviewing the results of the stages traversed of
are with the customer and planning the next iteration around the spiral. With each iteration
around the spiral a more complete version of the software gets build respectively. Usually, after
several iterations along the spiral, all risks are resolved and the software is ready for
development. At this point, a waterfall model of software development is adopted. The radius
of the spiral at any point represents the cost incurred so frant the project, and the angular
dimension represents the progr ess.

7
 2.3 Study of the System:
In the flexibility of the uses the interface has been developed a graphics
concept in mind, associated through a browser interface. The GUI’S at the top level has
been categorized as.

2.3.1 Administrative user interface.

2.3.2 The operational or generic user interface.

The administrative user interface has a broad range of administrative

privileges across a single website primarily managing the infrastructure of site contents.
The administrator easily manages the products, categories, order and shipping. The tasks
related to upload of images for our website are done by the administrator.
The operational or generic user interface can check the product details.
Website is so user-friendly and user can check the product details also, website will show
genuine products because of each user would not be confused about to buy things are not.
User can apply coupon code to get the exciting offers too, after purchasing the product user
will have to feel their details and the product ordered by user will be delivered safely and
swiftly at the given address.

2.4 System Requirement Specification:

SRS has two main parts

• Software
• Hardware

(1) Minimum Hardware Requirements:

All physical requirements i.e. input devices, processor, output devices and inter-
connecting processor of the computer is called Hardware.

• Minimum RAM: - 4GB RAM

• Hard Disk: - 40GB
• Processor: - I4
• Operating System: - Windows 11 ServicePack2

(2) Software Requirement:

• PHP
• Windows 10/11
• MySQL

8
3. FEASIBILITY REPORT:-

The two criteria to judge feasibility are cost required and value to be attained. As
such, a well-designed feasibility study should provide a historical background of the project,
description of the product or service, accounting statements, details of the operations and
management, marketing research and policies, financial data, legal requirements. Generally,
feasibility studies precede technical development and project implementation.

3.1 Economical feasibility:

Economic analysis is the most frequently used method for evaluating the effectiveness of
a new system. More commonly known as cost benefits analysis the procedure is to determine
the benefits and savings that are expected from a candidate system and compare the with
costs. If benefits out weight cost, then the decision is made to design and implement the
system. An entrepreneur must accurately weight the cost versus benefits before taking an
action.

3.2 Technology feasibility:

The assessment is based on an outline design of system requirements, to determine

whether the company has the technical expertise to handle completion of the project.

At this level, the concern is whether the proposal is both technically feasible (assuming
moderate cost).

3.3 Operational feasibility:

Operational feasibility is a measure of how well a proposed system solves the

problems, and takes advantage of the opportunities identified during scope definition and how
it satisfies the requirements identified in the requirements analysis phase of system
development.

9
 3.4 Behavioral Feasibility:

The system working is quite easy to use and learn due to its simple but attractive interface.
User requires no special training for operating the system.

4. Working of Present System:-

In the present system all work is done on paper. The whole session attendance is
stored in register and at the end of the session the reports are generated. We are not
interested in generating report in the middle of the session or as per the requirement because
it takes more time in calculation. At the end of session, the students who don’t have75%
attendance get a notice.

Disadvantages of Present Working System:

• Custom layouts are hard to use: The first downside is the layout which can be seen. They
might be customized, but they can be tricky to navigate through if you are not skilled enough.
The same goes for the design process when it comes to designing.

• Lots of updates: It’s a essentially running on your server which requires update. The updates
are going to be constant during the use.

• Manual control: All calculations to generate report is done manually so the res greater chance
of errors.

• Time consuming: Every work is done manually so we cannot generate report in the middle of
the session or as per the requirement because it is very time consuming.

10
 5. Characteristic of the Proposed System:-

Word-Press combines simplicity for user & publishers with under the hood complexity for
developers. This makes it flexible while still being easy to use following is a list of some of the
feature that comes as standard with word-press.

1) Simplicity:-Simplicity makes it possible for you to get online & get Nothing

publishing Quikly should get in the way of you getting your website up & content out of there.

2) Flexibility:- Flexibility with Word-Press , we can create any type of website we want a
personal blog or website , a photoblog a business website , a professional portfolio. We can
make our website beautiful with themes & extend it with plugins.

3) User Management:- Not everyone requires the same access to your website. Administrators
manage the site , editors work with content , authors & contributors write that content &
subscribers have a profile that they can manage . This lets you have a variety of contributors to
your website .

4) Easy Theme System:- Word-Press comes bundled with three default themes , but if they are
not for you there is theme directory with thousands of themes for you to create a beautiful
website upload your own theme with the click of button.

5) Easy Installation & Upgrades:- Word-Press has always been easy to install & upgrade plenty
of web hosts offer one click word-press installers that let you install word-press with will just
one click you can create database upload word-press using FTP & run the installer.

11
6. INTRODUCTION TO SELECTED SOFTWARE:-

6.1 INTRODUCTION TO PHP FRAME WORK:

PHP frameworks streamline the development of web applications written in PHP by

providing a basic structure for which to build the web applications. In other words, PHP frame
works help to promote rapid application development (RAD), which saves you time, helps build
more stable applications, and reduces the amount of repetitive coding for developers.
Frameworks can also help beginners to build more stable apps by ensuring proper database
interaction and coding on the presentation layer. This allows you to spend more time creating
the actual web application, instead of spending time writing repetitive code.

The general idea behind the working so for PHP framework is referred to as Model View
Controller (MVC). MVC is an architectural pattern in programming that isolates business logic
from the UI, allowing one to be modified separately from the other (also known as separation
of concerns). With MVC, Model refers to data, View refers to the presentation layer, and
Controller to the application or business logic. Basically, MVC breaks up the development
process of an application, so you can work on individual elements while others are unaffected.
Essentially, this makes coding in PHP faster and less complicated.

Developers should utilize PHP frameworks for various reasons, but the number one reason is
for speeding up the development process. Reusing code across similar projects will save the
developer a substantial amount of time and effort. A framework offers pre-built modules for
performing tedious coding tasks, so the developer can spend their time on developing the
actual application rather than re-building the foundation with each and every project.

12
Versions:

The PHP Frame work stack:

Version Released Date Supports Until

1.0 8 June 1995

2.0 1 November 1997

3.0 6 June 1998 20 October 2000

4.0 22 May 2000 23 June 2001

4.1 10 December 2001 12 March 2002

4.2 22 April 2002 6 September 2002

4.3 27 December 2002 31 March 2005

4.4 11 July 2005 7 August 2008

5.0 13 July 2004 5 September 2005

5.1 24 November 2005 24 August 2006

5.2 2 November 2006 6 January 2011

5.3 30 June 2008 14 August 2014

5.4 1 March 2012 3 September 2015

5.5 20 June 2013 10 July 2016

5.6 28 August 2014 31 December 2018

6.0 3 December 2015 3 December 2018

6.1 1 December 2016 1 December 2019

6.2 30 November 2017 30 November 2020

6.3 6 December 2018 6 December 2021

13
 6.2 My SQL:

Introduction My SQL:-

My SQL is an open source relational database management system (RDBMS). Its name Is
combination of "My", the name of co-founder Widenius daughter, and "SQL", the abbreviation
for Structured Query Language.

My SQL is free and open-source software under the terms of the GNU General Public License,
and is also available under a variety of proprietary licenses. My SQL was owned and sponsored
by the Swedish company My SQL AB, which was bought by Sun Microsystems (now Oracle
Corporation). In 2010, when Oracle acquired Sun, Widenius for ked the open-source My SQL
project to create Maria DB.

My SQL is a component of the LAMP web application software stack (and others), which Is an
acronym for Linux, Apache, My SQL, Perl/PHP/Python. My SQL is written in Can C++.Its SQL
parser is written in yacc, but it uses a home-brewed lexical analyzer.

My SQL was created by a Swedish company, My SQL AB, founded by David Ax mark, Allan
Lars so and Michael "Monty" Widenius. Original development of My SQL by Widenius and Ax
beginning1994.[24]The firstversion of My SQL appeared on 23 May 1995. It was initially created
for personal usage from SQL based on the low-level language ISAM, which the creators
considered tools own and inflexible. They created a new SQL interface, while keeping the same
API as MY SQL. By keeping the API consistent with them SQL system, many developers werabl
to use My SQL instead of the (proprietarily licensed) My SQL antecedent.

14
 Version of My SQL:

Version Version Number Released Date End of Support

5.1 5.1.73 03 December 2013 December 2013

5.5 5.5.62 22 October 2018 December 2018

5.6 5.6.43 21 January 2019 February 2021

5.7 5.7.25 21 January 2019 October 2023

8.0 8.0.15 01 February 2019 April 2026

7. SYSTEM DESIGN:-

7.1 Introduction:-

Software design sit sat the technical kernel of the software

engineering process and is applied regardless of the development paradigm and area of
application. Design is the first step in the development phase for any engineered product or
system. The designer’s goal is to produce a model or representation of an entity that will later
be building. Beginning, once system requirement has been specified and analyzed, system
design is the first of the three technical activities-designs, code and test that is required to build
and verify software.

The importance can best at end with asingle word “Quality” Design is a place where
quality is fostered in software development. Design provides us with representations of
software that can assess for quality

15
 Design is the only way that we can accurately translate a customer views in to a finished
software product or system. Software design serves as a foundation for all the software
engineering steps that follow. Without a strong design we risk building and unstable system-
one that will be difficult to test, one whose quality cannot be assessed until the last stage.

During design, progressive refinement of the data structure, program structure, and
procedural details are developed reviewed and documented. System design can be viewed
from either technical or project management perspective. From the technical point of view,
design is comprised a four activities-architectural design, data structure design, interface
design.

7.2 ER-DIAGRAM:-