PROMOTION DRIVEN CONSUMER RELATIONSHIP
INFORMATION SYSTEM
A PROJECT REPORT
Submitted by
SWATHI.S
Register No. 16ISR050
in partial fulfilment of the requirements
for the award of the degree
of
MASTER OF SCIENCE IN
SOFTWARE SYSTEMS
DEPARTMENT OF COMPUTER TECHNOLOGY - PG SCHOOL OF
COMPUTER TECHNOLOGY AND APPLICATIONS
KONGU ENGINEERING
COLLEGE
(Autonomous)
PERUNDURAI ERODE-638 060
NOVEMBER-2019
ii
DEPARTMENT OF COMPUTER TECHNOLOGY-PG
KONGU ENGINEERING COLLEGE
(Autonomous)
PERUNDURAI ERODE – 638 060
OCTOBER 2018
BONAFIDE CERTIFICATE
This is to certify that the project report entitled “Promotion Driven Consumer Relationship
Information System” is the bonafide record of project work done by SWATHI.S(Register
No: 16ISR050) in partial fulfilment of the requirements for the award of the Degree of Master
of Science in Software Systems of Anna University, Chennai during the year2019 - 2020.
SUPERVISOR HEAD OF THE DEPARTMENT
(Signature with seal)
Date:
Submitted for the end semester viva voce examination held on
INTERNAL EXAMINER EXTERNAL EXAMINER
iii
DECLARATION
I affirm that the project report titled “Promotion Driven Consumer
Relationship Information System” being submitted in partial fulfilment of the
requirements for the award of Master of Science is the original work carried out
by me. It has not formed the part of any other project report or dissertation on the
basis of which a degree or award was conferred on an earlier occasion on this or
any other candidate.
Date: S.SWATHI
(Reg No: 16ISR050)
I certify that the declaration made by the above candidate is true to the best of
my knowledge.
Date: Name & Signature of the Supervisor
(DR.P.ANANTHI)
iv
ABSTRACT
The objective of “Promotion Driven Consumer Relationship Information Sytem ”is to
gain competitive advantage over competitors that supply similar product or services.Although
the existing system is fully computerised it has many disadvantages like poor customer
feedback management and customer services. The proposed application encompasses recording
customer interactions, recognizing the best customers by providing high discount and offers in
association with the variety of stakeholders such as administrator, sales manager and marketing
manager. The front-end tool used is HTML and Bootstrap , the server-side script is Python
Flask and Back-End tool is MySQL.
v
ACKNOWLEDGEMENT
I express my sincere thanks to Thiru.P.Sachithanandan, our Correspondent and all
philanthropic trust members of Kongu Vellalar Insttiute of Technology Trust who has always
encouraged us in the academic and co-curricular activities.
I am proudly thankful with no words of formal nature to our dynamic Principal
Dr.V. Baluswamy B.E(Hons)., M.Tech., Ph.D., for providing all the facilities
indispensable during my project.
I am thankful to Dr. P. Balasubramanie MSc, MPhil, MTech, PhD, Professor and
Head, Department of Computer Technology-PG, for his valuable suggestions and cooperation
during my project work.
I thank my project coordinator Dr. P. Ananthi MSc., MPhil., MBA., MCA., PhD.,
Assistant Professor (Senior Grade), Department of Computer Technology-PG, for being a
continuous source of inspiration for the successful completion of the project.
I thank my project guide coordinator Dr. P. Ananthi MSc., MPhil., MBA., MCA., PhD.,
Assistant Professor (Selection Grade), Department of Computer Technology-PG, whose
insight comments and suggestions added greatly to the final result.
vi
TABLE OF CONTENTS
CHAPTER NO. TITLE PAGE NO.
ABSTRACT Iv
LIST OF TABLES Viii
LIST OF FIGURES Ix
ORGANIZATION PROFILE X
1 INTRODUCTION 1
1.1 OVERVIEW OF THE PROJECT 1
2 SYSTEM ANALYSIS 3
2.1 EXISTING SYSTEM 3
2.2 PROPOSED SYSTEM 3
2.3 FEASIBILITY STUDY 4
2.4 PROBLEM ANALYSIS 5
2.4.1 PROBLEM DESCRIPTION 5
2.4.2 DATA FLOW DIAGRAM 7
2.5 SYSTEM SPECIFICATION 12
2.5.1 HARDWARE REQUIREMENTS 12
2.5.2 SOFTWARE REQUIREMENTS 12
2.5.3 SOFTWARE DESCRIPTION 12
3 SYSTEM DESIGN 16
3.1 INPUT DESIGN 16
3.2 DATABASE DESIGN 17
3.3 MODULE DESCRIPTION 23
3.4 OUTPUT DESIGN 24
4 SYSTEM TESTING 25
5 SYSTEM IMPLEMENTATION 27
6 CONCLUSION AND FUTURE 28
ENHANCEMENTS
vii
APPENDICES 29
APPENDIX 1 : SAMPLE CODE 29
APPENDIX 2 : SCREEN SHOTS 39
REFERENCES 47
viii
LIST OF TABLES
TABLE NO. TABLE NAME PAGE NO.
3.1 admin 17
3.2 user 17
3.3 product 18
3.4 offer 18
3.5 cart 19
3.6 porder 20
3.7 sales 21
3.8 ordersummary 21
ix
LIST OF FIGURES
FIGURE NO. FIGURE NAME PAGE NO.
2.1 Context Diagram 7
2.2 Level 1 DFD 8
2.3 Level 2 DFD for Manage Business Details 9
2.4 Level 2 DFD for Register Business 10
2.5 Level 2 DFD for Discussion Forum 11
A.2.1 Home Page 39
A.2.2 Admin’s Login Page 39
A.2.3 Products and Offers Adding Form 40
A.2.4 View Products and Offers 40
A.2.5 Admin View orders 41
A.2.6 Customer’s Login Page 41
A.2.7 Viewing Products 42
A.2.8 Cart Page 42
A.2.9 Order Summary Page 43
A.2.10 Bill 43
x
ORGANIZATION PROFILE
