South Asian Journal ofEngineering and Technology Vol.5, No.1 (2018) 6–14
ISSN No: 2454-9614
[S1]
Online Resource Planning Using Supply Chain Management
Nivetha.N1, Priyanka.R2, Sowmia narayani.A3, Rajasekaran.G4
Department of Computer Science and Engineering, Vivekanadha college of Engineering for women,
Nammakal, Tamilnadu, India.
*Corresponding Author: N.Nivetha
Phone: 7598244950
E-mail:,
Received: 9/1/2018, Revised: 14/2/2018 and Accepted: 1/4/2018
Abstract
“Supply Chain Management System” is the management of interconnected network service packages required by end customers. It spans all movement and storage of raw materials, work-in-process inventory, and finished goods from point-of-origin to point-of-consumption. The specific purpose of the system is to automate the communication between the Producer (Owner), Dealers (Online & Offline) and Consumers .
© 2018 Ishitv Technologies LLP All rights reserved.
Keywords:On-line shopping, Information system, Database, Buyers, Sellers.
- INTRODUCTION
The project titled online shopping is designed to provide the security for shopping transactions. There is no doubt that the world is witnessing a revolutionary change in the way in which it conducts its daily affairs with the Internet. People from different continents are able to interact with one another cheaply and efficiently as though they were borderless. After analyzing the requirements of the task to be performed, the next step is to analyze the problem and understand its context. The first activity in the phase is studying the existing system and other is to understand the requirements and domain of the new system. Both the activities are equally important, but the first activity serves as a basis of giving the functional specifications and then successful design of the proposed system. Understanding the properties and requirements of a new system is more difficult and requires creative thinking and understanding of existing running system is also difficult, improper understanding of present system can lead diversion from solution. The project electronic Product market is a web application which maintains a transparency between the whole seller and retailer. With the help of this application Customer can be able to know the best value for his Electronic product fooled by the marketers. This application makes the customer requirement become easy. It helps in proper maintenance of data and information. One can easily browse through the various details using the well-defined interfaces provided by the system. So we can easily identify the item and we can purchase tithe user can purchase the items with guarantee and any damage in phase item .we can show it with the bill and you can exchange the master entry deals with customer and product. The item purchase master entry deals with purchase details and purchase return. Here we can add view, modify and delete particular item purchase for conversion .
Shopping online can save time. The stores are never closed. Therefore, people can shop whenever they want. This is one of the attractiveness for people to shop online particularly for those busy people who can hardly make time from their busy schedules to go for a shopping. It is very convenient for customers to buy things within several clicks. Shopping online does not require people to go for a shop personally. That means that online buyers leave small carbon footprint compared with people driving to real stores. Online shopping provides a noiseless environment to shop without the sellers rattling all the time or trying to persuade customers to buy more things that are no necessary. In this case, online shoppers are less likely to be influenced by the talkative salespersons and can go buy the original shopping list.
Shopping online and shopping in-stores share some similarities and differences. There is no absolutely correct answer of which one is better. It depends on various situations. Shopping online is better for those who live in the suburbs or have to drive several miles each way to go shopping. On the other hand, shopping in-store is better for those who can get what they need at a location that a few steps away. So, for many of us, a combination of both online shopping and in-store shopping will produce the greenest results.
2. OBJECTIVES
•The project with this Product market is a web application which maintains a transparency between the whole seller and retailer.
•With the help of this application Customer can be able to know the best value for his Electronic product fooled by the marketers.
•It helps in proper maintenance of data and information. One can easily browse through the various details using the well-defined interfaces provided by the system.
•So we can easily identify the item and we can purchase to the user and can purchase the items with guarantee without any damage in phase item .
•we can show it with the bill and you can exchange the master entry deals with customer and product, this application makes the customer requirement become easy ..
•The item purchase master entry deals with purchase details and purchase return. Here we can add view, modify and delete particular item purchase for conversion.
3. LITERATURE SURVEY
This chapter will mainly discuss on the study that are done by previous research of other authors in the similar area of the present study. Throughout this chapter, there will be comprehensive discussion on theoretical and practical views of previous studies done in online shopping and offline shopping for apparels. This study combines factors that other studies have done that will influence the consumer's purchasing decision in online and offline stores for apparels. It includes the price attractiveness, time saving, perceived risk, enjoyment and excitement, tangibility and high interactivity. All of these factors will contribute to the study of customer's purchasing intention for apparels on both stores which includes online and offline shopping. Pan, (2007) defined purchasing intention as the eagerness of purchasing the product. Similarly, Engel, Blackwell and Miniard, (1990) defines purchasing intention as a psychological process of decision-making. In online shopping, it is expected that shoppers are more likely to associate price attractiveness and time saving with their intention to shop while in offline shopping, consumers are more likely to associate tangibility, high interactivity and enjoyment with their intention to shop. As a result, online marketers or retailers should be aware of the problems faced by the consumers and their perceived risk to increase their intention to shop in online. Designers must take note of consumers' needs because the usability is the starting point to get the confidence and support of the consumers (Alzola et. al., 2006).
Research Variables
In this part of the study, definition and citations from other authors of the dependent and independent variables in the similar area of research will be presented here.
Purchase Intention
From the study of Pan (2007, p.5), the author cited from Engel, Blackwell and Miniard (1990), that defines purchasing intention as a psychological process of decision-making. According to Pan (2007), "purchasing decision process" is when the relevant information is searched by the consumers that are motivated by the fulfillment of demands according to personal experience and the external environment; then after accumulating a certain amount of information, they begin to evaluate and consider; and finally after comparison and judgment, they make the decision on certain products.
The last factor that will influence consumer's intention purchase in online is the trust in online shopping. According to Lee and Turban (2001), reasons that consumers choose not to shop online is because consumers lack of trust in online shopping. Attitude towards security transaction such as payment security, consumer information privacy, return policy, and product shipping guarantee predicts online purchasing intentions for apparels product (Kim, et. al., 2003). Similarly, consumer's trust towards online shopping is based on the level of security and privacy.
Price attractiveness
Price is a form of monetary that people use for any transactions. It is predicted that price of a product differs in online and offline shopping. According to Xia and Monroe (2009), consumers will save in monetary when there are price promotions on specific products. In an online context, consumers are more likely to depend on the price cues to determine the quality of a product which are presented in the web site because they cannot see or touch the actual product (Jiang and Rosenbloom, 2005). The study of So, Wong and Sculli (2005) resulted that when there is the presence of promotional offers, consumers will have higher intention to purchase in web-shopping; purchasing decisions and choice making from alternative evaluations can be made easily when there is the presence of promotional offers.
Pricing factor will also contribute to the shopping convenience. Price perception is positively and strongly correlated with shopping convenience (Jiang and Rosenbloom, 2005). Similarly agreed by Jayawardhena and Wright (2009), shoppers who value convenience can obtain the benefits of product and services with less money spent and this would have a positive relationship with shoppers' excitement; increasing search efficiency by eliminating travelling costs and psychological costs brings convenience in e-shopping.
4.SYSTEM ANALYSIS
System analysis is the process of gathering and interpreting facts, diagnosing problems and using the information to recommend improvements on the system. System analysis is a problem solving activity that requires intensive communication between the system users and system developers. System analysis or study is an important phase of any system development process. The system is viewed as a whole, the inputs are identified and the system is subjected to close study to identify the problem areas. The solutions are given as a proposal. The proposal is reviewed on user request and suitable changes are made. This loop ends as soon as the user is satisfied with the proposal.
Product Description:
The system consists of two parts .A web application which can provide the online shopping service and an android application for the customer to access the web service from his Smartphone. Web application should be able to help the customer for selecting his item and to help the owner in managing the orders from the customers.
Problem Statement:
As online shopping became a trend nowadays the regular shops are losing their customers to online brands. Customers have effortless shopping experience and saving time through shopping online. For competing with those online brands, if shops are providing an online portal where their customers can shop through internet and get the products at their doors it will increase the number of customers.
5.SYSTEM REQUIREMENTS
NON FUNCTIONAL REQUIREMENTS
i. EFFICIENCY REQUIREMENT
When an online shopping cart android application implemented customer can purchase product in an efficient manner.
ii. RELIABILITY REQUIREMENT
The system should provide a reliable environment to both customers and owner. All orders should be reaching at the admin without any errors.
iii. USABILITY REQUIREMENT
The android application is designed for user friendly environment and ease of use.
iv. IMPLEMENTATION REQUIREMENT
Implementation of the system using CSS and HTML in front end with JSP as back end and it will be used for database connectivity. And the database part is developed by MYSQL Responsive web designing is used for making the website compatible for any type of screen.
v. DELIVERY REQUIREMENT
The whole system is expected to be delivered in four months of time with
FUNCTIONAL REQUIREMENTS
USER LOGIN
Description of feature
This feature used by the user to login into system. A user must login with his user name and password to the system after registration. If they are invalid, the user not allowed to enter the system.
Functional requirement
Username and password will be provided after user registration is confirmed.
Password should be hidden from others while typing it in the field.
ADMIN
MANAGE USER
Description of feature
The administrator can add user, delete user, view user and block user.
Description of feature
The administrator can add moderator, delete moderator, and block moderator and search for a moderator.
MANAGE PRODUCTS
Description of feature
The administrator can add product, delete product and view product.
MANAGE ORDERS
Description of feature
The administrator can view orders and delete orders.
Functional requirements
The system must identify the login of the admin.
6. WORKING PRINCIPLE
SYSTEM DESIGN
System design is the solution for the creation of a new system. This phase focuses on the detailed implementation of the feasible system. It emphasis on translating design.Specifications to performance specification. System design has two phases of development
Logical design
Physical design
During logical design phase the analyst describes inputs (sources), output s(destinations), databases (data sores) and procedures (data flows) all in a format that meets the user requirements. The analyst also specifies the needs of the user at a level that virtually determines the information flow in and out of the system and the data resources. Here the logical design is done through data flow diagrams and database design. The physical design is followed by physical design or coding. Physical design produces the working system by defining the design specifications, which specify exactly what the candidate system must do. The programmers write the necessary programs that accept input from the user, perform necessary processing on accepted data and produce the required report on a hard copy or display it on the screen.
INPUT AND OUTPUT DESIGN
INPUT DESIGN:
Input design is the link that ties the information system into the world of its users. The input design involves determining the inputs, validating the data, minimizing the data entry and provides a multi-user facility. Inaccurate inputs are the most common cause of errors in data processing. Errors entered by the data entry operators can be controlled by input design. The user-originated inputs are converted to a computer based format in the input design. Input data are collected and organized into groups of similar data. Once identified, the appropriate input media are selected for processing. All the input data are validated and if any data violates any conditions, the user is warned by a message. If the data satisfies all the conditions, it is transferred to the appropriate tables in the database. In this project the student details are to be entered at the time of registration. A page is designed for this purpose which is user friendly and easy to use. The design is done such that users get appropriate messages when exceptions occur.
OUTPUT DESIGN:
Computer output is the most important and direct source of information to the user. Output design is a very important phase since the output needs to be in an efficient manner. Efficient and intelligible output design improves the system relationship with the user and helps in decision making. Allowing the user to view the sample screen is important because the user is the ultimate judge of the quality of output. The output module of this system is the selected notifications.
DATABASE
DATABASE DESIGN:
Databases are the storehouses of data used in the software systems. The data is stored in tables inside the database. Several tables are created for the manipulation of the data for the system.
Two essential settings for a database are :
- The field that is unique for all the record occurrences.
- The field used to set relation between tables. Normalization is a technique to avoid redundancy in the tables.
ARCHITECTURE DIAGRAM
7. CONCLUSION
The project entitled Online shopping system was completed successfully. The system has been developed with much care and free of errors and at the same time it is efficient and less time consuming. The purpose of this project was to develop a web application and an android application for purchasing items from a shop. This project helped us in gaining valuable information and practical knowledge on several topics like designing web pages using HTML &CSS, usage of responsive templates, designing of android applications, and management of database using MYSQL . The entire system is secured. Also the project helped us understanding about the development phases of a project and software development life cycle. We learned how to test different features of a project. This project has given us great satisfaction in having designed an application which can be implemented to any nearby shops or branded shops selling various kinds of products by simple modifications. There is a scope for further development in our project to a great extend. A number of features can be added to this system in future like providing moderator more control over products so that each moderator can maintain their own products. Another feature we wished to implement was providing classes for customers so that different offers can be given to each class. System may keep track of history of purchases of each customer and provide suggestions based on their history. These features could have implemented unless the time did not limited us.
REFERENCES
[1] Anyny (2009). E-commerce and Internet Industry in Nigeria. Retrieved on July 1,2009 at
[2] Birkin M., Clarke, G. and Clarke, M. (2002). Retail Geography and Intelligent Network Planning, Chictster:Wiley.
[3] Bakos Y. (1998). The Emerging Role of Electronic Marketplaces on the Internet.Communications of the ACM,41 (8), pp. 35 – 42.