The first part of the project - (Completed) Build an E-commerce website application (final documentation attached) The second part - Open! Document how the web application is working and show 3 months

FINAL DOCUMENTATION: E-COMMERCE WEBSITE APPLICATION

E-COMMERCE WEBSITE APPLICATION

FINAL DOCUMENTATION

REVISION HISTORY 3

1 PROJECT OVERVIEW 3

1.1 ABSTRACT 3

1.2 INRODUCTION 4

2 PROJECT OBJECTIVES & EXPECTED BENEFITS 4

2.1 OBJECTIVES 5

2.2 MEASURABLE BENEFITS 5

2.3 CURRENT SYSTEMS 6

3 PROJECT DETAIL 7

3.1 OVERAL PROJECT DETAILS 7

3.2 TOOLS 8

3.3 PROBLEM DESCRIPTION 9

3.4 PROPOSED SOULTION 9

3.5 MILESTONES 10

4 PROJECT BUDGET 11

5 AGILE GANTT CHART 12

6 E-R DIAGRAM 13

7 CONCLUSIONS 14

8 REFERENCES 15

1. Date	Name	Comments	Version
   09/25/2019	Siddanth Maripeddi V	Initial	1.0
   12/03/2019	Siddanth Maripeddi V	Addition of Gantt Chart Addition of E-R Diagram Additional Content	2.0
   12/06/2019	Siddanth Maripeddi V	Final	3.0

   Project Overview
   1. Abstract

Technology is changing rapidly in today’s world. Advancement in fields such as Artificial Intelligence, Internet of Things, and machine learning are changing how we interact at the same time bringing innovative and smart devices that are increasing in demand. According to (Jim,2003), the global market for smart devices will be valued at $163 billion by the year 2020. It is also estimated there will be more billion devices connected to the year 2012. These statistics clearly indicate that smart devices will be craved as we go into the future. Therefore, to take advantage of this market, our e-commerce will sell smart devices like the digital thermostat, smart bulbs and the rest. In addition, we have noted due top-notch release of electronics periodically, people buy new electronics and have no use to old electronics they initially had. Therefore, we will buy and sell second-hand electronics which are not defective. This is given access to used devices to low-income people.

1. 1. INTRODUCTION

E-commerce websites, commonly known as an online store, are gaining popularity in today's technologized world. Many businesses have to migrate from retail or offline to online, where they are implementing websites that provide functionality for performing commercial transactions over the internet. Making online shopping common. Needless to say, customers are able to browse various products and select products that serve their needs. Selected items are collected in a shopping cart. At checkout time, the items in the shopping cart will be presented as an order. At that time, more information will be needed to complete the transaction. Usually, the customer will be asked to fill or select a billing address, a shipping address, a shipping option, and payment information such as a credit card number. An e-mail notification is sent to the customer as soon as the order is placed.

1. Project Objectives and Expected Benefits

The objective of this project is to develop an e-commerce store where a product such as a thermostat and other smart devices can be bought from the comfort of home through the Internet

• To enable people with non-defective electronics to sell their products

• To enable people in need of cheap and second-hand products to access them

• To deliver bought products to our customers

The proposed solution will provide high-quality smart devices at an affordable price to our prospects 24hours a day, seven days a week, with after-sale services to people with difficulties in installing and configuring smart technologies. In addition, the solution will provide a market where people with a second hand, but fully functional electronic devices can sell them thus earning extra income that is utilized in various means. Moreover, the proposed solution will provide an online store where people in need of secondhand products can access and by them at an affordable price, reducing the hassle of walking down the street looking for secondhand street sellers. Important to note, we deliver orders to big parts of the country within 24hours.

The market for Smart home has excellent potential for growth. Large corporations like Google and Amazon are key players in this industry. They have invested billions for dollars in research and development to innovate new smart technologies that empower folks to uncover and unreleased their potential. Therefore, in the future, more intelligent devices will hit the market. Therefore, to be part of this market in this segment will be challenging provided that the big player like google have more resources but this gives an opportunity to sell cheap smart home devices to customers. Also, at the moment, few online e-commerce websites sell non-defective second hand productive, yet people possess electronics that they do not use. Therefore, our website will ensure owners of secondhand products can post details of the products and once ordered they will send it to our offices to deliver it to the buyer. This will force owners to raise extra cash they do not use while buyers will benefit from accessing cheap products under challenging times; for instance, if you lost your iPhone 9 today, you may find it hard to afford another new iPhone. Therefore, you can check online and buy a second-hand phone while finding the means to purchase new ones. This will also cater to the poor communities across the country.

1. Project Detail

   1. overall project details

New users can register, then log in and view all available products under all the categories. Registered members only can be able to purchase products regardless of quantity depending on the amount in their PayPal or credit card account. The Contact Us page provides details on how to contact Admin personnel for queries. The User can browse and purchase products. The Admin can perform administration function and also, he has all privileges of visitor and username. Moreover, he can add products, edit product information, remove the product. Also, he can add users, edit user information and delete a user. Admin can ship the order to the user based on the order placed by sending a confirmation mail.

Use Case Diagram:

1. 1. TOOLS

Server Software

In this project, we are going to use the Apache webserver or the cloud server. The server of great importance on the Internet. For example, when a person visits a web page on a web browser, web servers can know what the client is requesting. So, it processes that information and responds to the request by sending the correct files to the client who is displayed on the user files.

Web Tools

The project will be developed using the Atom text editor. An atom text editor is Web authoring tools used to create the front end of an online store. Also, to make an appealing online store, we will employ sophisticated graphics authoring tools such as photoshop to edit images of products. In addition, the project will use a content management system with built-in frameworks and debugging tools.

Html files are created using the AngularJS framework along with the cascading style sheet which will enhance the visual appearance of the application. JavaScript, which is a server-side scripting language, will be used to write web script to make them more interactive. Besides, bootstrap and jQuery will be used to make the online store responsive to the screen of the viewer.

Database System

A database is critical on an e-commerce website. Database's primary role is to store information about the website, such as product name, user’s data, product pricing, descriptions, product images, and other sales details. Also, to this, the customer orders, payment details, shipping information, and contact details are stored. In this project, several Technologies such as PHP and MySQL will be used to create communication between the website database management system.

1. 1. Problem Description

Today the world is more technologized than ever; there is more demand for smart devices to meet this demand; the proposed solution is to sell cheap smart devices. In addition, we realized to many people are tech-savvies, for this reason, we sell smart devices and then offer free after-sale service support such as configuration and installation. The second problem is that people have many fully functional electronic devices that they are not using because they do not know where to sell them. On the other side, people are looking for cheap second-hand products, but they do know where to get them. Thus, the proposed solution will provide an avenue where the individual can sell and buy second-hand devices

1. 1. Proposed Solution

The proposed solution is an e-commerce web application that enables users to purchase high-quality smart gadgets at an affordable price. In addition, it will offer a market where people with fully functional electronic devices that they are not using can sell them thus earning extra income. By doing so, it will make it hassle-free for people looking for cheap second-hand products. Important to note, the proposed solution will ensure our customers who are not tech-savvy get after-sale support, which includes free configuration and installation services.

1. 1. Milestones

Since an agile development plan is deployed in developing this web application, the project is divided into three major sections or milestones which are being tackled separately then, later on, they will be integrated to form the web application. The first milestone entails the front end. The front end involves the design of the user interface and will form the screen with which the user will interact with the system. So far, this first milestone is 65percent complete. The second part or second milestone involves the design and implementation of a database where vital details pertaining to the users, administration products and payment details will be stored. This part is very critical and significant progress has been made, we have managed to create tables to some are incomplete but the end of January the work will be 90 percent complete. At the moment we are at 30%. The last milestone entails payment integration. So far, PayPal and credit card payment will be the only means of payment at the first release of the project, however, in the future, we intend to incorporate other methods of payment such as Payoneer, among others. So far, this milestone is at high risk because 10 percent of the work is complete.

1. Project Budget

The below grid represents the project budget needed to set a fully functional E-Commerce application based on my analysis. With the availability of various open source today in the market for independent business use the software cost is mainly applicable only for hosting and maintain domain requirements.

1. agile gantt chart

   Milestone Description	Category	Assigned To	Progress		Start		No. Days
   Title 1
   Task 1	On Track	Tool installation	100%		11/2/2019		2
   Task 2	On Track	Modelling UML diagrams	100%		11/5/2019		5
   Task 3	Low Risk	Home page	100%		10/30/2019		2
   Task 4	On Track	About Us page	15%		11/22/2019		1
   Task 5	On Track	Contac Us page	100%		11/24/2019		1
   Task6	On Track	Product page	20%		11/25/2019		1
   Task7	On Track	Login page	50%		12/1/2019		1
   Task 8	On Track	Register Page	60%		12/3/2019		1
   Task 9	On Track	Admin Page	0%		12/5/2019		3
   Task 10	On Track	Database design	15%		12/10/2019		15
   Task 11	On Track	Linking frontend and backend	0%		1/8/2020		7
   Task 5	On Track	PayPal Integration	0%		1/18/2020		14
   Title 3	On Track	Testing the Application	0%		2/5/2020		2
   Task 1	On Track	Documentation of the final report	15%		2/7/2020		7
   Task 2	On Track	Power point	100%		3/1/2020		1
   Task 3	On Track	Presentation			3/16/2020		1
   To add more data, Insert new rows ABOVE this one

2. E-R DIAGRAM

This below ER – Diagram represents the below database contents:

Users: User and Admin information are added to the database with Unique ID based on their roles.

Shopping: Complete product information is stored in this table.

Orders: Customer ordered products, status, and delivery information are stored in this table.

1. conclusion

Advancement in technology has made the Internet an essential resource in business; for this reason, online shopping using electronic gadgets has gained popularity in modern society from both entrepreneur’s customers. From the entrepreneurship point of view, online shopping creates new business opportunities, and for the customer, it makes shopping easy. As per a survey, most consumers of online stores are impulsive and usually decide to stay on a site within the first few seconds. Therefore, we are dedicated to creating an artistic and easy to use the online application, which is why the project is designed to provide easy navigation, retrieval of data, and necessary feedback as much as possible. The tools to help accomplish the project are AngularJS, jQuery, Bootstrap programming languages such as JavaScript and including the markup language HTML and cascading style sheet. Graphic tools such as Photo studio and content management tools will be employed in making the website appealing. To store products and user information we create a database using MySQL AND Apache server. PayPal and credit card will be the only available payment options.

1. REFERENCES

• Bryan Syverson, Joel Murach, Murach’s SQL Server 2012 for developers, Murach, 2012.

• http://www.w3schools.com/

• http://msdn.microsoft.com/

• http://agilemodeling.com/