ABSTRACT
This project introduces an innovative online furniture platform aimed at
revolutionizing the furniture shopping experience. Leveraging Django, a robust Python web
framework, it offers a secure and scalable e-commerce solution. The platform boasts a
comprehensive range of furniture products, complete with detailed descriptions, images, and
pricing, ensuring customers can make informed decisions.
For registered users, including customers, sellers, delivery agents, and maintenance
agents, the platform provides tailored functionalities. Customers benefit from features such as
product comparison, search and filtering, order tracking, and the option to rent items.
Additionally, they can engage with a chatbot, rate and review products. Sellers have a dedicated
dashboard to manage their inventory.
Administrators oversee the platform's operations, with capabilities to generate reports
and analytics, add and manage delivery and maintenance agents, and communicate with users
via email. Delivery agents can track assigned orders, confirm deliveries, and update statuses.
Maintenance agents schedule and log maintenance tasks, as well as generate quotations for
services.
Overall, Farzi Furniture Store platform provides a seamless and user-friendly
experience, catering to the diverse needs of customers, sellers, and service providers alike,
while ensuring efficient management and administration.
, CONTENT
SL. NO TOPIC PAGE NO
1 INTRODUCTION 1
1.1 PROJECT OVERVIEW 2
1.2 PROJECT SPECIFICATION 2
2 SYSTEM STUDY 4
2.1 INTRODUCTION 5
2.2 EXISTING SYSTEM 5
2.3 DRAWBACKS OF EXISTING SYSTEM 6
2.4 PROPOSED SYSTEM 6
2.5 ADVANTAGES OF PROPOSED SYSTEM 6
3 REQUIREMENT ANALYSIS 8
3.1 FEASIBILITY STUDY 9
3.1.1 ECONOMICAL FEASIBILITY 9
3.1.2 TECHNICAL FEASIBILITY 9
3.1.3 BEHAVIORAL FEASIBILITY 9
3.1.4 FEASIBILITY STUDY QUESTIONNAIRE 10
3.2 SYSTEM SPECIFICATION 12
3.2.1 HARDWARE SPECIFICATION 12
3.2.2 SOFTWARE SPECIFICATION 12
3.3 SOFTWARE DESCRIPTION 12
3.3.1 PYTHON DJANGO 12
3.3.2 SQLITE 13
3.3.3 BOOTSTRAP 13
3.3.4 HTML 13
3.3.5 JQUERY 13
4 SYSTEM DESIGN 14
4.1 INTRODUCTION 15
4.2 UML DIAGRAM 15
4.2.1 USE CASE DIAGRAM 16
4.2.2 SEQUENCE DIAGRAM 18
4.2.3 STATE CHART DIAGRAM 20
4.2.4 ACTIVITY DIAGRAM 21
4.2.5 CLASS DIAGRAM 23
,4.2.6 OBJECT DIAGRAM 24
4.2.7 COMPONENT DIAGRAM 26
4.2.8 DEPLOYMENT DIAGRAM 28
4.3 USER INTERFACE DESIGN USING FIGMA 31
4.4 DATABASE DESIGN 33
4.4.1 RDBMS 33
4.4.2 NORMALIZATION 33
4.4.3 SANITIZATION 37
4.4.4 INDEXING 37
4.5 TABLE DESIGN 37
5 SYSTEM TESTING 45
5.1 INTRODUCTION 46
5.2 TEST PLAN 46
5.2.1 UNIT TESTING 47
5.2.2 INTEGRATION TESTING 47
5.2.3 VALIDATION TESTING 47
5.2.4 USER ACCEPTANCE TESTING 48
5.2.5 AUTOMATION TESTING 48
5.2.6 SELENIUM TESTING 48
6 IMPLEMENTATION 64
6.1 INTRODUCTION 65
6.2 IMPLEMENTATION PROCEDURES 65
6.2.1 USER TRAINING 65
6.2.2 TRAINING ON APPLICATION SOFTWARE 66
6.2.3 SYSTEM MAINTENANCE 66
6.2.4 HOSTING 66
7 CONCLUSION & FUTURE SCOPE 70
7.1 CONCLUSION 71
7.2 FUTURE SCOPE 71
8 BIBLIOGRAPHY 72
9 APPENDIX 74
9.1 SAMPLE CODE 75
9.2 SCREEN SHOTS 111
, List of Abbreviation
UML Unified Modeling Language
UI User Interface
IDE Integrated Development Environment
HTML Hyper Text Markup Language
CSS Cascading Style Sheet
RDBMS Relational Database Management System
1NF First Normal Form
2NF Second Normal Form
3NF Third Normal Form
AJAX Asynchronous JavaScript and XML
JSON JavaScript Object Notation
PK Primary Key
FK Foreign Key
SQLITE Structured Query Language Lite
UAT User Accepatance Testing
ORM Object-Relational Mapping
IP Internet Protocol
This project introduces an innovative online furniture platform aimed at
revolutionizing the furniture shopping experience. Leveraging Django, a robust Python web
framework, it offers a secure and scalable e-commerce solution. The platform boasts a
comprehensive range of furniture products, complete with detailed descriptions, images, and
pricing, ensuring customers can make informed decisions.
For registered users, including customers, sellers, delivery agents, and maintenance
agents, the platform provides tailored functionalities. Customers benefit from features such as
product comparison, search and filtering, order tracking, and the option to rent items.
Additionally, they can engage with a chatbot, rate and review products. Sellers have a dedicated
dashboard to manage their inventory.
Administrators oversee the platform's operations, with capabilities to generate reports
and analytics, add and manage delivery and maintenance agents, and communicate with users
via email. Delivery agents can track assigned orders, confirm deliveries, and update statuses.
Maintenance agents schedule and log maintenance tasks, as well as generate quotations for
services.
Overall, Farzi Furniture Store platform provides a seamless and user-friendly
experience, catering to the diverse needs of customers, sellers, and service providers alike,
while ensuring efficient management and administration.
, CONTENT
SL. NO TOPIC PAGE NO
1 INTRODUCTION 1
1.1 PROJECT OVERVIEW 2
1.2 PROJECT SPECIFICATION 2
2 SYSTEM STUDY 4
2.1 INTRODUCTION 5
2.2 EXISTING SYSTEM 5
2.3 DRAWBACKS OF EXISTING SYSTEM 6
2.4 PROPOSED SYSTEM 6
2.5 ADVANTAGES OF PROPOSED SYSTEM 6
3 REQUIREMENT ANALYSIS 8
3.1 FEASIBILITY STUDY 9
3.1.1 ECONOMICAL FEASIBILITY 9
3.1.2 TECHNICAL FEASIBILITY 9
3.1.3 BEHAVIORAL FEASIBILITY 9
3.1.4 FEASIBILITY STUDY QUESTIONNAIRE 10
3.2 SYSTEM SPECIFICATION 12
3.2.1 HARDWARE SPECIFICATION 12
3.2.2 SOFTWARE SPECIFICATION 12
3.3 SOFTWARE DESCRIPTION 12
3.3.1 PYTHON DJANGO 12
3.3.2 SQLITE 13
3.3.3 BOOTSTRAP 13
3.3.4 HTML 13
3.3.5 JQUERY 13
4 SYSTEM DESIGN 14
4.1 INTRODUCTION 15
4.2 UML DIAGRAM 15
4.2.1 USE CASE DIAGRAM 16
4.2.2 SEQUENCE DIAGRAM 18
4.2.3 STATE CHART DIAGRAM 20
4.2.4 ACTIVITY DIAGRAM 21
4.2.5 CLASS DIAGRAM 23
,4.2.6 OBJECT DIAGRAM 24
4.2.7 COMPONENT DIAGRAM 26
4.2.8 DEPLOYMENT DIAGRAM 28
4.3 USER INTERFACE DESIGN USING FIGMA 31
4.4 DATABASE DESIGN 33
4.4.1 RDBMS 33
4.4.2 NORMALIZATION 33
4.4.3 SANITIZATION 37
4.4.4 INDEXING 37
4.5 TABLE DESIGN 37
5 SYSTEM TESTING 45
5.1 INTRODUCTION 46
5.2 TEST PLAN 46
5.2.1 UNIT TESTING 47
5.2.2 INTEGRATION TESTING 47
5.2.3 VALIDATION TESTING 47
5.2.4 USER ACCEPTANCE TESTING 48
5.2.5 AUTOMATION TESTING 48
5.2.6 SELENIUM TESTING 48
6 IMPLEMENTATION 64
6.1 INTRODUCTION 65
6.2 IMPLEMENTATION PROCEDURES 65
6.2.1 USER TRAINING 65
6.2.2 TRAINING ON APPLICATION SOFTWARE 66
6.2.3 SYSTEM MAINTENANCE 66
6.2.4 HOSTING 66
7 CONCLUSION & FUTURE SCOPE 70
7.1 CONCLUSION 71
7.2 FUTURE SCOPE 71
8 BIBLIOGRAPHY 72
9 APPENDIX 74
9.1 SAMPLE CODE 75
9.2 SCREEN SHOTS 111
, List of Abbreviation
UML Unified Modeling Language
UI User Interface
IDE Integrated Development Environment
HTML Hyper Text Markup Language
CSS Cascading Style Sheet
RDBMS Relational Database Management System
1NF First Normal Form
2NF Second Normal Form
3NF Third Normal Form
AJAX Asynchronous JavaScript and XML
JSON JavaScript Object Notation
PK Primary Key
FK Foreign Key
SQLITE Structured Query Language Lite
UAT User Accepatance Testing
ORM Object-Relational Mapping
IP Internet Protocol
