Iss Report (2)

8/6/2019 Iss Report (2)

http://slidepdf.com/reader/full/iss-report-2 1/35

1

PROJECT REPORT ON

SHOPPING CART

Information Systems and Security

Session 2010 – 2011

Submitted to: Submitted by:

Mrs. Sarita Dudi Alok Kumar(CSE071003)

Bhavana Kirodiwal (CSE071010)

Dinesh Fatehpuria (CSE071015)

Hina Verma (CSE071059)

DEPARTMENT OF COMPUTER SCIENCE

B.K. BIRLA INSTITUTE OF ENGINEERING &

TECHNOLOGY, PILANI (RAJ.)

(Affiliated to Rajasthan Technical University, Kota)

8/6/2019 Iss Report (2)


2

CONTENTS Page No.

1. Introduction……………………………………………………………..03

2. User Requirements Specification……………………………………….06

3. Software Requirements Specification…………………………………..06

4. Entity Relationship Diagram……………………………………………07

5. Use Case Diagram………………………………………………………09

6. Sequence Diagram………………………………………………………10

7. Activity Diagram…………..……………………………………………14

8. Data Flow Diagram……………………………………………………...15

9. Database Design………………………………………………………....18

10.Software Listing………………………………………………………..20

11. Application Snapshots………………………………………………….27

12. Acknowledgement……………………………………………………...33

13.Bibliography…………………………………………………………....34

8/6/2019 Iss Report (2)


3

INTRODUCTION

The project aims at creating an online shop “MYSHOP”. It basically provides shopping facility to its

customers who can register themselves. After registering they can login and purchase their

requirements. The customers are provided with the product list that contains the description,

availability and price. The items selected by each customer are piled into separate shopping carts.

Each customer can view their shopping expenses of all the products in their cart at any instant. The

payment can be made either by cash on delivery or through their credit accounts.

After you browse around you will see that the basic flow of our shop is :

• A customer visits the site

• The customer either registers as a new customer or login as existing customer

• customers browse the pages, clicking their way between product list

• View the product details that they found interesting

• Add products to shopping cart

• Checkout ( entering the shipping address, payment info )

• Leave ( hopefully to return another time )

The main features of the shop include the following:

• Flat shipping cost:

There are no shipping cost calculations.

• Payment mode:

o Cash on delivery

o Credit card

• Product details:

8/6/2019 Iss Report (2)


4

The shop includes the images of all the products with their descriptions.

• Case Statement

In this case, we will be designing a simple online shopping portal .The site will provide a

soothing shopping experience for customers. The system will allow more than one

categories and different brands under the segment. The case will trace the following

sequence.

• Scenario

A customer visits the online shopping portal. A customer may buy item or just visit the page

and logout. The customer can select a segment, then a category, and brand to get the

different products in the desired brand.

The customer can select the product for purchasing. The process can be repeated formore

items. Once the customer finishes selecting the product/sthe cart can be viewed , If the

customer wants to edit the final cart it can be done here.For final payment the customer has to login the portal, ifthe customer is visiting for the 1sttime he must register with the site, else the customer must use the login page to proceed.

Final cart is submitted for payment and card details and address(where shipment has to

bemade) are be confirmedby the customer .Customer is confirmed with a shipment

Idanddelivery of goods within 15 days.

• Assumptions

• The currency followed is Rs as the site provides for only Indian customer base.• There are different segments, categories, brands where a brand can fall under more

than one category.• The shipment of the goods is not covered under the scope of the case

• Actors

• Customer

• Administrator.

• Functionality

1. Portal

8/6/2019 Iss Report (2)


5

• Allows the customer to view the different categories and further to different

products within the brandseg.

• Allows the customer to shoponline saying time and cost of customer.

• The portal provides a bill and an shipmentId which can be used to track the

delivery status of the goods purchased by the customer ..

2. Customer

• Customers when enter the site and view the various products in different

category.

• Authentication ofthe customer is done for the payment of the shopping

done

• Customer can browses through the products available in the shop, can select

some of them and put into the shopping cart.

• Customer can anytime change the items in the cart either by adding new items or by

removing existing items. Customer proceeds towards the payment counter. Finalize

product list of items he finally wish to buy and make the final payment.

3. Administrator

• Updatesthe details of the different category ,segments etc

• Verifies the customer card details and records the details for shipment of goods

8/6/2019 Iss Report (2)


6

USER REQUIREMENTS SPECIFICATION (URS):

The user maybe a customer or an administrator. The customer maybe a layman with basic knowledge

about using internet. The administrator actually manages the database.

SOFTWARE REQUIREMENTS SPECIFICATION (SRS):

Back End:

MySQL:

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-

user access to a number of databases. It is named after developer Michael Widenius' daughter, My.

The SQL phrase stands for Structured Query Language.The MySQL development project has made

its source code available under the terms of the GNU General Public License, as well as under a

variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm,

the Swedish company MySQL AB, now owned by Oracle Corporation.

Free-software projects that require a full-featured database management system often use MySQL. For

commercial use, several paid editions are available, and offer additional functionality. Some free

software project examples: Joomla, WordPress, MyBB, phpBB, Drupal and other software built on

the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide

Web products, including Wikipedia, Google (though not for searches) and Facebook.

Front End

EasyPhp :

Launched in 1999, EasyPHP was the first WAMP software bundle available. EasyPHP installs web

server services onto the Windows computer and allows quick-and-easy development

of PHP and MySQL on local host (also known as 127.0.0.1). The package includes an Apache server,

a MySQL database, and the PHP extension. The package is deployable either on a PC or a USB drive.

The configuration is done automatically by the application with no interaction from the user. EasyPHP

is extended with modules (WordPress, Spip, Prestashop, Drupal, Joomla.). Modules are installed

automatically in the "modules" folder of

EasyPHP.EasyPHPversion :

EasyPHP 5.3.5.0 : PHP 5.3.5, Apache 2.2.17, MySQL 5.1.54, phpMyAdmin 3.3.9 and Xdebug 2.1.0

8/6/2019 Iss Report (2)


8/6/2019 Iss Report (2)


8

TERNARY RELATIONSHIP BETWEEN CUSTOMER-SHOPPING_CART-TRANSACTION

Customer Transacti

on_occur

s

transaction

cust_i

dCust_na

me

Cust_ad

dr passwo

rd

Cust_i

d

amou

nt

pd_id

date

Shopping cart

Pd_i

d

Cust_i

d

qty

8/6/2019 Iss Report (2)


9

USE CASE DIAGRAMS:

8/6/2019 Iss Report (2)


10

SEQUENCE DIAGRAM:

8/6/2019 Iss Report (2)


11

8/6/2019 Iss Report (2)


12

8/6/2019 Iss Report (2)


13

8/6/2019 Iss Report (2)


8/6/2019 Iss Report (2)


15

ACTIVITY DIAGRAM:

8/6/2019 Iss Report (2)


16

DATA FLOW DIAGRAM :

8/6/2019 Iss Report (2)


17

8/6/2019 Iss Report (2)


18

8/6/2019 Iss Report (2)


19

DATABASE DESIGN:

The database consists of four tables:

• Customer

• Products

• Shopping_cart

Customer:

This table consists of the records of all the customers. They contain their details such as customer

id(integer), name, address, contact details and password. Here each customer owns a unique

identification number i.e. cust_id that acts as the primary key of the table.On registration, a new record

is inserted to it , whereas any other changes can be made by the administrator only.

Products:

This table contains the details of the products available in the shop. It consists of a short description

about the product and other details like price and availability. New products maybe added and deleted

by the administrator. The table comprises of the following fields- product id(integer), product name,

price, quantity.

8/6/2019 Iss Report (2)


20

Shopping_cart:

The shopping cart holds the details of all the items selected by the customer from the product list along

with the quantity to be purchased. It consists of the product id, customer id and the quantity. It isautomatically updated every time the customer selects any product.

8/6/2019 Iss Report (2)


21

SOFTWARE LISTING:

• Front Page.html

<html>

<head><title>

myShop

</title>

<style type="text/css">

P{ margin-right:200px;

margin-left:200px}

.left{ background-image:url("gadgets47.jpg");

background-repeat:no-repeat;

background-position:right top;

margin-right:200px;

text-align:left}

.right{ text-align:right}

</style>

</head>

<body>

<center>

<img src="myshop.jpg"> </img>

<font size="4">

Welcome!<a href="login.html">sign in</a>

or

<a href="register.html">register</a>

<input type="text" name="search"/>&nbsp&nbsp

<input type="submit" value="search"/><br><br><br>

Shop location: shop no. 24 M.G. Road, Jaipur Rajasthan&nbsp&nbsp&nbsp&nbsp

Contact:+9154662299, +9146783289<br>

<img src="line.jpg">

</img><br><br>

</center><p class="left">

<font size="4" color="green">Features Of myShop</font> <br><br>

myshop is a place where the customers can purchase variety<br> of products

just sitting at their home.

You will find here <br>the most reasonable prices of every

item. Best discounts schemes<br> and time to time sales are brought up to

8/6/2019 Iss Report (2)


22

our customers by<br> myshop.

All you need to do is add the items to your cart and it<br> will be yours.

Our shop provides the best facilities by giving images<br> of products and

home delivery that too without any service charges.<br><br>

<font size="4" color="green">Products Available In myShop</font><br><br>

<table align= "left" cellpadding= 5 cellspacing=5>

<tr>

<td>

<a href="f.html">mobiles</a>

</td>

<td>

<a href="f.html">electronic gadgets</a>

</td>

</tr>

<tr>

<td>

<a href="f.html">computers</a>

</td>

<td>

<a href="f.html">laptops</a>

</td>

<tr>

<td>

<a href="f.html">television</a>

</td><td>

<a href="f.html">refrigerator</a>

</td>

</tr>

</table>

</font>

<marquee direction=right>

<img src="e_shop.jpg"></img>

</marquee>

</p>

<center>

<img src="sale.gif" align= center width=850 border=1>

</img>

</center>

</body>

</html>

8/6/2019 Iss Report (2)


23

• Login.html

<html>

<head>

<title>

myShop Login

</title>

<style type="text/css">

p{

margin-right:100px;

margin-left:100px}

.left{

margin-right:50px;

text-align:left}

.right{text-align:right}

</style></head>

<body>

<center>

<img src="myshop.jpg" alt="myshop">

</img>

Welcome!

<a href="myShop.html">HOME</a>

<input type="text" name="search"/>&nbsp&nbsp

<input type="submit" value="search"/><br><br>

Shop location: shop no. 24 M.G. Road, Jaipur Rajasthan&nbsp&nbsp&nbsp&nbsp Contact:

+9154662299, +9146783289<br>

<img src="line.jpg">

</img><br>

</center>

<p class="left">

<img src="sale.gif"></img>

<form action="login1.php" method="post" >

8/6/2019 Iss Report (2)


24

<p class="left">

<table cellspacing="3" cellpadding="5" width="100%" border="0">

<tr>

<td valign="top" style="text-align:right" bgcolor="#e8eefa">

<div>

<table align="center" border="0" cellpadding="1" cellspacing="0">

<tr>

<td colspan="2" align="center">

<font size="5">

Please enter your login details of

</font>

<table>

<tr>

<td >

<img src="myshop.jpg" alt="MyShop"> </img>

</td>

<td >

<font size="+0"><b>Account</b></font>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td colspan="2" align="center"></td>

</tr>

<tr>

<td>

<div align="right">

<span>

<font size=4><b>

Username:

</b></font>

</span>

</div>

</td>

<td>

<input type="text" name="username" size="18"/>

</td>

</tr>

8/6/2019 Iss Report (2)


25

<tr>

<td align="right">

<span>

<font size=4><b>

Password:

</b></font>

</span>

</td>

<td>

<input type="password" name="Passwd" size="18" />

</td>

</tr>

<tr>

<td> </td>

<td align="left">

</td>

</tr>

<tr >

<td align="right" valign="top">

<input type="checkbox" name="Cookie" id="Cookie" value="yes" />

</td>

<td>

<label>

<font size="4"> Keep me signed in</font>

</label></td>

</tr>

<tr>

<td>

</td>

<td align="left">

<input type="submit" name="signIn" value="Sign in" />

</td>

</tr>

<tr >

<td colspan="2" height="33.0" align="center" valign="bottom">

</td>

</tr>

</table>

</div>

8/6/2019 Iss Report (2)


26

</td>

</tr>

</table>

</div>

<br><br>

<table cellpadding=0 width=100% bgcolor=#e8eefa id=links>

<tr bgcolor=#e8eefa>

<td valign=top>

<div align=center style="margin:10 0">

<font size="4">New User! Register Yourself.</font><br>

<a href="register.php">REGISTER</a>

<br><br>

<font size="-1">

<a href="myShop.html">About MyShop</a

</font>

<br>

</div>

</td>

</tr>

</table>

</table>

</p>

</form></p>

</body>

</html>

8/6/2019 Iss Report (2)


27

• Login.php

<html>

<?php

session_start();

$con = mysql_connect("localhost","root","");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("shopping", $con);

$a=$_POST['username'];

$b=$_POST['Passwd'];

$_SESSION['cust_name']=$a;

$query = "SELECT cust_id,cust_name, password FROM customer ";

$query .= "WHERE cust_name='$a' AND password='$b'";

$result = mysql_query($query, $con);

if(mysql_num_rows($result)) {

while($row=mysql_fetch_array($result))

{

$cid=$row['cust_id'];

$_SESSION['cust_id']=$cid;

}

include("redirct_product.php");} else {

print("Sorry, this login is invalid.");

include("login.php");

}

?>

</html>

8/6/2019 Iss Report (2)


28

APPLICATION SNAPSHOTS:

8/6/2019 Iss Report (2)


29

8/6/2019 Iss Report (2)


30

8/6/2019 Iss Report (2)


31

8/6/2019 Iss Report (2)


32

8/6/2019 Iss Report (2)


33

8/6/2019 Iss Report (2)


34

ACKNOWLEDGEMENT:

We hereby thank Mrs. Sarita Dudi for providing with her esteemed guidance and great

logistic support without which we would have not completed the project successfully.

Special thanks to our respected director Dr. P. S. Bhatnagar who has given us full help

and support to undertake such a project.

8/6/2019 Iss Report (2)


35

BIBLIOGRAPHY:

• RDBMS

-Ramkrishnan Gehrke

• http://www.htmltutorial.com

• http://www.easyphp.com

http://www.htmltutorial.com/

http://www.easyphp.com/

http://www.htmltutorial.com/

http://www.easyphp.com/

Iss Report (2)

Documents

Transcript of Iss Report (2)