Medical Store Management System
Medical Store Management System
A A
X-Window Lab Project X-Window Lab Project
Submitted Submitted In partial fulfillment In partial fulfillment For the award of the Degree For the award of the Degree
of of
Bachelor of Technology Bachelor of Technology In Department of
In Department of Computer Science &Computer Science & Engineering Engineering (With specialization in
(With specialization in software engineeringsoftware engineering))
Supervisor
Supervisor Submitted Submitted ByBy
Ms.
Ms. Tanuja Tanuja Rajput Rajput Mukesh KumarMukesh Kumar Assoc.
Assoc. Professor Professor Enroll. Enroll. No.No. – – CP10101408698 CP10101408698
Department of
Department of Computer ScienceComputer Science & & EngineeringEngineering Suresh Gyan Vihar University
Suresh Gyan Vihar University Mahal, Jagatpura, Jaipur Mahal, Jagatpura, Jaipur
CERTIFICATE
CERTIFICATE
This is to certify that Project Report entitled Medical store(Online medical store management This is to certify that Project Report entitled Medical store(Online medical store management system) which is submitted by
system) which is submitted by Mr. Mukesh Kumar in partial fulfMr. Mukesh Kumar in partial fulfillment of the requirement forillment of the requirement for the award of B. Tech. degree in department of Computer science and Engineering is a record of the award of B. Tech. degree in department of Computer science and Engineering is a record of the candidate(s) own work carried out by him / them under my/our supervision. The matter the candidate(s) own work carried out by him / them under my/our supervision. The matter embodied in this thesis is original and has not been submitted for the award of any other degree. embodied in this thesis is original and has not been submitted for the award of any other degree.
Signature Signature
Name of Supervisor
Name of Supervisor – – Ms. Ms. Tanuja Tanuja RajputRajput Designation
Designation Date
DECLARATION
DECLARATION
I/We hereby declare that this submission is my/our own work and that, to the bes
I/We hereby declare that this submission is my/our own work and that, to the best of my/ourt of my/our knowledge and belief, it contains no material previously published or written by another person knowledge and belief, it contains no material previously published or written by another person nor material which to a substantial extent has been accepted for the award of any other degree nor material which to a substantial extent has been accepted for the award of any other degree or diploma of the university or other institute of higher learning, except where due
or diploma of the university or other institute of higher learning, except where due acknowledgment has been made in the text.
acknowledgment has been made in the text.
Signature Signature
Name :- Mukesh Kumar Name :- Mukesh Kumar
Enrolment No. CP10101408698 Enrolment No. CP10101408698 Date
ACKNOWLEDGEMENT
ACKNOWLEDGEMENT
It is great pleasure to acknowledge the support of many people who have contribute to the It is great pleasure to acknowledge the support of many people who have contribute to the successful completion of this project. This project would never have seen the light of the day successful completion of this project. This project would never have seen the light of the day without the help and guidance that I have received, I am profoundly grateful for the support, without the help and guidance that I have received, I am profoundly grateful for the support, co-operation and valuable guidance extended by Ms. Tanuja Rajput .
operation and valuable guidance extended by Ms. Tanuja Rajput . Also I Would like to sincere gratitude to Ms. Tanuja Rajput
Also I Would like to sincere gratitude to Ms. Tanuja Rajput , Assistant Professor of Suresh, Assistant Professor of Suresh Gyan Vihar University for his valuable advice and kind
Gyan Vihar University for his valuable advice and kind of encouragement as internal guide duringof encouragement as internal guide during the whole process from time to time. She always been a source of inspiration? Without their the whole process from time to time. She always been a source of inspiration? Without their encouragement and help this project would not have materialized
encouragement and help this project would not have materialized
Last but not the least; we would like to express our sincere thanks to our Family member Last but not the least; we would like to express our sincere thanks to our Family member and our friends for their constant encouragement.
and our friends for their constant encouragement.
Signature Signature Name
Name – – Mukesh Kumar Mukesh Kumar
Enrolment No. CP10101408698 Enrolment No. CP10101408698 Date
Abstract
Abstract
Medical Shop Management System is anMedical Shop Management System is an website project developed for medical shops. website project developed for medical shops. This sys-This sys-tem is a field concerned with pu
tem is a field concerned with purchasing and selling medicines, maintaining their inventory, gen-rchasing and selling medicines, maintaining their inventory, gen-erating sales invoices and gengen-erating reminders of expiry date about medicines. It requires more erating sales invoices and generating reminders of expiry date about medicines. It requires more time and effort when all procedures are
time and effort when all procedures are performed manually.performed manually.
Thus, in order to reduce time consumption and human effort the Medical Shop Management Thus, in order to reduce time consumption and human effort the Medical Shop Management Sys-tem application can be applied in medicals where manual procedure exists. The purpose of this tem application can be applied in medicals where manual procedure exists. The purpose of this project is to reduce time consumption and human effort. This application provides user friendly project is to reduce time consumption and human effort. This application provides user friendly
interface as well. interface as well.
INTRODUCTION
INTRODUCTION
1.2
1.2 PROJECT PROJECT DESCRIPTIONDESCRIPTION
Pharmiz the complete medical shop manage
Pharmiz the complete medical shop management software is so designed as to ease ment software is so designed as to ease the workthe work load of medical shop professionals. The main feature
load of medical shop professionals. The main feature includes invoicing, inventory and stockincludes invoicing, inventory and stock control, accounting, client and vendor management
control, accounting, client and vendor management
This software helps you to track all the profits, loss, profitable clients and This software helps you to track all the profits, loss, profitable clients and products of medical shop moreover it’s a medical shop accounting software. Flexible and
products of medical shop moreover it’s a medical shop accounting software. Flexible and adaptive software suited to medical shops or stores or pharmacies of any size.
adaptive software suited to medical shops or stores or pharmacies of any size. 1.3
1.3 PROJECT PROPOSALPROJECT PROPOSAL
A transfer is a lateral m
A transfer is a lateral move to a position in the same classified pay range (clasove to a position in the same classified pay range (classified position) sified position) oror to a
to a position with comparable duties and responsposition with comparable duties and responsibilities (non-ibilities (non-classified positioclassified positions).ns).
Eligibility:-All non-faculty employees are eligible for transfer after being employed in their present
All non-faculty employees are eligible for transfer after being employed in their present position position for
for atleast atleast three mthree months. onths. In additIn addition, an ion, an employee memployee must hust have been ave been performing performing in in a sata satisfactoryisfactory manner in his/her current job. Exceptions to the
manner in his/her current job. Exceptions to the three month employmentthree month employment requirement may berequirement may be authorized by the President on a
authorized by the President on a case-by-case basis.case-by-case basis.
Procedures:-➢
➢ Employees are considered as candidates for transfer in the following order or Employees are considered as candidates for transfer in the following order or priority:priority:
➢
➢ Eligible employees in same department as the job openingEligible employees in same department as the job opening
➢
➢ Eligible employees in other departments who Eligible employees in other departments who have requested a have requested a transfertransfer
➢
➢ Eligible employees being considered for lay-off due to Eligible employees being considered for lay-off due to a reduction in forcea reduction in force Employees desiring a transfer will submit a
Employees desiring a transfer will submit a written request for transfer to his/her written request for transfer to his/her departmentdepartment head. The employee should
head. The employee should identify the specific vacancy in which they identify the specific vacancy in which they are interested. Theare interested. The department head will forward the request to the Department of Human
department head will forward the request to the Department of Human Resources forResources for recommended action.
recommended action.
The Department of Human Resources will determine whether the
The Department of Human Resources will determine whether the desired job or a desired job or a suitable jobsuitable job opening
opening exists. Iexists. If a suitaf a suitable job is ble job is available, the available, the Department of Department of Human Human Resources wiResources willll arrangearrange for the employee's
for the employee's application to be reapplication to be reviewed by the departmviewed by the department in which openinent in which opening g exists.exists. Employees will be allowed tim
Employees will be allowed time off with pay for job interviews related to transe off with pay for job interviews related to transfers. fers. The decisionThe decision to effect the transfer will be made by the head
to effect the transfer will be made by the head of the department in whichof the department in which the job opening occurs.
the job opening occurs. An employee who
An employee who is transferred to a comparable job (lateral transfer) will continue to receiveis transferred to a comparable job (lateral transfer) will continue to receive his/her existing rate of pay.
his/her existing rate of pay.
ABOUT THE PROJECT ABOUT THE PROJECT
➢
➢ A person from any department should be able toA person from any department should be able to
➢
➢ login to the system through the first page of the application using the guestlogin to the system through the first page of the application using the guest loginlogin
Enter the details of the requ
Enter the details of the required in the form available. This fired in the form available. This form also captures orm also captures the details like,the details like, name , contact no.,
name , contact no., and designation of the person.and designation of the person.
He/She can opt to transfer his employee for any job or if his/her request is very
He/She can opt to transfer his employee for any job or if his/her request is very specific thenspecific then he/she can submit his/her request.
he/she can submit his/her request. As soon as a
As soon as a transfer request /wittransfer request /withdrawal /cancellation is made by hdrawal /cancellation is made by the person, an automaticthe person, an automatic emailemail should be sent to
should be sent to the employee transfer coordinator giving details about the employer .the employee transfer coordinator giving details about the employer .
Silent Features Silent Features
➢
➢ Menu driven, Key board and mouse navigationMenu driven, Key board and mouse navigation
➢
➢ Paperless practicePaperless practice
➢
➢ Improve efficiency, productivityImprove efficiency, productivity
➢
➢ Cost effective solutionsCost effective solutions
➢
➢ Graphical User Interface with Context Sensitive HelpGraphical User Interface with Context Sensitive Help
➢
➢ No special training No special training needed for using the systemneeded for using the system
➢
➢ Anyone who don’t have accounting knowledge can use without any difficultyAnyone who don’t have accounting knowledge can use without any difficulty General Features
General Features
➢
➢ Automatic importing of drug listAutomatic importing of drug list
➢
➢ Inbuilt account group and account ledgersInbuilt account group and account ledgers
➢
➢ Option for setting default companyOption for setting default company
➢
➢ Keep address book / telephone directory for easy accessKeep address book / telephone directory for easy access
➢
➢ Maintain customer relationshipMaintain customer relationship
➢
➢ Incorporates Calculator with systemIncorporates Calculator with system
➢
➢ Option for sending mail from Pharmiz itselfOption for sending mail from Pharmiz itself
➢
➢ Provides multi user environmentProvides multi user environment
1.4
1.4 Module Module Description Description ::
The campaigner contains the following modules: The campaigner contains the following modules:
Admin:
Admin: This Module provides functionality of managing of categories, sub-categories, and This Module provides functionality of managing of categories, sub-categories, and products.
products. This This is is first first and and most most important important module module of of metastock. metastock. This This module module has has overalloverall controlling of projects without it cannot be man
controlling of projects without it cannot be manage this software.age this software. Reviewer:
Reviewer: This module provides functionality This module provides functionality of managing to give the review of of managing to give the review of the product sothe product so that customer can understand more about the products. This module also can reply on the queries that customer can understand more about the products. This module also can reply on the queries of product which get from customers side.
of product which get from customers side. Moderator:
Moderator: This module provides functionality of managing user review, when Customer This module provides functionality of managing user review, when Customer purchase the product and give personal reviews o
purchase the product and give personal reviews on that product, review of customn that product, review of customer should not beer should not be globalised directly, At this place moderator will receive that reviews and after reading it will verify, globalised directly, At this place moderator will receive that reviews and after reading it will verify, if moderator verify that review, that review should be publish globally but if moderator rejected if moderator verify that review, that review should be publish globally but if moderator rejected that review then should not be published globally.
that review then should not be published globally. Vendor:
Vendor: This module is used by vendor, Vendors are that party who had product can add on this This module is used by vendor, Vendors are that party who had product can add on this site so that customer can views. According to the product more than one vendor can be. All the site so that customer can views. According to the product more than one vendor can be. All the product related information will
product related information will be uploaded by vendors.be uploaded by vendors. Customer:
Customer: This module is used by customer, Customers are end user who will view the product This module is used by customer, Customers are end user who will view the product and send enquiry on that product also can ask any personal queries. After viewing product can and send enquiry on that product also can ask any personal queries. After viewing product can choose products.
CHAPTER 2
CHAPTER 2
TECHNOLOGY OVERVIEW
TECHNOLOGY OVERVIEW
2.1 HARDWARE REQUIREMENTS: 2.1 HARDWARE REQUIREMENTS:D
D
EVELOPEREVELOPER’’SS::
•• PPROCESSOR ROCESSOR :: 2.02.0 GHZGHZ ANDAND ABOVE ABOVE..
•
• MMEMORYEMORY :: 22 GBGB RAM.RAM.
•
• HHARDARDDDISK ISK :: 8080 GBGB HDD.HDD.
U
USERSER’’SS::
PPROCESSOR ROCESSOR :: 2.02.0 GHGHZ Z AND AND ABOVEABOVE
MMEMORYEMORY : : 22 GBGB RAMRAM
HHARDARDDDISK ISK :: 8080 GBGB HDDHDD
N NETWORK ETWORK : : AACTIVECTIVEII NTERNET NTERNETCCONNECTIONONNECTION
2.2 Technology used: 2.2 Technology used: • • FFRONTRONTEE ND ND :: HTML,CSSHTML,CSS • • BBACKACK EE ND ND :: HTML,CSSHTML,CSS 2.3
2.3 SOFTWARE SOFTWARE REQUIREMENTS:REQUIREMENTS:
U
CHAPTER 3
CHAPTER 3
FEASIBILITY STUDY
FEASIBILITY STUDY
3.1 Feasibility Study 3.1 Feasibility StudyFeasibility studies are crucial during the early development of any project and form a vital Feasibility studies are crucial during the early development of any project and form a vital com- ponent
ponent in the in the development process. development process. A feasibility A feasibility study is study is a managementa management-oriented activity. -oriented activity. It is It is aa test of system proposal according to its workability, impact on the organization, ability to meet test of system proposal according to its workability, impact on the organization, ability to meet user needs and effective use of resources. A feasibility study is conducted
user needs and effective use of resources. A feasibility study is conducted to select the best systemto select the best system that meets performance requirement. This entails an identification description, an evaluation of that meets performance requirement. This entails an identification description, an evaluation of candidate system and the selection of best system for the job. The system required performance is candidate system and the selection of best system for the job. The system required performance is defined by a statement of constraints, the identification of specific system objective and a defined by a statement of constraints, the identification of specific system objective and a descrip-tion of outputs.
tion of outputs.
The document provide the feasibility of the project that is being designed and lists various areas The document provide the feasibility of the project that is being designed and lists various areas that were considered very carefully during the feasibility study of this project such as Technical, that were considered very carefully during the feasibility study of this project such as Technical, Economic and Operational feasibilities.
Economic and Operational feasibilities.
The key considerations in feasibility analysis are as follows: The key considerations in feasibility analysis are as follows:
3.1.1
3.1.1 Economic FeasibilityEconomic Feasibility 3.1.2
3.1.2 Technical FeasibilityTechnical Feasibility 3.1.3
3.1.3 Operational FeasibilityOperational Feasibility
It looks at the financial aspects of the project. It determines whether the management has It looks at the financial aspects of the project. It determines whether the management has enough resources and budget to invest in the proposed system and the estimated time for the enough resources and budget to invest in the proposed system and the estimated time for the re-covery of cost incurred. It also determines whether it is worthwhile to invest the money in the covery of cost incurred. It also determines whether it is worthwhile to invest the money in the proposed
proposed project. project. Economic Economic feasibility is feasibility is determines determines by by the the means omeans of cf cost ost benefit benefit analysis. Theanalysis. The proposed
proposed system is system is economically economically feasible because feasible because the the cost involved cost involved in in purchasing the purchasing the hardwarehardware and the software are within approach. The personal cost like salaries of employees hired are also and the software are within approach. The personal cost like salaries of employees hired are also cc
3 1 1 Economic feasibility: 3 1 1 Economic feasibility:
It is a measure of the practically of a specific technical solution and the availability of technical It is a measure of the practically of a specific technical solution and the availability of technical resources and expertise.
resources and expertise.
The system will be used if it is developed
The system will be used if it is developed well then tackle the hindrances well then tackle the hindrances in its operation.in its operation.
➢
➢ It will help in the time saving and fast procIt will help in the time saving and fast processing and dispersal of user request andessing and dispersal of user request and applications.
applications.
➢
➢ New product will provide all the benefits of present system wit New product will provide all the benefits of present system with better performance.h better performance.
➢
➢ Improved information, better management and collection of the Improved information, better management and collection of the relevant data which isrelevant data which is very helpful to users of the project.
very helpful to users of the project.
➢
➢ Multi User support facilitate in smooth running of software.Multi User support facilitate in smooth running of software.
➢
➢ User will have control over own information. Important information such as mail addUser will have control over own information. Important information such as mail add ressress cannot be publicly viewed.
cannot be publicly viewed.
➢
➢ Faster and systematic processing of user application approval, view acFaster and systematic processing of user application approval, view ac ceptance andceptance and rejection facility.
rejection facility.
➢
➢ Hence the project will be operationally feasible Hence the project will be operationally feasible also.also.
3.2 Behavioral Feasibility: 3.2 Behavioral Feasibility:
In this type of feasibility check, we come to know if the newly developed system will be In this type of feasibility check, we come to know if the newly developed system will be taken and accepted by the working force i.e. the people who will use it.
taken and accepted by the working force i.e. the people who will use it.
As the application has graphical user interface with suitable screen which help them a lot As the application has graphical user interface with suitable screen which help them a lot in navigation through the pages without concern of the backend processes. So the users must not in navigation through the pages without concern of the backend processes. So the users must not have any problem in finding or searching the content from the site. Hence results in behaviorally have any problem in finding or searching the content from the site. Hence results in behaviorally feasible project feasible project 3 1 2 Technical Feasibility: 3 1 2 Technical Feasibility: 3 1 3 Operational Feasibility: 3 1 3 Operational Feasibility:
CHAPTER 4
CHAPTER 4
LANGUAGE AND TOOLS TO BE USED
LANGUAGE AND TOOLS TO BE USED
4.1 History
4.1 History
Hypertext Markup Language
Hypertext Markup Language ( (HTMLHTML))is the standard markup languageis the standard markup language for creatingfor creating web web pages
pages and and web applications. web applications. With With Cascading Style Sheets Cascading Style Sheets (CSS) and (CSS) and JavaScript JavaScript it forms a triadit forms a triad of cornerstone technologies for the
of cornerstone technologies for the World Wide Web World Wide Web..[3][3] Web browsers Web browsers receive HTMLreceive HTML documents from a
documents from a web server web server or from local storage and render them into or from local storage and render them into multimedia web pages.multimedia web pages. HTML describes the structure of a web page
HTML describes the structure of a web page semantically semantically and originally included cues for theand originally included cues for the appearance of the document.
appearance of the document. HTML elements
HTML elements are the building blocks of HTML pagare the building blocks of HTML pages. With HTML constructs,es. With HTML constructs, images images andand other objects, such as
other objects, such as interactive forms, interactive forms, may be embedded into the rendered page. It provides amay be embedded into the rendered page. It provides a means to create
means to create structured documents structured documents by denoting structural by denoting structural semantics semantics for text such as headings,for text such as headings, paragraphs, lists,
paragraphs, lists, links, links, quotes and other items. HTML elements are delineated by quotes and other items. HTML elements are delineated bytagstags, written, written using
using angle brackets. angle brackets. Tags Tags such as such as <img /> and <img /> and <input /> <input /> introduce content introduce content into the into the pagepage directly. Others
directly. Others such as such as <p>...</p> <p>...</p> surround and provide surround and provide information about document information about document text andtext and may include other tags as sub-elements. Browsers do
may include other tags as sub-elements. Browsers do not display the HTML tags, but use not display the HTML tags, but use them tothem to interpret the content of the page.
interpret the content of the page.
At its heart,
At its heart, HTML HTML is a fairly simple language made up of elements, which can be applied tois a fairly simple language made up of elements, which can be applied to pieces of text to give them different meaning in a document (is it a paragraph? is it a bulleted pieces of text to give them different meaning in a document (is it a paragraph? is it a bulleted
list? is it part of a table?), structure a document in
list? is it part of a table?), structure a document into logical sections (does it have a heato logical sections (does it have a header? threeder? three columns of content? a navigation menu?) and embed content such as images and videos into a columns of content? a navigation menu?) and embed content such as images and videos into a page. This module will introduce the first two of these, and introduce fundamental concepts and page. This module will introduce the first two of these, and introduce fundamental concepts and
syntax you need to know to understand HTML. syntax you need to know to understand HTML. Getting started with HTML
Getting started with HTML
Covers the absolute basics of HTML, to get
Covers the absolute basics of HTML, to get you startedyou started — — we define elements, attributes, we define elements, attributes, and all the other important terms you may
and all the other important terms you may have heard, and have heard, and where they fit in to thewhere they fit in to the
language. We also show how an HTML element is structured, how a typical HTML page language. We also show how an HTML element is structured, how a typical HTML page is structured, and explain other important basic language features. Along the way, we'll is structured, and explain other important basic language features. Along the way, we'll have a play with some HTML,
have a play with some HTML, to get you interested!to get you interested!
What’s
What’s in the head? Metadata in the head? Metadata in HTMLin HTML
The head of an HTML document is the part that
The head of an HTML document is the part thatis notis not displayed in the web browser displayed in the web browser when the page is loaded.
when the page is loaded. It contains information such as the pageIt contains information such as the page <title>, <title>, links to links to CSS( CSS(ifif you want to style your HTML co
you want to style your HTML content with CSS), links to custom favicons, and ntent with CSS), links to custom favicons, and metadatametadata (which is data about the HTML, such
(which is data about the HTML, such as who wrote it, and important keyas who wrote it, and important keywords thatwords that describe the document.)
HTML text fundamentals HTML text fundamentals
One of HTML's main jobs is to give text
One of HTML's main jobs is to give text meaning (also known asmeaning (also known assemanticssemantics), so that the), so that the browser knows how to display it correctly. This article looks at how to use HTM
browser knows how to display it correctly. This article looks at how to use HTML toL to break a block of text up into a structure of headings and paragraphs, add
break a block of text up into a structure of headings and paragraphs, add emphasis/importance to words, create lists, and more.
emphasis/importance to words, create lists, and more. Creating hyperlinks
Creating hyperlinks
Hyperlinks are really important
Hyperlinks are really important — — they are what makes the web a web. This article they are what makes the web a web. This article shows the syntax required to make a
shows the syntax required to make a link, and discusses link best practices.link, and discusses link best practices. Advanced text formatting
Advanced text formatting
There are many other elements in HTML
There are many other elements in HTML for formatting text, which we didn't get to infor formatting text, which we didn't get to in the
the HTML text fundamentals HTML text fundamentals article. The elements in here are less well-known, but stillarticle. The elements in here are less well-known, but still useful to know about. In here
useful to know about. In here you'll learn about marking up quoyou'll learn about marking up quotations, description lists,tations, description lists, computer code and other related text, subscript and superscript, contact information, and computer code and other related text, subscript and superscript, contact information, and more.
more.
Document and website structure Document and website structure
As well as defining individual parts of your page (such as "a paragraph" or "an image"), As well as defining individual parts of your page (such as "a paragraph" or "an image"), HTML is also used to define areas of you
HTML is also used to define areas of your website (such as "the header", "the r website (such as "the header", "the navigationnavigation menu", "the main content column".)
menu", "the main content column".) This article looks into how to plan This article looks into how to plan a basic websitea basic website structure, and write the HTML to represent this structure.
structure, and write the HTML to represent this structure. Debugging HTML
Debugging HTML
Writing HTML is fine, but what if something is going wrong,
Writing HTML is fine, but what if something is going wrong, and you can't work outand you can't work out where the error in the code is?
where the error in the code is? This article will introduce you to some tools that can This article will introduce you to some tools that can helphelp you.
you. 4.2 Css
4.2 Css
Cascading Style Sheets
Cascading Style Sheets ( (CSSCSS) is a) is a style sheet language style sheet language used for describing theused for describing the presentation presentation of aof a document written in a
document written in a markup language markup language..[1][1] Although most often used to set the Although most often used to set the visual stylevisual style of
of web pages web pages and user interfaces written inand user interfaces written in HTML HTML and and XHTML, XHTML, the language can be applied to the language can be applied to any
any XML XML document, includingdocument, including plain XML, plain XML, SVG SVG and and XUL, XUL, and is applicable to rendering and is applicable to rendering in
in speech, speech, or on other media. Along with HTML and or on other media. Along with HTML and JavaScript, JavaScript, CSS is a cornerstone CSS is a cornerstone technology used by most websites to c
technology used by most websites to create visually engaging webpages, user interfaces for reate visually engaging webpages, user interfaces for web web applications,
applications, and user interfaces for many mobile a and user interfaces for many mobile applicationspplications..[2][2]
CSS is designed primarily to enable the separation of presentation and content, including aspects CSS is designed primarily to enable the separation of presentation and content, including aspects such as the
such as the layout, layout, colors, colors, and and fonts fonts..[3][3]This separation can improve contentThis separation can improve content accessibility, accessibility, provide provide more flexibility and control in the specification of presentation characteristics, enable multiple more flexibility and control in the specification of presentation characteristics, enable multiple
HTML pages to share formatting by specifying the
HTML pages to share formatting by specifying the relevant CSS in a separate relevant CSS in a separate .css file, and.css file, and reduce complexity and repetition in
reduce complexity and repetition in the structural content.the structural content. Separation of formatting and content makes it po
Separation of formatting and content makes it po ssible to present the same markup page inssible to present the same markup page in different styles for different rendering methods, such as on-screen, in p
different styles for different rendering methods, such as on-screen, in p rint, by voice (via speech-rint, by voice (via speech- based browser or
based browser or screen reader) screen reader), and on, and on Braille-basedt Braille-basedtactile devices. It can also display the webactile devices. It can also display the web page differently depending on the screen size or viewing device. Readers can also specify a page differently depending on the screen size or viewing device. Readers can also specify a
different style sheet, such as a CSS file
different style sheet, such as a CSS file stored on their own computer, to override the stored on their own computer, to override the one theone the author specified.
author specified. Changes to the
Changes to the graphic design graphic design of a document (or hundreds of documents) can be applied quicklyof a document (or hundreds of documents) can be applied quickly and easily, by editing a few lines in the CSS file they use, rather than by changing markup in the and easily, by editing a few lines in the CSS file they use, rather than by changing markup in the documents.
documents.
The CSS specification describes a priority scheme to d
The CSS specification describes a priority scheme to d etermine which style rules apply if moreetermine which style rules apply if more than one rule matches against a
than one rule matches against a particular element. In this so-calledparticular element. In this so-calledcascadecascade, priorities, priorities (or
CHAPTER 5
CHAPTER 5
SDLC
SDLC
5.1
5.1 Model Model UsedUsed
There are various software paradigms, but we
There are various software paradigms, but we used Waterfall model (the linear sequential model),used Waterfall model (the linear sequential model), which states that the phases are organized in a linear order. The Waterfall model suggests a which states that the phases are organized in a linear order. The Waterfall model suggests a systematic, sequential approach to s/w development that begins at the system level and
systematic, sequential approach to s/w development that begins at the system level and progressesprogresses through analysis, design, coding, testing, and maintenance and support
through analysis, design, coding, testing, and maintenance and support
An
An alyaly sisi ss
Design Design Coding Coding Testing Testing Implementation Implementation Maintenance Maintenance Detailed Design Detailed Design Programs Programs
Requirement Document & Project Plan Requirement Document & Project Plan
Test Plan Reports & Manuals Test Plan Reports & Manuals
Installation Reports Installation Reports
5.2
5.2 SYSTEM ANALYSISSYSTEM ANALYSIS
System analysis is an in
System analysis is an in – – depth of the end user information needs that produces functionaldepth of the end user information needs that produces functional requirements that are used as the basic for the
requirements that are used as the basic for the design of the new system.design of the new system. System analysis traditionally involves detailed study
System analysis traditionally involves detailed study
of:-➢
➢ The information needs of the organization and end users like you.The information needs of the organization and end users like you.
➢
➢ The activities, resources, and outputs of the present system in The activities, resources, and outputs of the present system in a familiar manner.a familiar manner.
➢
➢ The system capability requires to meet your information Need, and those of others staffThe system capability requires to meet your information Need, and those of others staff member of the organization.
CHAPTER 6
CHAPTER 6
LIFE CYCLE OF PROJECT
LIFE CYCLE OF PROJECT
6.1
6.1 E-R E-R DIAGRAMDIAGRAM
In this model objects of similar structures are c
In this model objects of similar structures are c ollected into an entity set. ollected into an entity set. The relationship betweenThe relationship between entity sets is represented by a named E-R relationship and is 1:1(one to one), 1: N (one to many) entity sets is represented by a named E-R relationship and is 1:1(one to one), 1: N (one to many) or M: N (many to many) mapping from one entity set to another. The database structures, or M: N (many to many) mapping from one entity set to another. The database structures, employing the E-R model is usually shown pictorially using entity relationship (E-R) diagrams. employing the E-R model is usually shown pictorially using entity relationship (E-R) diagrams. The E-R diagrams are useful
The E-R diagrams are useful in representing the relationship among entities. The in representing the relationship among entities. The following termsfollowing terms used in E-R
used in E-R Diagram:-Entity
Entity:-An entity is a person, place, thing, :-An entity is a person, place, thing, event or concept about event or concept about which information is recorded.which information is recorded. Attribute
Attribute:-Attribute gives the characteristic of the entity. In other words, every entity has some:-Attribute gives the characteristic of the entity. In other words, every entity has some basic attribute that characterize it.
basic attribute that characterize it. Entity Type
Entity Type:-An entity type is defined as a :-An entity type is defined as a collection of entities that have thecollection of entities that have the same attributes.same attributes. Relationships: Relationships: One to One (1:1) One to One (1:1) One to many (1: N) One to many (1: N) Many to Many (N: N) Many to Many (N: N) Many to One (N: 1) Many to One (N: 1)
ER-Diagram : ER-Diagram :
6.2
6.2 Data Data Flow Flow DiagramDiagram
Data Flow Diagram (DFD) is a graphica
Data Flow Diagram (DFD) is a graphical technique that depicts information flow and transfers thatl technique that depicts information flow and transfers that are applied as data moves from input to output. The DFD is also known as Data flow graph or a are applied as data moves from input to output. The DFD is also known as Data flow graph or a bubble chart. The data flow diagram m
bubble chart. The data flow diagram may be used to represent a system ay be used to represent a system or software at any level ofor software at any level of abstraction. In fact, DFD’s may be
abstraction. In fact, DFD’s may be partitioned into levels that represent increasing informatiopartitioned into levels that represent increasing information andn and functional detail.
functional detail.
The basic notation to create a DFD is: The basic notation to create a DFD is:
➢
➢ A rectangle is used to represent an external entity, that is, a system element (e.g. hardware,A rectangle is used to represent an external entity, that is, a system element (e.g. hardware, person and another program) or another
person and another program) or another
➢
➢ System that produces information for transformation by the software or receives informationSystem that produces information for transformation by the software or receives information produced by the software.
produced by the software.
➢
➢ A circle represents a process or transform that is applied to data (or control) and changes it inA circle represents a process or transform that is applied to data (or control) and changes it in some way.
some way.
➢
➢ An arrow represents one or more data items.An arrow represents one or more data items.
➢
➢ An open rectangle represents data storeAn open rectangle represents data store – – stored information that is used by the software, i.e.stored information that is used by the software, i.e. temporary repository of data.
temporary repository of data.
The simplicity of DFD notation is one reason why structured analysis techniques are most widely The simplicity of DFD notation is one reason why structured analysis techniques are most widely used .The data flow diagram for the
6.2.1 FlowChart
6.2.2
6.2.2 CONTEXT DIAGRAMCONTEXT DIAGRAM(LEVEL 0)(LEVEL 0)
6.2.3 DATA FLOW
6.2.4 DATA
CHAPTER 7
CHAPTER 7
7.1
7.1
Screen
Screen
Shots
Shots
7.1.1 Home Page7.1.2 Login Page 7.1.2 Login Page
7.1.3 Signup Page 7.1.3 Signup Page
7.1.4 Store Page 7.1.4 Store Page
7.1.5 Medicene Store page 7.1.5 Medicene Store page
7.1.6 Add Address Page 7.1.6 Add Address Page
7.1.7 Payment Page 7.1.7 Payment Page
7.1.8 Order Confirmed Page 7.1.8 Order Confirmed Page
7.1.9 Treat ment form Page 7.1.9 Treat ment form Page
7.1.10 Feedback Form Page 7.1.10 Feedback Form Page
CHAPTER 8
CHAPTER 8
TESTING AND MAINTENANCE
TESTING AND MAINTENANCE
TESTING TESTING
Software testing is a critical element of software quality assurance and represents the ultimate Software testing is a critical element of software quality assurance and represents the ultimate review of specification, design and coding. The
review of specification, design and coding. The purpose of product testing is to verify and validatepurpose of product testing is to verify and validate the various work product viz. units, integrated unit, final product to ensure that they meet their the various work product viz. units, integrated unit, final product to ensure that they meet their respective requirements.
respective requirements.
8.1
8.1 Testing Testing Objectives:Objectives:
•
• Testing is a process of executing a Testing is a process of executing a program with the intent of finding an error.program with the intent of finding an error. •
• A good test case is one A good test case is one that has a high probability of finding that has a high probability of finding an as-yet undiscovered error.an as-yet undiscovered error. •
• A successful test is one that uncovers an as-yet undiscovered error.A successful test is one that uncovers an as-yet undiscovered error. •
• Live data is the actual data to be used in the proposed system.Live data is the actual data to be used in the proposed system. •
• Test data is previously designed sample input to Test data is previously designed sample input to achieve predictable results.achieve predictable results. This process has two parts:
This process has two parts: 1)
1) PLANNING:PLANNING: This involves writing and reviewing unit, integration, functional, validation andThis involves writing and reviewing unit, integration, functional, validation and acceptance test plans.
acceptance test plans. 2)
2) EXECUTION:EXECUTION: This involves executingThis involves executing these plans, measuring, collecting data and verifyingthese plans, measuring, collecting data and verifying if it meets the quality criteria. Data collected is used to make appropriate changes in the plans if it meets the quality criteria. Data collected is used to make appropriate changes in the plans related to development and testing. The quality of a product or item can be achieved by ensuring related to development and testing. The quality of a product or item can be achieved by ensuring that the product meets the requirements by
that the product meets the requirements by planning and conducting planning and conducting the following tests at variousthe following tests at various stages.
stages.
8.2
8.2 Testing Testing Techniques:Techniques:
The techniques followed throughout the
The techniques followed throughout the testing of the system are as undertesting of the system are as under 1)
1) BBLACKLACK-B-BOXOXTTESTINGESTING
Here we demonstrated Here we demonstrated
:-•
•
• Input is properly accepted, Output is correctly produced Input is properly accepted, Output is correctly produced ,,
•
• The integrity of external information (e.g.: - a dThe integrity of external information (e.g.: - a d atabase) is maintained.atabase) is maintained.
2)
2) WWHITEHITE-B-BOXOXTTESTINGESTING
It is predicated on close examination of procedural details. Providing test cases that exercise It is predicated on close examination of procedural details. Providing test cases that exercise specific sets of conditions and / or loops tests logical paths
specific sets of conditions and / or loops tests logical paths through the software. The “state of thethrough the software. The “state of the program”
program” may may be be examined examined at at various various points points to to determine determine if if the the expected expected of of asserted asserted statusstatus corresponding to the actual status.
corresponding to the actual status. Control Structure Testing
Control Structure Testing
➢
➢ Boolean operator errorBoolean operator error
➢
➢ Boolean variable errorBoolean variable error
➢
➢ Boolean parenthesis errorBoolean parenthesis error
➢
➢ Relational operator errorRelational operator error
➢
➢ Arithmetic expression errorArithmetic expression error 1)
1) Loop Testing:Loop Testing:Loops are the corner stone for the vast majority of all algorithms implementedLoops are the corner stone for the vast majority of all algorithms implemented in software. Loop testing is a white-box testing technique that focuses exclusively on the validity in software. Loop testing is a white-box testing technique that focuses exclusively on the validity of loop constructs. Four different classes of loops:
of loop constructs. Four different classes of loops:
➢
➢ Nested LoopsNested Loops
➢
➢ Concatenated LoopsConcatenated Loops
➢
➢ Unstructured LoopsUnstructured Loops
2)
2) Dataflow Testing:Dataflow Testing: The dataflow testing method selects test paths of a program according to The dataflow testing method selects test paths of a program according to the location of definitions and uses of variables in
8.3 Testing Strategies: 8.3 Testing Strategies:
A strategy for software testing integrates software test case design methods into a well-planned A strategy for software testing integrates software test case design methods into a well-planned series of steps that result in the successful construction of software. A software testing strategy series of steps that result in the successful construction of software. A software testing strategy should be flexible enough to promote a customized testing approach.
should be flexible enough to promote a customized testing approach.
➢
➢ UUNITNITTTESTINGESTING:: Unit testing begins at the vertex of the Unit testing begins at the vertex of the spiral and concentrates on each spiral and concentrates on each unit ofunit of
the software as implemented in the source code. The individual modules were tested during the software as implemented in the source code. The individual modules were tested during the development. Unit test cases and their results are submitted periodically during the the development. Unit test cases and their results are submitted periodically during the devel-opment stage.
opment stage.
➢
➢ IINTEGRATIONNTEGRATIONTTESTINGESTING: Integration testing focuses on design and c: Integration testing focuses on design and construction of the softwareonstruction of the software
architecture. After two or more product units are constructed, the development
architecture. After two or more product units are constructed, the development team, to test theteam, to test the interface between the integrated units, conducts integration testing.
interface between the integrated units, conducts integration testing.
➢
➢ FFUNCTIONALUNCTIONALTTESTINGESTING: Functions are invariably related to one another & interact in the total: Functions are invariably related to one another & interact in the total
system. Each function is tested to see whether it conforms to related functions in the system. system. Each function is tested to see whether it conforms to related functions in the system. Each portion of the system is tested against the entire module both test & live data are used Each portion of the system is tested against the entire module both test & live data are used before the entire system test was conducted.
before the entire system test was conducted.
➢
➢ AACCEPTANCECCEPTANCE TTESTSESTS:: During this test we determine how users will use the system when pro-During this test we determine how users will use the system when
pro-cessing data or preparing reports. cessing data or preparing reports.
➢
➢ VVALIDATIONALIDATION TTESTINGESTING:: This is where requirements established as part of software require-This is where requirements established as part of software
require-ments analysis is validated against the software that has been constructed. ments analysis is validated against the software that has been constructed.
➢
➢ SSYSTEMYSTEM TTESTINGESTING:: It is here the software and other system elements are tested as a whole.It is here the software and other system elements are tested as a whole.
Proper procedures are forced in the
Proper procedures are forced in the software for recovery as the software may fail in a software for recovery as the software may fail in a varietyvariety of ways. Proper security attempts to verify that
of ways. Proper security attempts to verify that protection mechanisms built into a system will,protection mechanisms built into a system will, in fact protect it from improper penetration.
in fact protect it from improper penetration. A
APPROACH FORPPROACH FORTTESTINGESTING::
For unit testing, the modules are tested for correctness of logic applied and should detect errors in For unit testing, the modules are tested for correctness of logic applied and should detect errors in coding. Valid and invalid data should be created and the programs should be made to process this coding. Valid and invalid data should be created and the programs should be made to process this data to catch errors.
data to catch errors.
For Example, in the Distance Learning System, For Example, in the Distance Learning System,
•
• In the registration module while entering the data for user, one In the registration module while entering the data for user, one cannot go for password lesscannot go for password less than eight characters., so one should e
than eight characters., so one should ensure that it should result in an error message.nsure that it should result in an error message. •
• All dates that are entered should be validated. No program should acceptAll dates that are entered should be validated. No program should accept
For system testing, when unit tests are satisfactorily concluded, the system as a complete entity For system testing, when unit tests are satisfactorily concluded, the system as a complete entity must be tested. At this stage, end-users and operators become actively involved in testing. While must be tested. At this stage, end-users and operators become actively involved in testing. While testing one should also test to find discrepancies between the system and its original objective, testing one should also test to find discrepancies between the system and its original objective, current specification and systems documentation.
current specification and systems documentation. S
SOMEOMECCOMMONOMMONTTESTS AREESTS ARE:: ➢
➢ Handling values in Primary Key fields.Handling values in Primary Key fields.
➢
➢ Handling empty records.Handling empty records.
➢
➢ Max length allowed in controls should match the database structure.Max length allowed in controls should match the database structure.
➢
➢ Handling special characters like ‘, #, %, $, {,}, [,], etc.Handling special characters like ‘, #, %, $, {,}, [,], etc.
➢
➢ Handling of errors in modules as specified in the project specifications.Handling of errors in modules as specified in the project specifications.
➢
➢ Use global error handling functions if there is any in Use global error handling functions if there is any in the project.the project.
➢
➢ Termination of activities while error should be monitored accordingly.Termination of activities while error should be monitored accordingly.
➢
➢ Keeping control of the application to self while unexpected errorsKeeping control of the application to self while unexpected errors
➢
➢ Raise errors and handle it as and when necessary.Raise errors and handle it as and when necessary.
➢
➢ Showing meaningful error messages as and when Showing meaningful error messages as and when required.required.
➢
➢ Updating error log file with specific information on errors.Updating error log file with specific information on errors.
➢
➢ Use proper captions for error message dialog boxes.Use proper captions for error message dialog boxes.
➢
➢ Format of date should be as specified in the project specifications.Format of date should be as specified in the project specifications.
➢
➢ Showing default values in all sub forms as and when required.Showing default values in all sub forms as and when required.
➢
➢ Query handling within form.Query handling within form.
➢
➢ Enabling and disabling of controls as and when required.Enabling and disabling of controls as and when required.
➢
➢ Showing complete data as and when required.Showing complete data as and when required.
8.5
8.5 MAINTENANCE MAINTENANCE DESCRIPTIONDESCRIPTION
This is an ongoing exercise after the system has been implemented. The real life would be never This is an ongoing exercise after the system has been implemented. The real life would be never static. It is necessary to eliminate errors in
static. It is necessary to eliminate errors in the working system during its working the working system during its working life and to tunelife and to tune the system to any variations in its working environment. System planners must always plan for the system to any variations in its working environment. System planners must always plan for
resource availability to carry out these maintenance
resource availability to carry out these maintenance functions. Its requirements and objectives keepfunctions. Its requirements and objectives keep changing. So shall be the system, which has been designed primarily to meet those objectives. changing. So shall be the system, which has been designed primarily to meet those objectives. Thus the system analyst has to keep on carrying out changes and modification into the system, a Thus the system analyst has to keep on carrying out changes and modification into the system, a stage called normally as system maintenance.
stage called normally as system maintenance. C
CORRECTIVE MAINTENANCEORRECTIVE MAINTENANCE
This pertains to the changes the software to correct defects. This pertains to the changes the software to correct defects. A
ADAPTIVEDAPTIVEMMAINTENANCEAINTENANCE
Overtime, the original environment for which the web application was developed is likely to Overtime, the original environment for which the web application was developed is likely to change. This maintenance results in modification to the software to accommodate changes to its change. This maintenance results in modification to the software to accommodate changes to its external environment.
CHAPTER 9
CHAPTER 9
LIMITATION AND
LIMITATION AND CONCLUSIONS
CONCLUSIONS
9.1 LIMITATION 9.1 LIMITATION
➢
➢ No direct interaction between user and administrator. No direct interaction between user and administrator.
➢
➢ No No option option to to select select other other product product which which is nois not adt add d this site. this site. Only Only added added product product Can Can bebe choose
choose
➢
➢ Cost of product can be vCost of product can be vary from customer to customer, no standard and ary from customer to customer, no standard and fixed cost.fixed cost.
➢
➢ Need to internet connection to access these services. Need to internet connection to access these services.
F
FUTUREUTUREASPECTS:ASPECTS:
As software is used, the customer/user will recognize
As software is used, the customer/user will recognize additional functions that will provide benefit.additional functions that will provide benefit. Perfective maintenance extends the software beyond its original functional requirements. It will Perfective maintenance extends the software beyond its original functional requirements. It will play very important role in construction site.
play very important role in construction site. S
SCOPECOPEOOFFTTHEHEPPROJECTROJECT
Since this system has been developed using object oriented programming, there are every Since this system has been developed using object oriented programming, there are every chances of reusability of the codes in other environments and even different platforms. Also its chances of reusability of the codes in other environments and even different platforms. Also its present features
present features can be can be enhanced enhanced by some by some simple modifications in simple modifications in the code the code so as so as to use to use it in it in thethe changing scenario. Apart from reusability, the other features are
changing scenario. Apart from reusability, the other features are — —
➢ ➢ ExtensibilityExtensibility ➢ ➢ RobustnessRobustness ➢ ➢ UnderstandabilityUnderstandability ➢ ➢ MaintainabilityMaintainability ➢
9.2 CONCLUSION 9.2 CONCLUSION
System was developed and fasted in
System was developed and fasted in steps. Once the design was finalized, the format of the outputsteps. Once the design was finalized, the format of the output reports was set one by one
reports was set one by one
after approval from the user department. System was first tested on the test data and then real after approval from the user department. System was first tested on the test data and then real data.data. Minor programming errors were identified and rectified. After rectifying the system was Minor programming errors were identified and rectified. After rectifying the system was implemented successfully and accuracy was found.
implemented successfully and accuracy was found. After testing, our system “
After testing, our system “Learning Management SystemLearning Management System” we find that this system provide a” we find that this system provide a lot of help to the user, an
lot of help to the user, and it is very beneficial for online mailing. After implementation of thisd it is very beneficial for online mailing. After implementation of this we conclude that this is real client/server environment that are
we conclude that this is real client/server environment that are reachable all over the world. Thisreachable all over the world. This system is fast as compared to other computerized system
system is fast as compared to other computerized system
9.3 Future SCOPE 9.3 Future SCOPE
➢
➢ The future scope of this project would be an addition feature of Direct interaction with ProductThe future scope of this project would be an addition feature of Direct interaction with Product Company and all the CONCESSION and FREE extra product will be direct get to the Company and all the CONCESSION and FREE extra product will be direct get to the Custom-ers where in the real time convCustom-ersation would be enabled.
ers where in the real time conversation would be enabled.
➢
➢ It could also include a module through which outside users can access to some specific levels.It could also include a module through which outside users can access to some specific levels.
➢
➢ Add Video conferencing through directly customer support and product reviewers.Add Video conferencing through directly customer support and product reviewers.
➢
Bibliography
Bibliography
Websites: Websites: • • www.w3schools.comwww.w3schools.com • • www.csstutorial.netwww.csstutorial.net • • www.yourhtmlsource.comwww.yourhtmlsource.com • • www.tutorialspoint.comwww.tutorialspoint.com • • www.cssbasics.comwww.cssbasics.com Books: Books: AuAu thth or or TitleTitle
Mary Gillen
Mary Gillen HTML, Intermediate Skills & DrillsHTML, Intermediate Skills & Drills Craig Grannell
Craig Grannell The Essential Guide to CSS and HTML WebThe Essential Guide to CSS and HTML Web Design
Design Eric Ray
Eric Ray HTML 4 for Dummies Quick Reference (Avail-HTML 4 for Dummies Quick Reference
(Avail-able Feb 1998)
able Feb 1998) Jennifer Niederst Robbins
Jennifer Niederst Robbins Learning Web DesignsLearning Web Designs
