ONLINE JEWELLERY SHOPPING

PROJECT PRESENTATION ON
Submitted To
Department of Computer Science
Ganpat University, Kherva.
Submitted by
Nikul Patel (Exam No.13084231158)
Nitin Patel (Exam No.13084231162)
1
Project Profile
Project Title
Online Jewellery Shopping
Objective
A Jewellery Shopping is an web Application where the User can
register themselves and online Purchase Jewellery item main
Objective of this system is maintaining the Jewellery Products
online and also provide online payment facility to customer.
Type of Application Web Based Application
Front End Tool
ASP. Net with C# (.NET Framework 4.0)- 2010
Back End Tool
Microsoft SQL Server 2008
Other Tools
MS Office 2007 , Crystal report,photoshop,flash8.
Internal Guide
Komal H Patel
Submitted To
Department of computer Science, Ganpat University.
Developed By
1) Patel Nikul
2)Patel Nitin
Existing System
 As the current system is totally manual.
 Jewellery shop has a manual work on the paper.
 Existing system is manually, So it increase the chances of errors.
 Lots of the time consumed for each report generation.
 Immediate response to the query’s is difficult.
 More stationary use so they are expensive.
 Manual system are takes more time.
3
Need For New System
 System can ganerate immediately getting the data , and report.
 Avoid Stationary expense.
 New system provide online payment facility
 Any record is easy to store and manage.
Easy to solve customer query.
 Provide Better security in new system.
Give the feedback answer.
Easy to Jewellery purchase.
4
Functional Specification

Admin

Manage user and Admin Accounts.

Admin can Manage Jewellery For User Requirment.

Update Jewellery icon and design on site.

Send email and text message for new offer.

Admin can Generate bill.

Admin can View Feedback.

Admin Generate category wise report.
5

User

Search various Jewellery item.

User can View and Select Jewellery product

User can make purchase jewellery item.

User can select and Order Jewellery product.

Payment option by invoice, credit/debit card.

User can give the feedback.
6
Hardware & Software
Requirement
 Server Side
Minimum Hardware Requirements
Processor
2.0 GHz
Hard Disk
50 GB Free Space
RAM
2GB
Minimum Software Requirements
Operating System
Windows Server 2003
Web Server
IIS 6.0
Front-End Tool
ASP. Net with C# (.NET Framework 4.0) 2010
Back-End Tool
Microsoft SQL Server 2008
Other Tools
Adobe Photoshop 6.0, MS Office 2007 , Crystal
report,flash8.
7
 Client Side
Minimum Hardware Requirements
Processor
1.0 GHz
Hard Disk
2 GB Free Space
RAM
1GB
Minimum Software Requirements
Operating System
Windows XP or Any Compatible Operating System.
Web Browser
Internet Explorer 6.0 or Any Compatible Browser
8
System Flowchart
.
Start
If
Registered
No
Registration
Yes
No
Username/
Password
IS Valid
Yes
Yes
IS Admin
A
No
B
9
A
B
Manage User
search item
Product Manage/update
view/Select item
Send Email/Message
Purchase item
Calculate bill
Online Payment
View Feedback
Give feedback
Generate Report
logout
End
10
90 Days
Development
Phase
1 to 15
Days
16 to 30
Days
31 to 45
Days
46 to 60
Days
61 to 75
Days
76 to 90
Days
Duration
(Days)
Requirements
Gathering
1-15
(15days)
Analysis
16-40
(25days)
Design
31-70
(40days)
Coding
31-80
(50days)
Testing
50-85
(35days)
Implementation
&
Deployment
Documentation
Total Time
(Days)
76-90
(15days)
15-90
(75 days)
90days
ENTITY RELATIONSHIP
DIAGRAM
password
E-R Diagram
User_Id
Manage
M
1
View
User
M
M
1
1
Admin_Id
M
M
1
Password
Pay
M
Gives
Search
Gives
M
Search
Jewellery
Order
Payment
View
M
Order_id
name
User_Id
Belongs
to
Product name
M
M
Name
Feedback
M
Product_id
product
M
Feedback_Id
Product Name
manage
manage
Admin
1 1 1
USE CASE DIAGRAM
Admin
Login
User manage
Product Manage
Send Email / Message
Admin
Calculate Bill
View Feedback
Generate Report
 User
Registration
Login
Search Item
Select Item
Purchase Item
Online Payment
User
Email / Message
Give Feedback
Logout
Activity Diagram
Admin
.
Login
Invalid
Valid
.
Product
manage
.
Send
mail/message
.
calculateBill
.
Logout
.
View Feedback
.
GenerateReport
 User
.
Registration
Invalid
Registration
Valid
.
Login
Invalid
Valid
.
Search
item
.
View/select
item
Purchase
item
.
Logout
.
Online
payment
.
Give feedback
CLASS DIAGRAM
Admin
SEQUENCE DIAGRAM
A:Admin
S:System
Login
Successfully Login
Update Profile
Response Profile
Db:Database
Request for Login
Response for Login
Manage Profile
Update Profile
Update Jewellery Detail
Manage Jewellery Detail
Successfully Detail Update
Update Jewellery Detail
Manage User
Update User
Successfully Update User
Send Email/Message
Successfully send Email/Message
Generate Reports
Generate Reports detail
Logout
Logout Successfully
Update User
Request for Email/Message
Response Email/Message
Request for Reports
Returns Request data
 User
U:User
Db:Database
S:System
Registration
Successfully registration
Login
Successfully Login
Add Profile
Response Profile
Search Jewellery item
Response Jewellary
item
Purchase Jewellery
Response Jewellery Parchage
Online Payment
Response for Payment
Giva Feedback
Response Feedback
Logout
Logout Successfully
Request for Registration
Response for Registration
Request for Login
Response for Login
Manage Profile
Update Profile
Search Jewellery item
Update Jewellary item
Request for Jewellery Purchase
Response for Jewellery
Manage Payment
Update Payment Detail
Request Feedback
Response for Feedback
COLLABORATION DIAGRAM
 Admin
1:1:Request for Login
2:1:Manage Profile
3:1:Request Jewellery Detail
4:1:Manage User
5:1:Request for
Email/Message
6:1:Request for Reports
S:System
1:Login
2:Update Profile
3:Update Jewellery
Detail
4:Update User
5:Send
Email/Message
6:Ganarate Report
7:Logout
Db:Database
1:1:1:Response for Login
2:1:1:Update Profile
3:1:1:Update Jewellery Detail
1:1:1:1:Login Successfully
4:1:1:Update User
2:1:1:1:Response Profile
5:1:1:Response
3:1:1:1:Successfully Jewellery Detail Email/Message
update
6:1:1:Returns Request Data
4:1:1:1:Successfully Update User
5:1:1:1:Successfuuly Send
Email/Message
6:1:1:1:Generate Reports
7:1:Logout Successfully
A:Admin
User
1:1:Request for Registration
2:1:Request for Login
3:1:Manage Profile
4:1:Search Jewellery item
5:1:Request for Jewellery
Purchase
6:1:manage Payment
7:1:Request Feedback
S:System
1:Registration
2:Login
3:Add Profile
4:Search Jewellery Item
5:Purchase Jewellery
6:Online Payment
7:Give Feedback
8:Logout
1:1:1:1:Registration Successfully
2:1:1:1:Login Successfully
3:1:1:1:Response Profile
4:1:1:1:Response Jewellery item
5:1:1:1:Response Jewellery Purchage
6:1:1:1:Response For Payment
7:1:1:1:Reponse Feedback
8:1:Logout Successfully
U:User
Db:Database
1:1:1:Response for Registration
2:1:1:Response for Login
3:1:1:Update Profile
4:1:1:Update Jewellery item
5:1:1:Response for Jewellery
6:1:1:Update Payment Detail
7:1:1:Response for Feedback
data dictionary
ADMIN LOGIN
•Table name :- Admin login
•Description :- Table is use to store admin login information
•Primary key :- User_Name
Sr.No
Fields Name
Data Type
Size
Constraints
1
User_name
Varchar
30
Primary key
2
Password
Varchar
20
Not Null
Description
It is Store Admin name
It is Store Admin password
REGISTRATION
•Table name :- Registration
•Description :- Table is use to store registration information
•Primary key :- User _id
• Foreign Key:- City, State, Country
Sr.No Fields Name
1
User_id
2
First_name
Data Type Size
Int
25
Varchar
30
Constraints
Primary key
Not Null
Description
It is Store Unique user id
It is Store Firstname of User
3
4
5
6
7
8
9
10
11
12
13
14
15
Last_name
User_name
Password
Email
Gender
Date-Of-Birth
Address
City
Pincode
State
Country
Mobile_number
Security_question
Varchar
Varchar
Varchar
Varchar
Varchar
Datetime
Varchar
Varchar
Int
Varchar
Varchar
Int
Varchar
20
30
20
20
6
MAX
30
6
30
20
12
MAX
Not Null
Unique Id
Not Null
Not Null
Not Null
Not Null
Not Null
Foreign Key
Not Null
Foreign Key
Foreign Key
Not Null
Not Null
It is Store Lastname of User
It is Store Choose Username
It is Store Choose Password
It is Store Emailid of user
It is Store Gender of user
It is Store Birthdate of User
It is Store Address of user
Referance from City Table
It is Store Pincode of user
Referance from State Table
Referance from Country Table
It is Store Mobile no of user
It is Store Select security question
16
Security_answer
Varchar
MAX
Not Null
It is Store Select security answer
PRODUCT_MASTER
•Table Name: Product _Master
•Description: Table is use to store Product information
•Primary Key: Product_id
•Foreign Key: Category_id
Sr.No
Fields Name
Data Type
Size
Constraints
Description
1
Product_id
Int
10
Primary Key It is Store Unique Productid
2
Category_id
Int
20
Foreign Key Referance from Category Table
3
Product_name
Varchar
30
Not Null
It is Store Name of Product
4
Product_material
Varchar
20
Not Null
It is Store Material of Product
5
Product_Price
Varchar
20
Not Null
It is Store Price of Product
6
Product_carat
Varchar
20
Not Null
It is Store Carat of Product
7
Product_image
Varchar
50
Not Null
It is Store Image of Product Path
8
Product_detail
Varchar
MAX
Not Null
It is Store Detail of Product
9
Product_weight
Decimal
5,2
Not Null
It is Store Weight of Product
ORDER
•Table Name: Order
•Description: Table is use to store user oder information
•Primary Key: Order_id
•Foreign Key: Product_id
Sr.No
Fields Name
1
Order_id
2
Data Type
Size
Constraints
Description
Int
10
Primary Key It is Store Unique Order id
User_id
Int
10
Foreign Key Referance from Registration Table
3
Product_Id
Int
10
Foreign Key Referance from Product Table
4
Order_No
Int
20
Not Null
It is Store order no
5
Quantity
Int
5
Not Null
It is Store Quantity of Product
6
Servicetax
Decimal
5,2
Not Null
It is Store Servicetax of Product
7
Netprise
Decimal
5,2
Not Null
It is Store netprise of Product
PAYMENT_MASTER
•Table Description: Payment_master
•Description: table is use store payment information
•Primary Key: Bill_id
•Foreign Key: User_id
Sr.No
Fields Name
Data Type
Size
Constraints
Description
1
Payment_Id
Int
10
Primary Key
It is Store Unique id
2
User_id
Varchar
50
Foreign Key
Referance from User Table
3
Address
Varchar
50
Not Null
It is Store Address of User
4
Subject
Varchar
50
Not Null
It is Store Subject of User
5
CardNo
Int
14
Not Null
6
Amount
Decimal
5,2
Not Null
It is Store the Credit Card
Number
It is Store the Payment Amount
7
Message
Varchar
50
Not Null
It is Store Massage
CATEGORY_INFO
•Table Name: Category_Info
•Description: table is use to store Category information
•Primary Key: Category_id
Sr.No
Fields Name
Data Type
Size
Constraints
Description
1
Category_id
int
10
Primary key
It is Store category id
2
Category name
Varchar
20
Not Null
It is Store category name
29
COUNTRY_INFO
•Table Name: Country_info
•Description: table is use to store Country information
•Primary key: Country_id
Sr.No
Fields Name
Data Type
Size
Constraint Description
s
1
Country_id
Int
10
Primary key It is Store the country id
2
Country_name
Varchar
20
Not Null
It is Store the country name
30
STATE_INFO
•Table Name: State
•Description: table is use to store state information
•Primary Key: State_id
•Foreign Key: Contry_id
Sr.No Fields Name Data Type
Size
Constraints
Description
1
State_id
Int
10
Primary key
It is Store the state id
2
State_name
Varchar
20
Not Null
It is Store the state name
3
Country_id
Int
11
Foreign key
Referance from Contry Table
31
CITY_INFO
•Description: table is use to store City information
•Table Name: City
•Primary key: City_id
•Foreign Key: State_id
Sr.No
Fields Name Data Type
Size
Constraints
Description
1
City_id
Int
11
Primary key
2
City_Name
Varchar
20
Not Null
It represent the city name
3
State_id
Int
11
Foreign key
It represent the state name
It represent the city id
32
FEEDBACK
•Table name :- Feedback
•Description :- table is use to store User Feedback information
•Primary key :- customer _id
•Foreign Key: User_id
Sr.No
Fields Name
Data Type
Size
Constraints
Description
1
Feedback_id
Int
10
Primary key
It is Store Unique Clientid
2
User_id
Int
10
Foreign Key
Referance from User Table
3
Comment
Varchar
60
Not Null
It is Store Comment of Client
INPUT DESIGN
HOME
Description:-This is a Home page for all User.
34
ADMIN_LOGIN
Description:-Admin can login here.
35
FORGET PASSWORD
Description:-Send a temporary password to through email.
36
CHANGE PASSWORD
Description:-user can change password.
37
MANAGE USER
Description:-Admin can manage user account.
PRODUCT_MANAGE
Description:-Admin can manage product.
PRODUCT_MANAGE
Description:-Admin can manage product
UPDATE_PRODUCT
Description:-Admin can update product.
SEND E-MAIL
Description:-Admin can send mail to user.
REGISTRATION
Description:-User can Ragistration.
USER_LOGIN
Description:- User can login if register.
SEARCH ITEM
Description:-User can search item.
VIEW PRODUCT
Description:-User can view product in this page.
PROUDUCT DETAIL
Description:-User can view product detail.
PERSONAL PRODUCT DETAIL
Description:-User can view personal product detail
PURCHASE ITEM
Description:-User can purchase item.
PAYMENT INQURY
Description:-User can pay payment online.
FEEDBACK
Description:-User can give Feedback.
CONTACT US
Description:-User can view contact detail
ABOUT US
Description:-User can view detail about page.
OUTPUT DESIGN
PAYMENT DETAIL
Description:-view payment detail.
54
BILL REPORT
Description:-view bill report detail.
ORDER REPORT
Description:-view order report detail.
ORDER_DETAIL
Description:-view order detail.
TESTING
No
Test Case
Case Type
Excepted Output
1.
Admin Login
1.Enter correct Login to the system should
Username
be try with the login
and Password assigned by the admin and
the correct password
Actual Output
Pass / Fail
Login should be Pass
successful and the
user should enter
into the system
2.Enter wrong The System give an error Login should fail Pass
Username or and denied from the Login. with
an
error
password
‘Invalid Details’
2.
User Login
1.Enter correct Login should be allow and Login successfully Pass
Username and user access the application. and user access the
Password
application.
2.Enter wrong The System give an error Login should fail Pass
Username or and denied from the Login. with
an
error
password
‘Invalid Details’
3.
Validation Test Requir_Field
cases
validation
Regular format must be System give error to Pass
required in control
enter valid input
58
4
Admin
Roll
1.Admin
access
Admin can View data Admin manage all information Pass
and all the information of the system.
of the site.
5.
User Roll
1.User
Registration
User can register the Admin Confirm registration.
Site.
Pass
2.Manage
Profile
User can
Profile.
Pass
3. Payment
User can pay a Purchase Appropriate Product. Pass
Payment
for
Purchasing a Product.
4. Feedback
User can
Feedback.
manage Edit Information.
give
a Give appropriate Message.
Pass
59
POST IMPLEMENTATION REVIEW
•Post implementation review is conducted by Users and Analyst.
•To determine whether the system has met its objective, that is analysts, want to know if the
performance level of Users has improved. If nothing is happening, one may question
whether the system can be considered successful.
• To evaluate the system, following questions are considered:
How have the system changed the way in which operations are performed?
How have system changed the completeness of the information?
How have system changed the number of user?
How have system changed the interaction between users?
FUTURE ENHANCEMENT
In the future I want to Enhanced my project with thee admin part of online jewellery shopping.
Add more jewellery types in web-site.
Try to all user contect with phone call.
Add more features in site future.
BIBLIOGRAPHY
 Books:1.ASP.NET With C#.
Author:-ShyamN.Chavda.
2.The Complete Reference C# 3.0
Author:- Herbert schildt
3.GeorgeShepherd@Microsoft ASP.NET 4 Step by step
Author:- George Shepherd
 Websites:www.shine.com
www.tbz.com
www.code-project.com
www.jaweryandco.com
www.tutorialpoint.com
63