INDUSTRIAL CUM SOFTWARE TRAINING REPORT

SUBMITTED IN PARTIAL FULFILLMENT OF THE DEGREE

OF

BACHELOR OF TECHNOLOGY

IN

COMPUTER SCIENCE AND ENGINEERING

SUBMITTED BY

NAME: Harpreet Kaur

ROLL NUMBER: 2130688

Under the Guidance of:

Faculty Mentor Name: Er. Priyanka Rani

Designation: Assistant Professor
Department: Computer Science Engineering

Organization: Gulzar Group of Institutes

 BTCS 801-20 SOFTWARE TRAINING REPORT

UNDERTAKEN AT

“PIXELS INFOSYS,MOHALI”

JAN to JUNE 2025

ON “Medicine Store Project”

SUBMITTED IN PARTIAL FULFILLMENT OF THE DEGREE OF
BACHELOR OF TECHNOLOGY

In

COMPUTER SCIENCE AND ENGINEERING

SUBMITTED BY

Harpreet Kaur (2130688)

Under the Guidance of:
Mentor Name: Er. Priyanka Rani Supervisor Name: Siya Thakur
Designation: Assistant Professor Designation: CEO & Co-founder
Department: Computer Science Engineering Department: Management

GULZAR GROUP OF INSTITUTES, LUDHIANA, PUNJAB

 DECLARATION

I hereby declare that the project work entitled (“Medicine Store Project ”) is an authentic record of my
own work carried out at (PIXELS INFOSYS,MOHALI) as requirements of four months Industrial
Training for the award of degree of B. Tech (Computer Science Engineering), Gulzar Group of Institutes,
Ludhiana, under the guidance of (MS.Siya Thakur) and (Er.Priyanka Rani), during (JAN) to (JUNE),
2025.

I hereby declare that the above statement made by me is correct to the best of our knowledge and belief.

(Signature of student)
Name of Student: Harpreet kaur
University Roll Number: 2130688
Date: June ,2025
 ACKNOWLEDGMENT

It is our pleasure to acknowledge the contributions of all who have helped us and supported us during this
Project report.

First, we thank God for helping us in one way or another and providing strength and endurance to us. We
wish to express my sincere gratitude and indebtedness to our supervisor, Supervisor Name, department
name, Gulzar Group of Institutes, Khanna, Punjab; for her/his intuitive and meticulous guidance and
perpetual inspiration in completion of this report. In spite of his/her busy schedule, he/she rendered help
whenever needed, giving useful suggestions and holding informal discussions. Her invaluable guidance
and support throughout this work cannot be written down in few words. We also thank her for providing
facilities for my work in the department name.

We are also humbly obliged by the support of our group members and friends for their love and caring
attitude. The sentimental support they rendered to us is invaluable and everlasting. They have helped us
through thick and thin and enabled us to complete the work with joy and vigor. We thank the group
members for entrusting in each other and following directions, without them this report would never have
been possible.

We are also thankful to our parents, elders and all family members for their blessing, motivation and
inspiration throughout our work and bearing with us even during stress and bad temper. They have always
provided us a high moral support and contributed in all possible ways in completion of this Capstone
report
INDEX

S.no. Title Page no. Signature

1 About the Company 3 – 10

2 Profile of problem assigned 11-13

3 Study Oof existing system 14

4 System requirement 15

5 Software Requirements: 16

6 Why choose Python 17-19

7 Libraries used to build project 20-37

8 CODE Snap Shots 38-44

9 Test plan 45-47

10 Output Screenshots: 48-59

11 Conclusion 50

12 Future Scope 51

13 References 52
 PIXELS
I N F O S Y S

Ref.No.: PI/6864
Date: 28/05/2025

INTERNSHIP CERTIFICATE

This is to certify that Ms. Harpreet Kaur D/o Mr. Ranjit Singh a student of
Gulzar Group of Institutes i currently pursuing an internship at Pixels Infosys
in the domain of Full Stack Web Development Intern.

She joined the internship program on 03 Jan 2025 and is actively involved in
various stages of Digital Marketing under the mentorship of our technical team.
The internship includes hands-on exposure to:

Assist in Frontend Development – Work on UI/UX using HTML, CSS,

JavaScript, and frameworks like React or Angular.
Support Backend Development – Help build and maintain APIs, databases,
and server-side logic (e.g., using Node.js, Python, Java).
Debug and Test Code – Identify bugs and fix them; write unit and integration
tests.
Collaborate with Teams – Work closely with designers, developers,
and project managers. Database Management – Create, update, and
query databases (e.g., MySQL, MongoDB).
Deploy Applications – Learn how to deploy web applications using tools like
Git, Docker, or cloud platforms (e.g., AWS, Heroku).

3
 Ms. Harpreet Kaur is demonstrating a keen interest in learning and contributing
to real-world projects as part of their professional development.

We wish her continued success during the remainder of the internship and in all
future endeavors.

Authorized
Signatory

com com

SCO-22, First Floor, Ansal City Center, Sector-115, Mohali +91-86990-

4
About the Company

ABOUT US

4
EXCELLENCE TECHNOLOGY (ET) is India based
leading strategic IT Company offering integrated IT
solutions with the vision to provide Excellence in software
solution. We at EXCELLENCE TECHNOLOGY bring
innovative ideas and cutting edge technologies into business
of customers. EXCELLENCE TECHNOLOGY is having
rich experience in providing high technology end to end
solutions in MOBILE APP AND WEB
DEVELOPMENT.

Figure 1.1
PHILOSOPHY

✔ To impart hard-core practical quality training among students/developers about latest

technologies trending today.
✔ To share knowledge of information security and create awareness in the market. The
solution to clients' as per the International standard practices and governance.
✔ To support good business practices through continual employee training and education

✔ To equip a local team with a strong knowledge of international best practices and
international expert support so as to provide practical advisories in the best interests of our
clients

5
OUR MISSION

To Protect Client's information system by

Detecting Threats, Deterring Attacks, and provide best
solution in the ever changing
Info - Security Challenges. We accomplish this by
integrating our People, Process, and Technology in the
most efficient way to increase value for all stakeholders

Figure 1.2

OUR SERVICES

✔ RISK Management Services

✔ Quality Control

✔ Business Process Re-Engineering

✔ Network Risk Analysis

✔ Software Testing

✔ Mobile Application Testing

✔ Wireless Penetration Testing

✔ Network Penetration Testing

✔ Application Security Testing

Figure 1.3

6
OUR SERVICES IN SOFTWARE DEVELOPMENT

We are proficient in all platforms of software Development practices — Agile, SCRUM, Lean,
Waterfall, Prototype, Incremental, Iterative, and
with the EXCELLENCE TECHNOLOGY experience the incredible services such as agile software
development and the problems related to outsourcing. We comprise of the team of experienced and
professionals members who with their skills efficiently get the job done and innovatively help you to
transform your ideas into the successful business.
Why Choose Us?

● Hundreds of Clients & Nearly a Decade of Experience

● Goal Oriented, ROI-Driven Focus

● A Streamlined / Quality-Driven Process

● Talented Designers & Expert Developers

● Our Websites & E-marketing Platforms are Easy to Manage

● We Are Dedicated to Our Clients’ Success

● EXCELLENCE TECHNOLOGY is steadfast to undertake the projects cutting edge to

technology competence and know-how abilities. The project execution is held with dedication
and responsibility to perform our best with the essence of knowledge, creativity and skills to the
utmost and efficiently.

● At EXCELLENCE TECHNOLOGY, we have competence to expand and adjust as per client

specific requirements.

● Skilled Workforce: At EXCELLENCE TECHNOLOGY you deal with the highly

professional and proficient employees.

● Cost Efficiency: We help you to reduce the unnecessary investment and ask for the reasonable
amount of money.

● Quality Of the Product: Our software service sector has been maintaining the highest
international standards of quality.

7
● Infrastructure: Well organized team and tools to handle the projects with responsible approach
Hardware, Software, Networking, Voice, Conferencing, disaster recovery all infra all you need
for international projects.

● Ongoing Involvement: EXCELLENCE TECHNOLOGY products are “built for change” as

we are well responsive that the necessity to improve a Web solution generally arises even before
the solution is out of the door. We delivers long-term product enhancement if desired.

● Partnership: EXCELLENCE TECHNOLOGY considers every client a partner. From the initial
stages, you are closely involved into the procedure of technical classification, development, and
testing.

8
9
OUR CLIENTS

10
11
KEY PROFESSIONALS:

In addition to a panel of eminent consultants and advisors, we have a dedicated pool of trained Developers
and Trainer, investigators, working under the guidance of professional managers. “A Ship is as good as
the crew who sail her.” Our Technical team of professionals handing, designing & delivering of projects
has a strong presence in the North India & the US. Our engineers are already working on the latest
technologies like I-Phone & Android Applications, Robotics, VLSI-VHDL, Embedded System,
Networking and Cloud computing. Some of the key professionals and advisors are listed below:

Mr. Deepak Kashyap: (Branch Manager)

He is the backbone of Excellence Technology and a man with more than 10 year rich practical experience
who believes in taking up new ventures and projects. Head-IT, Global Award Winner from India for
AGILE and OPEN GRAPH implementation in Sudan Taxation Chamber. Divisional Award and Star
Award Winner in Year 2011 for his exemplary work in process improvement for IT Service Delivery
Domains. MASTERS in Computer applications and Certified from PTU Certification. Holds total of 10
Years of rich experience including 5 Years in Information Security Implementation, Maintenance and
Auditing and initial over 10 years’ experience in Project Management, Client Relationship Management
and Server, Desktop and IT Service Delivery.

Ms. Sunita Thakur : (Dean Academics)

A Woman who believes that “Honour Time & Place, then you will be honoured.” She has more than 4
years solid industrial experience in a software companies & is very dashing and innovative in her technical
approach. MCA, Diploma in Information Technology, expertise in search engine optimization and web
designing.

Mr. Gurpreet Singh : (Technical Head - Python & GIT HUB)

A man who strongly feel that “Nothing is Impossible”. A very committed team leader who has been
professionally attached with Multinational companies for more than 18 years and has lead the marketing
teams in all states of North India.MCA (Engineering),in computer Science PTU Approved trained and
Certified. Successfully MCA master degree Training program for a leading Technology. Holds total of 5

12
Years of rich experience including 3 Years in Software developer, Maintenance and Auditing and initial
over 4 years experience in Project Management, Client Relationship Management and IT Service
Delivery.

Miss. Anjali Sharma : (Sr. Counselor)

A woman who believes that “Challenges are what make life interesting and overcoming them is what
makes life meaningful.” She has more than 3years experience in business development.B.A. – (Punjab
University) Lead Consultant - Due Diligence, Strategy, Operations, Business Continuity, Risk
Management, Mergers & Acquisitions.

Mr. Akshit Dogra : (Mechanical Head)

A man believes that “don’t wait for extra ordinary opportunities, seize common occasions and make them
great.” He has more than 4 years experience in marketing field.B.Tech (Mech), Engineer and Value, is a
approved by AICTE (HPTU). He is having total 5 years of experience in 3 years of experience in Autocad,
Solidworks, Catia, Pro-e, Ansys etc.

Mr. Paramveer Singh : (Mobile Application & Web Developer)

B.Tech(CSE) – IKG-PTU, Expertise in Reviewing current systems, Presenting ideas for web development
soft wares, including Application softwares, Working closely with analysts, Senior Developers,
Programmers, designers and staff, Producing detailed specifications and writing the program codes,
Testing the product in controlled, real situations before going live, Preparation of training manuals for
users and Maintaining the systems once they are up and running

Corporate Office: C-133, First Floor

Industrial Area, Phase-8, Sector-72, Mohali .
PH.:0172-4698755,93177-88822 ,93562-55522
E-MAIL: excellencehead@gmail.com,
URL: www.excellencetechnology.in

13
Profile of problem assigned

Medical store management systems are crucial tools for organizing and streamlining the operations of
pharmacies and healthcare facilities. These systems offer comprehensive functionalities to manage various
aspects of the medical store, ranging from inventory control to customer management and sales tracking.

Dealer Management:
Dealer management modules within medical store management systems enable pharmacies to efficiently
manage relationships with suppliers and vendors. They facilitate the procurement of pharmaceuticals,
medical devices, and other healthcare products by providing tools for order placement, invoice processing,
and inventory reconciliation. Through these modules, pharmacies can maintain up-to-date records of
supplier information, track purchase orders, and manage payment transactions, ensuring smooth and
reliable supply chain operations.

Medicine Management:
Medicine management functionalities empower pharmacies to effectively manage their medication
inventory, ensuring adequate stock levels and optimal storage conditions. These modules allow
pharmacists to categorize medications, track expiration dates, and monitor inventory levels in real-time.
Advanced features such as barcode scanning and batch tracking streamline inventory management
processes, enabling pharmacies to minimize wastage, prevent stockouts, and ensure compliance with
regulatory requirements.

Employee Management:
Employee management modules within medical store management systems facilitate the efficient
management of pharmacy staff, including pharmacists, technicians, and administrative personnel. These
modules streamline employee scheduling, time tracking, and performance evaluation processes, helping
pharmacies optimize workforce allocation and improve operational efficiency. Additionally, employee
management functionalities may include training and certification tracking, ensuring that staff members
remain compliant with industry regulations and best practices.

Customer Management:
Customer management modules enable pharmacies to build and maintain strong relationships with their
clientele by providing personalized service and tailored healthcare solutions. These modules capture and
store customer information, including prescription histories, medication preferences, and contact details,
allowing pharmacists to deliver personalized recommendations and medication counseling services. By
leveraging customer data and analytics, pharmacies can enhance patient engagement, improve medication
adherence, and drive customer loyalty and satisfaction.

Purchase Management:
Purchase management functionalities enable pharmacies to efficiently manage the procurement process,
from requisition and approval to payment and reconciliation. These modules streamline purchase
requisition workflows, automate purchase order generation, and facilitate vendor communication and

14
negotiation. By centralizing purchasing activities within the medical store management system,
pharmacies can optimize inventory levels, reduce procurement costs, and ensure timely delivery of
essential medical supplies.

In summary, medical store management systems encompass a comprehensive suite of functionalities that
empower pharmacies to streamline their operations, enhance customer service, and optimize resource
utilization. By integrating dealer management, medicine management, employee management, customer
management, and purchase management functionalities into a unified platform, these systems enable
pharmacies to achieve operational excellence, drive business growth, and deliver high-quality healthcare
services to their communities.

15
STUDY OF EXISTING SYSTEM

Studying an existing system for medical store management involves analyzing the various components,
processes, and functionalities of the system to understand its strengths, weaknesses, and areas for
improvement. Here's a general outline of how one might approach studying an existing system for medical
store management:
System Overview: Gain a comprehensive understanding of the current medical store management system,
including its objectives, scope, and the stakeholders involved (e.g., pharmacists, customers, suppliers).
Functional Analysis: Analyze the core functions and features of the system, such as inventory
management, sales and billing, prescription handling, customer management, and reporting capabilities.
Workflow Analysis: Map out the workflow and processes involved in various operations within the
medical store, including medication procurement, inventory replenishment, dispensing, and customer
interactions.
Data Management: Assess how data is collected, stored, processed, and secured within the system.
Consider data integrity, confidentiality, and compliance with relevant regulations (e.g., HIPAA in the
United States)

System Requirements

Problem statement
Today the internet and its boom have created a new economic scenario that not only stresses on the
classical concept of the“ product ” but also on the modern concept of “service”. It is this level of service
that dictates whether a commercial venture will succeed or not in the market. To provide a high
accessibility of service we will design the online shopping website, so that potential customers need not go
to a physical shop to buy products or services. There are several objective of this websites are following
given bellows.
•This site is gives all the information about the e-shopping to provide better service for the customer.
•It provides the facility to the customers who want to shop on-line due to lock of time.
•It provides facility to the customer to payment by the cash and cheque and DD also.
•It’s providing the full details about the product and related information about the product like cost, size
etc.
•With the help of it we can save the time and money also.
•it provides the remote shopping by the cash, or DD, or Debit card also.

Processing environment

Hardware requirements:
Windows

16
Microsoft® Windows® 7/8/10 (64-bit)
• 2 GB RAM minimum.
• 2 GB of available disk space minimum,
• 1280 x 800 minimum screen resolution
linux
• 64-bit distribution capable of running 32-bit applications
• 2 GB RAM minimum, 4 GB RAM recommended
• 2 GB of available disk space minimum
• 1280 x 800 minimum screen resolution

Software requirements:

Python 3.9.1 - Python 3.9.1 is the newest major release of the Python programming language, and it
contains many new features and optimizations. We've made 282 changes since 3.9.0 which is a significant
amount. To compare, 3.8.1 only saw 192 commits since 3.8.0
• Django 3.2.1- Django 3.2.1 is the newest major release
• PyCharm - PyCharm is a dedicated Python Integrated Development Environment (IDE)
providing a wide range of essential tools for Python developers, tightly integrated to create a
convenient environment for productive Python, web, and data science development

Solution strategy
Object Oriented Design
Object oriented design works around the entities and their characteristics instead of functions involved in
the software system. This design strategies focuses on entities and its characteristics. The whole concept
of software solution revolves around the engaged entities.
Let us see the important concepts of Object Oriented Design:
• Objects - All entities involved in the solution design are known as objects. For example, person,
banks, company and customers are treated as objects. Every entity has some attributes associated to it and
has some methods to perform on the attributes.
• Classes - A class is a generalized description of an object. An object is an instance of a class.
Class defines all the attributes, which an object can have and methods, which defines the functionality of
the object.
In the solution design, attributes are stored as variables and functionalities are defined by means of
mei3thods or procedures.
• Encapsulation - In OOD, the attributes (data variables) and methods (operation on the data) are
bundled together is called encapsulation. Encapsulation not only bundles important information of an
object together, but also restricts access of the data and methods from the outside world. This is called
information hiding.
• Inheritance - OOD allows similar classes to stack up in hierarchical manner where the lower or
sub-classes can import, implement and re-use allowed variables and methods from their immediate super
classes. This property of OOD is known as inheritance. This makes it easier to define specific class and to
create generalized classes from specific ones.

17
• Polymorphism - OOD languages provide a mechanism where methods performing similar tasks
but vary in arguments, can be assigned same name. This is called polymorphism, which allows a single
interface performing tasks for different types. Depending upon how the function is invoked, respective
portion of the code gets executed.

Feasibility analysis

Feasibility is the determination of whether or not a project is worth doing. The process followed in making
this determination is called feasibility study. This type of study determines if a project can and should be
taken. Once it has been determined that a project is feasible, the analyst can go ahead and prepare the
project specification which finalizes project requirements.

Different Type of Feasibility Study:-

In the conduct of the feasibility study, the analyst will usually considers even distinct, but inter- related
types of feasibility. They are Technical Feasibility Operational Feasibility Economic Feasibility Social
Feasibility Management Feasibility Legal Feasibility Time Feasibility
(1) Technical Feasibility:
This is concerned with specifying equipment and software that will successfully satisfy the user
requirement; the technical needs of the system may vary considerably, but might include: The facility to
produce outputs in a given time:
•Response time under certain conditions.
•Ability to process a certain volume of transaction at a Particular speed.
•Facility to communicate data to distant location. In examine technical feasibility; configuration of the
system is given more importance than the actual make of hardware. The configuration should give the
complete picture about the system’s requirement: How many workstations are required, how these units
are interconnected so that they could operate and communicate smoothly. What speeds of input and output
should be achieved at particular quality of printing. This can be used as a basis for the tender document
(2) Operational Feasibility:-
It is mainly related to human organization and political aspects. The points to be considered are:
•What changes will be brought with the system?
•What organizational structures are distributed?
•What new skills will be required? Do the existing staff members have these skills? If not, can they be
trained in due course of time? Generally project will not be rejected simply because of operational
infallibility but such considerations are likely to critically affect the nature and scope of the eventual
recommendations.

(3) Economical Feasibility:-

Economic analysis is the most frequently used technique for evaluating the effectiveness of a proposed
system. More frequently known as cost/ benefit analysis; the procedure is to determine the benefits and
saving that are expected from a proposed system and compare them with costs. If benefits outweigh costs,
a decision is taken to design and implement the system. Otherwise, further justification or alternative in
the proposed system will have to be made if it is to have a change of being approved. This is an ongoing
effort that improves in accuracy at each phase of the system life cycle

18
.(4) Social Feasibility:
Social feasibility is a determination of whether a proposed project will be acceptable to the people or not.
This determination typically examines the probability of the project accepted by the group directly
affected by the proposed system change.

(5) Management Feasibility:-

It is a determination of whether a proposed project will be acceptable to management .if does not accept a
project or gives a negligible support to it; the analyst will tend to view the project as a non-feasible one

.(6) Legal Feasibility:-

Legal feasibility is a determination of whether a proposed project infringes on known Acts Statutes, as
well as any pending legislation. Although in some instances the project might appear sound, on closer
investigation it may be found to infringe on several legal areas.

(7) Time Feasibility:

Time feasibility is a determination of whether a proposed project can be implemented fully within a
stipulated time frame. If a project takes too much time it is likely to be rejected.

Why i choose Python

Evolution of technology
Python was developed by Guido van Rossum in the late eighties and early nineties at the National
Research Institute for Mathematics and Computer Science in the Netherlands.
Python is derived from many other languages, including ABC, Modula-3, C, C++, Algol-68, SmallTalk,
and Unix shell and other scripting languages.
Python is copyrighted. Like Perl, Python source code is now available under the GNU General Public
License (GPL).
Python is now maintained by a core development team at the institute, although Guido van Rossum still
holds a vital role in directing its progress.
Python Features
Python's features include −
● Popularity: Python is one of the most popular programming languages for AI and machine
learning, with a large and active community of developers and researchers. This means that there
are many resources available for learning and troubleshooting, as well as a wide range of libraries
and tools for AI development.
● Ease of use: Python is known for its simplicity and readability, with a clean syntax and a focus
on code readability. This makes it an ideal language for beginners and experts alike, allowing for
rapid prototyping and development.
● Versatility: Python is a versatile language that can be used for a wide range of applications, from
web development to data analysis to AI and machine learning. This means that you can use

19
 Python for both front-end and back-end development, as well as for data preprocessing, analysis,
and modeling.
● Libraries and frameworks: Python has a rich ecosystem of libraries and frameworks for AI and
machine learning, including TensorFlow, PyTorch, scikit-learn, and Keras. These libraries
provide pre-built functions and modules for common AI tasks such as data preprocessing, feature
engineering, model training, and evaluation, allowing for faster and more efficient development.
● Integration with other tools: Python can be easily integrated with other tools and platforms,
such as databases, web frameworks, and cloud services. This allows for seamless data processing,
storage, and deployment of AI models.
● Easy-to-read − Python code is more clearly defined and visible to the
eyes.
● Easy-to-maintain − Python's source code is fairly easy-to-maintain.

● A broad standard library − Python's bulk of the library is very portable

and cross-platform compatible on UNIX, Windows, and Macintosh.
● Interactive Mode − Python has support for an interactive mode which
allows interactive testing and debugging of snippets of code.
● Portable − Python can run on a wide variety of hardware platforms and
has the same interface on all platforms.
● Extendable − You can add low-level modules to the Python interpreter.
These modules enable programmers to add to or customize their tools
to be more efficient.
● Databases − Python provides interfaces to all major commercial
databases.
● GUI Programming − Python supports GUI applications that can be
created and ported to many system calls, libraries and windows
systems, such as Windows MFC, Macintosh, and the X Window system of
Unix.
● Scalable − Python provides a better structure and support for large
programs than shell scripting.
Apart from the above-mentioned features, Python has a big list of good
features, few are listed below −
● It supports functional and structured programming methods as well as OOP.

● It can be used as a scripting language or can be compiled to byte-code for building large
applications.
● It provides very high-level dynamic data types and supports dynamic type checking.

● It supports automatic garbage collection.

It can be easily integrated with C, C++, COM, ActiveX, CORBA, and Java.

20
Libraries used to build project
Introduction to Django
Django is a web application framework written in Python programming language. It is based on MVT
(Model View Template) design pattern. The Django is very demanding due to its rapid development
feature. It takes less time to build application after collecting client requirement.
This framework uses a famous tag line: The web framework for perfectionists with deadlines.
By using Django, we can build web applications in very less time. Django is designed in such a manner
that it handles much of configure things automatically, so we can focus on application development only.
Django is widely accepted and used by various well-known sites such as:
• Instagram
• Mozilla
• Disqus
• Pinterest
• Bitbucket
• The Washington Times
Features of Django
• Rapid Development
• Secure
• Scalable
• Fully loaded
• Versatile
• Open Source
• Vast and Supported Community
Rapid Development
Django was designed with the intention to make a framework which takes less time to build web
application. The project implementation phase is a very time taken but Django creates it rapidly.
Secure
Django takes security seriously and helps developers to avoid many common security mistakes, such as
SQL injection, cross-site scripting, cross-site request forgery etc. Its user authentication system provides a
secure way to manage user accounts and passwords.
Scalable
Django is scalable in nature and has ability to quickly and flexibly switch from small to large scale
application project.
Fully loaded
Django includes various helping task modules and libraries which can be used to handle common Web
development tasks. Django takes care of user authentication, content administration, site maps, RSS feeds
etc.
Versatile
Django is versatile in nature which allows it to build applications for different-different domains. Now a
days, Companies are using Django to build various types of applications like: content management
systems, social networks sites or scientific computing platforms etc.
Open Source

21
Django is an open source web application framework. It is publicly available without cost. It can be
downloaded with source code from the public repository. Open source reduces the total cost of the
application development.
Vast and Supported Community
Django is an one of the most popular web framework. It has widely supportive community and channels to
share and connect

Introduction to SQLite
SQLite is embedded relational database management system. It is self-contained, server less, zero
configuration and transactional SQL database engine.
SQLite is free to use for any purpose commercial or private. In other words, "SQLite is an open source,
zero-configuration, self-contained, stand alone, transaction relational database engine designed to be
embedded into an application".
SQLite is different from other SQL databases because unlike most other SQL databases, SQLite does not
have a separate server process. It reads and writes directly to ordinary disk files. A complete SQL database
with multiple tables, indices, triggers, and views, is contained in a single disk file.
SQLite Features/ Why to use SQLite
Following is a list of features which makes SQLite popular among other lightweight databases:
• SQLite is totally free: SQLite is open-source. So, no license is required to work with it.
• SQLite is serverless: SQLite doesn't require a different server process or system to operate.
• SQLite is very flexible: It facilitates you to work on multiple databases on the same session on
the same time.
• Configuration Not Required: SQLite doesn't require configuration. No setup or administration
required.
• SQLite is a cross-platform DBMS: You don't need a large range of different platforms like
Windows, Mac OS, Linux, and Unix. It can also be used on a lot of embedded operating systems like
Symbian, and Windows CE.
• Storing data is easy: SQLite provides an efficient way to store data.
• Variable length of columns: The length of the columns is variable and is not fixed. It facilitates
you to allocate only the space a field needs. For example, if you have a varchar(200) column, and you put
a 10 characters' length value on it, then SQLite will allocate only 20 characters' space for that value not the
whole 200 space.
• Provide large number of API's: SQLite provides API for a large range of programming
languages. For example: .Net languages (Visual Basic, C#), PHP, Java, Objective C, Python and a lot of
other programming language.
• SQLite is written in ANSI-C and provides simple and easy-to-use API.
Introduction to HTML
• HTML stands for HyperText Markup Language.
• HTML is used to create web pages and web applications.
• HTML is widely used language on the web.
• We can create a static website by HTML only.
• Technically, HTML is a Markup language rather than a programming language.
Introduction to CSS
The major points of CSS are given below:
• CSS stands for Cascading Style Sheet.

22
• CSS is used to design HTML tags.
• CSS is a widely used language on the web.
• HTML, CSS and JavaScript are used for web designing. It helps the web designers to apply style
on HTML tags.

Introduction to Bootstrap
Bootstrap is the popular HTML, CSS and JavaScript framework for developing a responsive and mobile
friendly website.
Our Bootstrap tutorial includes all topics of Bootstrap such as jumbotron, table, button, grid, form, image,
alert, wells, container, carousel, panels, glyphicon, badges, labels, progress bar, pagination, pager, list
group, dropdown, collapse,tabs, pills, navbar, inputs, modals, tooltip, popover and scrollspy.
What is Bootstrap
• Bootstrap is the most popular HTML, CSS and JavaScript framework for developing a responsive
and mobile friendly website.
• It is absolutely free to download and use.
• It is a front-end framework used for easier and faster web development.
• It includes HTML and CSS based design templates for typography, forms, buttons, tables,
navigation, modals, image carousels and many others.
• It can also use JavaScript plug-ins.
• It facilitates you to create responsive designs.

Figure1.4

"https://www.javatpoint.com/bootstrap-example"→ HYPERLINK
"https://www.javatpoint.com/bootstrap-example" HYPERLINK
"https://www.javatpoint.com/bootstrap-tutorial" HYPERLINK

23
"https://www.javatpoint.com/bootstrap-example"← HYPERLINK
"https://www.javatpoint.com/bootstrap-example" Prev

What is Bootstrap
• Bootstrap is the most popular HTML, CSS and JavaScript framework for developing a responsive
and mobile friendly website.
• It is absolutely free to download and use.
• It is a front-end framework used for easier and faster web development.
• It includes HTML and CSS based design templates for typography, forms, buttons, tables,
navigation, modals, image carousels and many others.
• It can also use JavaScript plug-ins.
• It facilitates you to create responsive designs.

Figure1.5

History of Bootstrap
Bootstrap was developed by Mark Otto and Jacob Thornton at Twitter.It was released as an open source
product in August 2011 on GitHub.

24
In June 2014 Bootstrap was the No.1 project on GitHub.

Why use Bootstrap

Following are the main advantage of Bootstrap:
• It is very easy to use. Anybody having basic knowledge of HTML and CSS can use Bootstrap.
• It facilitates users to develop a responsive website.
• It is compatible on most of browsers like Chrome, Firefox, Internet Explorer, Safari and Opera
etc.

What is a responsive website

A website is called responsive website which can automatically adjust itself to look good on all devices,
from smart phones to desktops etc.

What Bootstrap package contains

Scaffolding: Bootstrap provides a basic structure with Grid System, link styles, and background.
CSS: Bootstrap comes with the feature of global CSS settings, fundamental HTML elements style and an
advanced grid system.
Components: Bootstrap contains a lot of reusable components built to provide iconography, dropdowns,
navigation, alerts, pop-overs, and much more.
JavaScript Plugins: Bootstrap also contains a lot of custom jQuery plugins. You can easily include them
all, or one by one.
Customize: Bootstrap components are customizable and you can customize Bootstrap's components,
LESS variables, and jQuery plugins to get your own style.

CODE Snap Shots

25
26
Figure1.5

27
28
Figure1.6

29
30
Figure1.7

31
32
 Figure1.8

TEST PLAN
1. Functionality Testing of a Website
Functionality Testing of a Website is a process that includes several testing parameters like user
interface, APIs, database testing, security testing, client and server testing and basic website
functionalities. Functional testing is very convenient and it allows users to perform both manual and
automated testing. It is performed to test the functionalities of each feature on the website.
Learn Java Programming with Beginners Tutorial
Web based Testing Activities includes:
Test all links in your webpages are working correctly and make sure there are no broken links. Links to be
checked will include -
• Outgoing links
• Internal links
• Anchor Links
• MailTo Links
Test Forms are working as expected. This will include-
• Scripting checks on the form are working as expected. For example- if a user does not fill a
mandatory field in a form an error message is shown.
• Check default values are being populated
• Once submitted, the data in the forms is submitted to a live database or is linked to a working
email address
• Forms are optimally formatted for better readability
Test Cookies are working as expected. Cookies are small files used by websites to primarily remember
active user sessions so you do not need to log in every time you visit a website. Cookie Testing will
include
• Testing cookies (sessions) are deleted either when cache is cleared or when they reach their
expiry.
• Delete cookies (sessions) and test that login credentials are asked for when you next visit the site.
Test HTML and CSS to ensure that search engines can crawl your site easily. This will include
• Checking for Syntax Errors
• Readable Color Schemas
• Standard Compliance. Ensure standards such W3C, OASIS, IETF, ISO, ECMA, or WS-I are
followed.
Test business workflow- This will include

33
• Testing your end - to - end workflow/ business scenarios which takes the user through a series of
webpages to complete.
• Test negative scenarios as well, such that when a user executes an unexpected step, appropriate
error message or help is shown in your web application.
Tools that can be used: QTP , IBM Rational , Selenium
2. Usability testing:
Usability Testing has now become a vital part of any web based project. It can be carried out by
testers like you or a small focus group similar to the target audience of the web application.
Test the site Navigation:
• Menus, buttons or Links to different pages on your site should be easily visible and consistent on
all webpages
Test the Content:
• Content should be legible with no spelling or grammatical errors.
• Images if present should contain an "alt" text
Tools that can be used: Chalkmark, Clicktale, Clixpy and Feedback Army

3.Interface Testing:
Three areas to be tested here are - Application, Web and Database Server

• Application: Test requests are sent correctly to the Database and output at the client side is
displayed correctly. Errors if any must be caught by the application and must be only shown to the
administrator and not the end user.
•
• Web Server: Test Web server is handling all application requests without any service denial.
•
• Database Server: Make sure queries sent to the database give expected results.
•
Test system response when connection between the three layers (Application, Web and
Database) cannot be established and appropriate message is shown to the end user.

Tools that can be used: AlertFox, Ranorex

4. Database Testing:
Database is one critical component of your web application and stress must be laid to test it thoroughly.
Testing activities will include-
• Test if any errors are shown while executing queries
• Data Integrity is maintained while creating, updating or deleting data in database.
• Check response time of queries and fine tune them if necessary.
• Test data retrieved from your database is shown accurately in your web application
Tools that can be used: QTP, Selenium
5. Compatibility testing.
Compatibility tests ensures that your web application displays correctly across different devices. This
would include-

34
Browser Compatibility Test: Same website in different browsers will display differently. You need to
test if your web application is being displayed correctly across browsers, JavaScript, AJAX and
authentication is working fine. You may also check for Mobile Browser Compatibility.
The rendering of web elements like buttons, text fields etc. changes with change in Operating System.
Make sure your website works fine for various combination of Operating systems such as Windows,
Linux, Mac and Browsers such as Firefox, Internet Explorer, Safari etc.

6. Performance Testing:
This will ensure your site works under all loads. Software Testing activities will include but not limited to
-
• Website application response times at different connection speeds
• Load test your web application to determine its behavior under normal and peak loads
• Stress test your web site to determine its break point when pushed to beyond normal loads at peak
time.
• Test if a crash occurs due to peak load, how does the site recover from such an event
• Make sure optimization techniques like gzip compression, browser and server side cache enabled
to reduce load times
7. Security testing:

Security Testing is vital for e-commerce website that store sensitive customer information like credit
cards. Testing Activities will include-

• Test unauthorized access to secure pages should not be permitted

• Restricted files should not be downloadable without appropriate access
• Check sessions are automatically killed after prolonged user inactivity
• On use of SSL certificates, website should re-direct to encrypted SSL pages.
•
8. Crowd Testing:You will select a large number of people (crowd) to execute tests which otherwise
would have been executed a select group of people in the company. Crowdsourced testing is an interesting
and upcoming concept and helps unravel many a unnoticed defects.

O/P screenshot

Current Snapshots:

35
 Figure1.9
Landing page

36
 Figure1.10

Login page

37
 Figure1.11

Signup page

38
Figure1.12

39
Previous order page

Figure1.13

page Cart

40
 Figure1.14

Admin panel

41
 Figure1.15

Product category management panel

42
 Figure1.16

Customer details management panel

43
 Figure1.17

Order management panel

44
 Figure1.18

Product management system

Conclusion

45
Concluding a medical store management project in Django would typically involve summarizing the key
features, highlighting any challenges encountered, discussing potential future improvements, and
expressing overall thoughts on the project.
Key Features:
User Authentication: Implementing user registration, login, and logout functionality to ensure secure
access to the system.
Product Management: Allowing users to add, update, delete, and view medical products, including
details like name, quantity, price, and expiration date.
Inventory Management: Tracking the availability of products in real-time, sending alerts for low stock
items, and managing stock levels effectively.
Order Management: Enabling users to place orders, track order status, and manage order history.
Billing and Invoicing: Generating bills and invoices for orders, calculating total costs, and providing
printable receipts.
Reporting: Generating reports on sales, stock levels, revenue, and other relevant metrics to facilitate
decision-making.
Search and Filters: Implementing search and filter functionality to easily locate products based on
various criteria.
Security: Ensuring data security through proper authentication, authorization, and encryption techniques.
Challenges Encountered:
Data Modeling: Designing the database schema to accurately represent the relationships between
different entities like users, products, orders, etc.
UI/UX Design: Creating an intuitive and user-friendly interface for managing complex functionalities like
inventory and orders.
Performance Optimization: Optimizing database queries, caching frequently accessed data, and
minimizing load times for better performance.
Testing: Ensuring comprehensive testing to identify and fix any bugs or errors, especially in critical
functionalities like authentication and billing.
Deployment: Deploying the application to a production environment securely and efficiently, considering
factors like scalability and reliability.
Future Improvements:
Integration with Payment Gateways: Adding support for online payments to streamline the checkout
process.
Barcode Scanning: Integrating barcode scanning functionality to simplify inventory management and
product identification.
Automated Notifications: Implementing automated notifications for order status updates, stock
replenishment, and other relevant events.

Localization: Supporting multiple languages and currencies to cater to a diverse user base.

Enhanced Reporting: Improving reporting capabilities with advanced analytics and visualization tools
for better insights into business performance.

Overall Thoughts: Developing a medical store management system in Django can be a challenging but
rewarding experience. By leveraging Django's built-in features like authentication, ORM, and admin
interface, developers can build robust and scalable applications tailored to the specific needs of medical

46
stores. However, attention to detail, thorough testing, and continuous improvement are essential to ensure
the success and effectiveness of the system.

Future scope

The future scope for a medical store management project in Django can be quite expansive, with
possibilities for enhancing existing features and adding new functionalities to meet evolving needs. Here
are some potential future scope areas for such a project:

Integration with Electronic Health Records (EHR) Systems: Integrating the medical store management
system with EHR systems can streamline the process of accessing patient prescriptions and medical
history, enabling pharmacists to provide more informed and personalized care.

Telemedicine Integration: Facilitating telemedicine consultations and prescriptions within the system can
offer added convenience to patients and improve accessibility to healthcare services.
Machine Learning for Demand Forecasting: Implementing machine learning algorithms to analyze past
sales data and predict future demand for various medical products can optimize inventory management
and ensure adequate stock levels.

Smart Inventory Management: Leveraging Internet of Things (IoT) devices and sensors to monitor
inventory levels in real-time, automate stock replenishment, and prevent stockouts or overstocking.

Mobile App Development: Developing a mobile application companion for the medical store management
system can enable pharmacists to manage inventory, process orders, and engage with customers on the go.
Customer Relationship Management (CRM) Features: Incorporating CRM functionalities to track
customer interactions, preferences, and purchase history, allowing for personalized marketing campaigns
and loyalty programs.

Regulatory Compliance: Staying up-to-date with regulatory requirements and implementing features to
ensure compliance with pharmaceutical regulations, including tracking of expiration dates, batch numbers,
and prescription validation.

Enhanced Reporting and Analytics: Expanding reporting capabilities with advanced analytics tools for
generating insights into sales trends, profitability analysis, and supplier performance evaluation.
Supply Chain Optimization: Collaborating with suppliers and distributors to streamline the supply chain
process, reduce costs, and improve delivery efficiency through features like electronic ordering and
vendor management.

Integration with Financial Systems: Integrating with accounting and financial management systems for
seamless invoicing, billing, and financial reporting.

Patient Education and Medication Adherence: Providing educational resources and reminders to patients
about medication usage, dosage schedules, and potential side effects to improve medication adherence and
health outcomes.

47
Blockchain for Drug Traceability: Implementing blockchain technology to ensure the authenticity and
traceability of pharmaceutical products throughout the supply chain, enhancing patient safety and
combating counterfeit drugs.

Geolocation-Based Services: Utilizing geolocation data to offer location-based services such as nearest
pharmacy locator, home delivery options, and real-time traffic updates for delivery logistics.
Continued Security Enhancements: Strengthening security measures to safeguard sensitive patient
information, including encryption of data at rest and in transit, multi-factor authentication, and regular
security audits.

By incorporating these future scope areas into the medical store management project, developers can
create a comprehensive and innovative solution that addresses the evolving needs of the healthcare
industry and provides value to both pharmacists and patients.

48
References Links:
● Django Documentation: https://docs.djangoproject.com/en/

● Django Class-Based Views: https://docs.djangoproject.com/en/stable/topics/class-based-views/

● Django Admin Panel: https://docs.djangoproject.com/en/stable/ref/contrib/admin/

● Django URL Dispatcher: https://docs.djangoproject.com/en/stable/topics/http/urls

● Django Templates: https://docs.djangoproject.com/en/stable/topics/templates/

● Bootstrap Documentation: https://getbootstrap.com/docs/5.1/getting-started/introduction/

● Tailwind CSS Documentation: https://tailwindcss.com/docs

● Django Authentication: https://docs.djangoproject.com/en/stable/topics/auth/

● Django Search Functionality: https://docs.djangoproject.com/en/stable/topics/db/search/

● Django Signals: https://docs.djangoproject.com/en/stable/topics/signals/

These references provide comprehensive documentation and resources for various aspects of Django
development, web design, and project management, aiding in the development and enhancement of the
Django blog project.

49