Final Project Proposal

Project Proposal

Online Shopping System SUBMITTED BY:

Enrollment Numbe Numberr Name Program Code

: : :

ONLINE SHOPPING SYSTEM

Course Code TABLE

: OF

CONTENTS



Title Of The Project...... Project.............. ............... ........................ ........................................3 .......................3



Objective.............................................................................4



Introduction......... Introduction................ ............... ............... ................................................5 .........................................5



Project Category........... Category.................. .............. ............... ........................................6 ................................6



Modules...............................................................................7 Administrator User Search Payments Product Report Generation

• • • • • •



Input to the project........... project.................. ............... ............... ........................ ............................8 ...........8



Output of The Project..........................................................10



Analysis...............................................................................11 11 Process Logic 13 Data Flow Diagrams 24 Entity-Relationship Entity-Relationship Diagram 26 Database Tables Testing 28

• • • • •



Limitations of Project........... Project.................. ............... ................................. ................................29 .......29



Tools/Platform, Languages Languages To Be Used....... Used.............. ............... .................30 .........30



Are you doing this Project for any Industry........... Industry.................. ..............35 .......35



Scope Of Future Application......... Application...............................................36 ......................................36

2


3


T ITLE OF T HE PROJECT


4


OBJECTIVE There are following objectives of doing this project. •

To make Global

•

To facilities product search

•

•

To facilitate User Products available

so that it can search for best

To help visitors to fetch a right product

•

User can search for different products available

•

User can search for different options available

•

User can do online request posting etc

•

User can search engine to look for different products available

•

User can buy products on-line

•

To increase bank transactions

•

User can down load different forms etc

5


INTRODUCTION Our vision is an Online Shopping System and enables all customers to customize the merchandize or service that they want. This vision that we bring to Online Shopping System. As the name implies, we would like to deliver unprecedented value products to you, be it in terms of price, or delivery or post-sales service or tailored products to suit your specific needs. We value your business and deem it a great privilege to serve you. We promise you the best, and more to come along the same lines. In this shopping site a user can log in and can register him and can search for products. Online Shopping System is a well-known company serving Indians and others, with a variety of electronic products which include laptop, hard disk, Pen drive, Cabinets and switches.

For us, customer service is not just a credo, but a success strategy, since we have found our satisfied customers bringing us new customers, helping us grow without conventional promotional and advertising activity. It is this strategy and credo that we offer to you. Besides customer service, what drives us is our conviction, that the internet can transform the way we shop - save us time and money, and most importantly, help us get exactly what we want. Only you, our customer know what you want. Our business is to help you share that with us, so that we can increasingly find a closer match to it. Eventually, we would like to proactively notify you of what you may be interested in. In any event, our stores should be increasingly able to reflect the ability to fulfill your needs, uniquely and completely. We could call that our mission. Our vision is an Online Shopping System experience that is highly intuitive and interactive and enables all customers to customize the merchandize or service that they want. It is this vision that we bring to eshopping.com. As the name implies, we would like to deliver unprecedented value products to you, be it in terms of price, or delivery or post-sales service or tailored products to suit your specific needs. We value your business and deem it a great privilege to serve you. We promise you the best, and more to come along the same lines. 6


7


Project Category OOP (OBJECT ORIENTED PROGRAMMING) Object Oriented Programming is at the core of Java. All the Java programs are to at least some extent object oriented programming.

The Three OOP Principals All object oriented programming languages provide mechanisms that help to implement the object oriented model. They are ENCAPSULATION : Encapsulation is a mechanism that binds together code and the data it manipulates, and keeps both safe outside interference and misuse. b) INHERITANCE : Inheritance is the process by which one object acquires the properties of another object. This is important because it supports the concepts of hierarchical classification. c) POLYMORPHISM : Polymorphism is a feature that allows one interface to be used for general class of actions. a)

8


MODULES SPECIFIC REQUIREMENTS MODULE 1: ADMINISTRATOR MODULE The administrator of the site will have the following responsibilities: An Administrator can add, delete or modify the Store, Category and Product. An administrator shall control all activities taking place on this web portal. An admin shall grant rights to the User to view or block particular pages. The admin shall be able to view the reports. •

•

•

•

MODULE 2: USER MODULE •

•

•

•

The user who is trying to access the Online Shopping must login to the application by providing login id and password. A log file is created on the server side to view, the details of users who tried to access the system and what was the IP of the system that accessed it. The user who is unregistered he/she must have to register for purchasing any product. Registration of a User will have Name, ID, Address, Password, user bank account details, user contact number etc are inputs provided by the user Only a valid User can buy a product.

MODULE 3: SEARCH MODULE •

User can search on the site about products. This module is available to every valid/invalid user of this site

MODULE 4: PAYMENT GATEWAY •

Online Payment

MODULE 5: PRODUCT •

Every Product will have Product ID, Name, Model Number, Market Price, Own Price, Warranty and Image.

MODULE 6: REPORT GENERATION System shall be able to generate various reports like

9

ONLINE SHOPPING SYSTEM • • •

Channel wise report a film All the film running on a channel Films made between particular date

PROJECT INPUT The input to project can be classified in two different ways which are explained as below:-

USER LEVEL OPERATION 

USER REGISTRATION : •

•

•

In this the user gives all the relevant details for registering him to the site by filling up the user registration form. This form includes user name, user ID, user age, user address, user bank account details, user contact number etc are inputs provided by the user. These details are reviewed permanently in the database.

and

stored

ADMINISTRATOR LEVEL OPERATION 

STORE : •

•

•

In this the administrator gives all the relevant details required for create/delete or modification on any store by filling up the store form. This form includes store name, store ID, total number of categories it can handle etc are inputs provided by the administrator. These details are reviewed and stored permanently in the database.

10

ONLINE SHOPPING SYSTEM 

CATEGORIES : •

•

•



A store contains different categories, in this the administrator gives all the relevant details required for create/delete or modification on any category to a store by filling up the category form. This form includes category name, category ID, total number of Products/items it can handle, store name etc are inputs provided by the administrator. These details are reviewed and stored permanently in the database.

PRODUCTS: •

•

•

In this the administrator gives all the relevant details required for create/delete or modification on any Product to respective category by filling up the Product form. This form includes Product name, Product ID, category, Product price etc are inputs provided by the administrator. These details are reviewed and stored permanently in the database.

11


PROJECT OUTPUT •

•

•

•

•

•

This project process all the input provided to it i.e. the user details, store details category details and Product details. After processing the business logic this project generates various reports such as follows: The main view contains the list of various stores available and a space for a registered user to login for finalizing the Product. As the store chosen by the visitor, a view containing the list of various categories is appeared in front of the user. A view containing list of various Product available for the user in a particular category. A view containing the complete details about any Product, on the basis of which a visitor makes a decision weather to finalize the Product or not. A view containing the details about the finalized Product by the user.

12


ANALYSIS 

PROCESS LOGIC •

•

•

•

•

•

•

•

•

ONLINE SHOPPING S YSTEM’s main function is to manage and provide best Products available on the internet to a visitor of the site. ONLINE SHOPPING S YSTEM helps a visitor to browse through the available Products on the website. The whole process of the Product Management project goes as follows: The visitor visits the site and searches for required Product or item he can search for any Product according to price, expiry date, Store or category. The project maintains all the relevant details about any Product to attract the visitor. Visitor can select any Product by searching or surfing the site. If the visitor selects any Product then he is authenticated for his validity. The control now flows to the login page where only a valid user can login. If a user is already registered then he gives his user name and password. Then this password is verified by the user data source. If it founds a match in the data source then the welcome screen appears In front of user. If a user is not registered then he must first register himself before finalizing any Product. Any user can register him just by giving some essential details. These details are stored in the user database. If a Product is finalized by the user then the systems asks for the user’s bank account details for his/her payments. Now for the process followed by the administrator: The administrator performs the controlling functions for the project. He adds various stores to the database. Stores are just like departments it contains various categories. Administrator can add, delete or modify any store details. The store contains various categories; these categories are also added by the administrator. Categories i.e garments, electronic goods, books etc contains the actual Products for

13


•

•

•

•

•

•

•

the visitors. These categories are added by the administrator. Administrator can add, delete or modify these categories as per the requirements. The main purpose of the administrator is to manage the various Products/items. The administrator assigns various Products available to their respective category. At any time he can add, delete or modify the details of any Product/item. Administrator can also view the details of various users, if he need to. If some Products are not available to the visitor due to some reason then the administrator can block that particular Product. The visitor can only view the details of unblock Products. If some Product is blocked then the visitor cannot view their details. Administrator generates various reports on the Products made by the users. This helps the higher authorities to evaluate the total revenue earned by the firm. The administrator can view the details about Products made by any user. This contains Product_ID, Product_price etc.

14


D ATA FLOW DIAGRAMS

Administrator

Manage Products, store, category and user

Browse, Search & Sort Products

Online Shopping System

Subscribe/ unsubscribe for news & letters

Registered User

Visitor

0 l

v e

L e

D

D F .

F ig

15


Administrato r

1. Add /Edit Store

2. Add /Edit Category

l

3. Add/Edit Product

1

v e

L e

s k

T a

n i

m

A d

D

D F .

g

F i

16


Administrato r

Store Data Store

1.1 Obtain Store details

1.2 Generate a unique store id

1.3 Save Store details

l

2

v e

L e

e r

o t

S

d

A d

D

D F .

g

F i

17


Administrator

1.1 Get Store details

Store Data Store

1.2 Edit Store details

1.3 Save Store details

l

2

v e

L e

e r

o t

S it

E d

D

D F .

g

F i

18


Administrat or

Category Data Store

2.1 Obtain Category details

2.2 Generate a unique Category_id

2.3 Save Category details

l

2

v e

L e

ry

g o

te

C a

d

A d

D

D F .

g

F i

19

ONLINE SHOPPING SYSTEM Administrat or

Store Data Store

Category Data Store

2.1 Get Store List

2.2 Select a Store to add category

2.3 obtain Category details

2.5 Save Category details

2.4 Generate a unique Category_id

l

3

v e

L e

ry

g o

te

C a

d

A d

D

D F .

g

F i

20


Administrato r

2.1 Get a Category to edit

Category Data Store

2.2 Obtain details to edit

2.3 Update Category details

l

2

v e

L e

ry

g o

te

C a it

E d

D

D F .

g

F i

21


Administrat or Product Data Store

3.1 Obtain Product details

3.2 Generate a unique Product id

l

3.3 Save Product details

2

v e

L e t

u c

o d r

P

d

A d

D

D F .

g

F i

22


Category Data Store

Administrator

Product Data Store

3.1 Get Category List

3.2 Select a Category to add Product

3.3 obtain Product details

3.4 Generate a unique Product id

l

3

v e

L e t

u c

3.5 Save Product details

o d r

P

d

A d

D

D F .

g

F i

23

ONLINE SHOPPING SYSTEM Administrato r

3.1 Get a Product to edit

Product Data Store

3.2 Obtain details to edit

3.3 Update Product details

l

2

v e

L e t

u c

o d r

P it

E d

D

D F .

g

F i

24


Product Data Store Visitor 1. List Product s 2. Block Product

Fig. DFD Product Listing level 1

Visitor

1.1 List Products by Price

1.1 List Products by Expiry Date

1.1 List Products by Category

Product Data Store

Fig. DFD Product listing level 2

25

ONLINE SHOPPING SYSTEM  E-R

Nam e

DIAGRAM

Nam e

Password

Id

Create s

Administrator

Addres s

Client

Password

Nam e

Nam e

Password

Administrator

Create s

Contact no.

Id

Addres s

Visitor

Password

Contact no.

26


Nam e

Nam e

Password

Administrator

Id

Password

Operator

Instruct

Addres s

Passwor d

Id

Operator

Name

Name

Interacts

Contact no.

Contact no.

Descriptio n

Client

Duration

27


Database Tables

User Table Field

D ATA

User_Name Password First_Name Mid_Name Last_Name Address City State Pin_code Email Phone no Account no

VARCHAR2(30) VARCHAR2 (15) VARCHAR2 (20) VARCHAR2 (10) VARCHAR2 (20) VARCHAR2 VARCHAR2 VARCHAR2 NUMBER VARCHAR2 NUMBER NUMBER

PRIMARY NOT NULL NOT NULL

FIELD

DATA T YPE

DEPENDENCIES

Store_ID StoreName

NUMBER(5) VARCHAR2(50)

PRIMARY NOT NULL

FIELD

D ATA

DEPENDENCIES

Category_ID Category_name Store_ID

NUMBER(5) VARCHAR2(50) NUMBER(5)

TYPE

DEPENDENCIES

NOT NOT NOT NOT NOT

NULL

NOT

NULL

NULL NULL NULL NULL

Store Table

Category TYPE

PRIMARY NOT NULL FOREIGN KEY

28


Product Field

D ATA T YPE

DEPENDENCIES

Product_ID Category_ID Name Description Price Quantity

NUMBER(10) NUMBER(5) VARCHAR2 VARCHAR2 NUMBER NUMBER

PRIMARY K EY FOREIGN KEY NOT NULL

D ATA

DEPENDENCIES

NOT NOT

NULL NULL

Order Table Field Order_ID Contact_Name Delivery_Address Name Quantity Expiry Date Product ID Category ID Price Total_Amount

TYPE

NUMBER VARCHAR2(100) VARCHAR2 VARCHAR2 NUMBER DATE NUMBER NUMBER NUMBER NUMBER

PRIMARY NOT NULL NOT NULL NOT NULL NOT NULL

NOT NOT

NULL NULL

29


T ESTING

Testing is the filter to catch defects before they are “discovered” by the customer or end user. Every time a user runs the program, he/she generates a “Test-case”. We tried the test cases to find the defects first since software development is a human activity and there may be potential error. So testing before the product is delivered helped us to assure the quantity and saved resources. Objective of testing is to find errors, demonstrate the software functions that satisfy the specification, reduce the number of error detected by costumer, and have “confidence” in the software system. A good test always tries to discover undetected errors and is successful when errors are found since zero defects is not possible. There is always a condition or usage that can lead to an incorrect behavior. Using the test data following test run are carried out: 1) Unit test 2) System test

UNIT

TEST:

When the programs have been coded and compiled and brought to working conditions, they must be individually tested with the prepared test data. Any undesirable happening must be noted and debugged (error corrections).

S YSTEM TEST: After carrying out the unit test for each of the programs of the system and when errors are removed, then system test is done. At this stage the test is done on actual data. The complete system is executed on the actual data. At each stage of the execution, the results or output of the system is analyzed. During the result analysis, it may be found that the outputs are not matching the expected out of the system. In such case, the errors in the particular programs are identified and are fixed and further tested for the expected output.

30


LIMITATIONS OF PROJECT •

For “ONLINE SHOPPING S YSTEM” system must be web – based

•

The System requires persistent data.

•

The System can only be deployed on server operating system.

•

•

•

An IBM zSeries or equivalent or higher configuration server is required. The System uses HTTP 1.1 protocols. IE 6.0 or compatible browser is required to access the system.

31


T OOLS /PLATFORM AND L ANGUAGES USED  JAVA

DEVELOPMENT K IT ( JDK 1. 6.1)

Java Development Kit is used for producing Java programs. The JDK is developed by Sun Microsystems’s Java Soft division. The most recent versions include the JavaBeans component architecture and support for JDBC.  JAVA

SERVLET DEVELOPMENT K IT (JSDK 2.0)

The kit for developing Servlets, containing the Servlet API classes and tools, used to be called the Java Servlet Development Kit (JSDK). ServletRunner is a stand-alone Servlet Engine which implements the JSDK environment.  JAVABEANS

DEVELOPMENT K IT (BDK 1.1)

The JavaBeans Development Kit (BDK) is intended to support the development of JavaBeans components and to act as a standard reference base for both component developers and tool vendors. The BDK provides a reference Bean container, the "Bean Box" and a variety of reusable example source code (in the demo and bean box subdirectories) for use by both tool and beans developers.  JAVA

DATABASE CONNECTIVITY (JDBC)

Java Database Connectivity, a Java API that enables Java programs to execute SQL statements. This allows Java programs to interact with any SQL-compliant database. Since nearly all relational database management systems (DBMS) support SQL, and because Java itself runs on most platforms, JDBC makes it possible to write a single database application that can run on different platforms and interact with different DBMS.



WEB SERVER The Sun Java™ System Application Server Platform Edition 8 is a J2EE 1.4 platform compatible server for the development and deployment of J2EE applications and Java Web Services . The runtime portion of a J2EE product. A J2EE server provides EJB and Web containers.

32


ENTERPRISE JAVABEANS (EJB) CONTAINER 1) Manages the execution of enterprise beans for J2EE applications. Enterprise. 2) Beans and their container run on the J2EE server.



WEB CONTAINER It manages the execution of JSP page and servlet components for J2EE applications. Web components and their container run on the J2EE server.

J2EE Server and Containers  SOFTWARE

SPECIFICATIONS

1. OPERATING S YSTEM 2. ENVIRONMENT 3. FRONT -END 4. TECHNOLOGY 5. BACK -END

Windows 2000, NT, XP prof., Vista, Windows 7 Java Java HTML-Web Browser (Internet Explorer, Google chrome etc.) JSP, Servlets MySQL

33


H ARDWARE SPECIFICATIONS CLIENT SERVER Minimum Recommended

Processor

Recommend ed 850MHz

400MHz

1 GHZ

O.S

2000pro

Win9X

Win2000ServerEdition

Memory

1024Mb

256Mb

1Gb

Hard Disk

10.3Gb

4.3Gb

40Gb

Backup

Extra disk



hard Tape drive

Dat drive

DEVELOPMENT L ANGUAGES JAVA Java language was developed by Sun Microsystems in 1991. Java is a platform independent object oriented programming language. When you are writing programs, you always consider where this program is finally going to be executed. For instance, if the program is going to be executed on windows platform, you use the Microsoft Foundation Classes or if it is a Mac machine, then you use the Mac OS Toolbox. Also, while finally implementing the programs you insure that along with the source code the compiler has also been sent as every machine uses some or other kind of processor, and it becomes necessary to compile your program according to the destination machine’s processor. It would be virtually impossible to implement the applications on the internet, if we imagine the same scenario there because you don’t know where your program is finally going to be downloaded and run. In order to counteract this problem java has an inbuilt mechanism called JVM (Java Virtual Machine) which makes your application compatible to the client’s machine and your program can run on any machine on the internet. Java apart from being object oriented, and providing various features for the internet programming has many more features which makes it distinctively an appealing language.

1) Architecture Neutral 34

ONLINE SHOPPING SYSTEM 2) Robust 3) Reliable, Safe and Secure 4) Distributed 

HTML

Short for Hyper Text Markup Language, the authoring language used to create documents on the World Wide Web. HTML defines the structure and layout of a Web document by using a variety of tags and attributes. HTML is used to define the content and sketch of the page. It’s tags is used inside the codes of Java server pages(JSP) directly in this project. HTML is a client-side technology, it means an HTML document is processed entirely by the client or browser. Using HTML tag we can pass the parameters or query-string variables directly from one page of jsp to another page. Actually HTML is not a programming language, but it is used in jsp for all the above reasons.

 JAVA

SERVER PAGES (JSP)

Java Server Pages is a technology for developing web pages that include dynamic content. Unlike a plain HTML page, which contains static content that always remains the same, a JSP page can change its content based on any number of variables items, including the identity of the user, the user’s browser type, information provide by the user, and selection made by the user’s browser type, information provide by the user, and selection made by the user.

A JSP page contains standard markup language elements, such as html tags, just like a regular web page. However, a JSP page also contains special JSP elements that allow the server to insert dynamic content in the page. JSP elements are widely used for variety of purposes, such as retrieving information from a database or registering user preferences. When a user ask for a JSP page, the server executes the JSP elements merges the results with the static parts of the page, and sends the dynamically composed page back to the browser.  JAVA

DATABASE CONNECTIVITY (JDBC)

The JDBC API is composed of methods defined by a set of classes and interfaces that enables java applications to communicate with Database Management Systems (DBMS) or Relational Database Management systems (RDBMS). For this to happen the database should be installed on the computer and the RDBMS should provide a

35

ONLINE SHOPPING SYSTEM driver. JDBC classes and interfaces defined in the package “java.sql” constitute the JDBC API. The JDBC interface is a pure java API used to execute SQL statements. The JDBC provides a set of classes and interfaces that can be used by developers to write database applications. Basic JDBC interaction, in its simplest form, can be broken down into four steps: Open a connection to the database Execute a SQL statement Process the results • • • •

Close the connection to the database

ARE Y OU DOING T HIS PROJECT FOR ANY INDUSTRY

No this project is not for any industry or client.

36

Final Project Proposal

Recommend Documents