ACKNOWLEDGEMENT and table of content of E-shopping

ACKNOWLEDGEMENT

          This report has been prepared for the Final Year Project on topic “E-shopping named Rupjaygri Shop” to implement the theory in the real field with the purpose of fulfilling the requirements of the course of BCIS (Bachelor of Computer Information System).

          The aim of this project is to make familiar to the practical aspect and uses of theoretical knowledge and clarifying the career goals, so we have successfully completed the project and compiled this report as the summary and the conclusion that we have drawn from the project.

          We would like to express our sincere gratitude to our Project Coordinator Mr. Sanjay Lama who had given his valuable time and given us chance to learn something despite having his busy schedule, Principal Mr. Kamal Bhattari and Coordinator Mr. Dipesh Shrestha for their great guidelines.

Lastly, we would like to thank Mr. Nimesh Shrestha who had provided us with the guidance and his easiest MVC framework and for his encouragement, patience and expert advice and also for supplying so much invaluable information and finally special thanks go to my friends and family who have supported us throughout our project.

Table of Contents

SN	Contents		Page No
a.	Title Page		i
b.	Declaration		ii
c.	Recommendation		iii
d	Acknowledgement		iv
e.	Table of Contents		v
f.	List of Figures		vii
g.	Executive Summary		ix
h.	Chapters
	1.      Introduction 1.1.   Background of the Study 1.2.   Objectives of the Study 1.3.   Features of RupJayGri Shop 1.4.   Limitations of the Study 1.5.   Future Enhancement 2.      Project Development 2.1.    Project Design 2.1.1        Data Model 2.1.2        Database Design 2.1.3        Process Model 2.1.3.1  Function Decomposition Diagram 2.2.3.2  Data Flow Diagram          2.1.3.3User Interface Diagram 2.2      The Magic of Three Tier Architecture 2.3      Choosing Technologies and Tools 2.3.1        Using PHP to Generate Dynamic Web Content 2.3.2        Apache Web Server 2.3.3        MySql Database 2.3.4         Macromedia Dreamweaver 2.4       Choosing Naming and Coding Standards   3. Work Flow of RupJayGri Shop    3.1 Web Page Flow in RupJayGri Shop 3.2  Showing Visitors what we have got? 3.3  Detailed View Of the Product 3.4   Displaying the Search Results 3.5   Administration Section 3.6   How to Add Product? 3.7   Folder Structure 3.8  Search Engine Optimization    3.9 Customer Signup 3.10    Customer Login 3.11  Shopping Cart 3.12Placed order and Proceed Checkout 3.13Confirming the Information 3.14How to Shop in the RupJayGri? 3.15Product Reviews    4.  ER diagram and UML Diagram     4.1 Use Case     4.2 ER Diagram 5. Literature Review 6.  Conclusion		1 1 2 3 3 4 5 5 5 6 8 8 11  13  13  15 16 16 17 18 18 20 22 23 23 23 24 25 26 27 28 28 29 29 29 31 32 32 34 35 38
i.	Bibliography		40

List of Figures

S.N	Name of Figures	Page no
Fig 2.1	Data Modelling of Whole Project	6
Fig 2.2	Schema Diagram of RupJayGri	7
Fig 2.3	Function Decomposition of Diagram	9
Fig 2.4	Customer Browse Context DFD	11
Fig 2.5	Customer Shopping Cart Context DFD	11
Fig 2.6	Shopping Cart Detailed DFD	12
Fig 2.7	Customer Authentication Context DFD	12
Fig 2.8	Front Page of RupJayGri Shop with menu	13
Fig 2.9	Example of information Exchange among application tiers	14
Fig 3.1	Division of Webpage	20
Fig 3.2	Header Part	20
Fig 3.3	Code Snippet of the Body part	21
Fig 3.4	Category of Product	22
Fig 3.5	Code snippet to show details of the Product	23
Fig 3.6	From For Searching the product	23
Fig 3.7	Product Management	24
Fig 3.8	Product List	24
Fig 3.9	Add and Edit Product	25
Fig 3.10	Folder Structure	26
Fig 3.11	Url Bar	27
Fig 3.12	Customize Sign Up	27
Fig 3.12	When Customer Login for the first time	28
Fig 3.13	Place Order and Proceed check	29
Fig 4.1	UML Diagram of customer relationship	32
Fig 4.2	UML Diagram customer payment process	33
Fig 4.3	UML Diagram how customer get satisfied	33
Fig 4.4	ER diagram of Customer entity	34
Fig 4.5	ER diagram of Product entity	34

ABBREVIATION USED

ERD	Entity Relationship Diagram
MVC	Model Controller View
DFD	Data Flow Diagram
XML	Extensible Mark UP Language
CMS	Content Management System
HTML	Hyper Text Markup Language
SQL	Structure Query Language
RFQ	Request For Quotation
SEO	Search Engine Optimization
E-Commerce	Electronic-Commerce
GVU	Graphics Visualization Usability

EXECUTIVE SUMMARY

          The main objective of this report is to recapitulate our Final Year Project on “E-shopping named Rupjaygri Shop” and to be familiar with practical aspect of the theoretical knowledge gained in a classroom. This report is the part of final year project, required by Pokhara University in partial fulfillment for the requirement of BCIS program.

         We (Rupak Nepali, Jayman Tamang and Grishma Shah) feel that Nepal is progressing in ICT field thus the import and export of this country is mounting with the help of ecommerce and e-businesses. Thus, there is need of shopping software so that people can broaden their business worldwide.

            Our Team was inspired by the quote “Handicrafts are promoted by ecommerce”. With taking the fact into consideration we are doing this shopping project so that every product in Nepal can be promoted online and sell it online on every part of world and at any time.

The overall objective of this project is to explore the impact of e-commerce technologies on future development of shopping in Nepal. This project aims to improve understanding of the impact of e-commerce (essentially B2B) on economic sectors and of its policy implications.