MOBILE SHOP MANAGEMENT SYSTEM

A Project Report

Submitted in partial fulfillment of the

Requirements for the award of the Degree of

BACHELOR OF SCIENCE (INFORMATION TECHNOLOGY)

By
SHRADDHA VIJAYKUMAR DHEPSE
Seat Number :-…………

Under the esteemed guidance of

Mr. Varunraj S. Pandit.
Assistant Professor at Information Technology Department

of Gogate Jogalekar College, Ratnagiri

DEPARTMENT OF INFORMATION TECHNOLOGY

GOGATE JOGALEKAR COLLEGE, RATNAGIRI

(Affiliated to University of Mumbai)

RATNAGIRI, 415612

MAHARASHTRA
2022-2023
 PROJECT PROPOSAL
PNR No: Roll No.TTA-38

1. Name of the Student: Shraddha Vijaykumar Dhepse.

2.Title of the project: Mobile Shop Management System

3.Name of the Guide : Mr. Varunraj S. Pandit.

4.Teaching experience of the guide 10 years

5. Is this your first submission? Yes

Signature of the Student Signature of the Guide

Date: Date:

……………………….

Signature of the Coordinator

Date:
 GOGATE JOGALEKAR COLLEGE, RATNAGIRI

(Affiliated to University of Mumbai)

RATNAGIRI-MAHARASHTRA-415612

DEPARTMENT OF INFORMATION TECHNOLOGY

This is to certify that the project entitled, "Mobile Shop Management System", is bonafide
work of Mrs. Shraddha Vijaykumar Dhepse bearing Seat. No: submitted in
partial fulfillment of the requirements for the award of degree of BACHELOR OF SCIENCE
in INFORMATION TECHNOLOGY from University of Mumbai.

Internal Guide HOD/Coordinator

External Examiner
Date: College seal
 DECLARATION

I hereby declare that the project entitled, “Mobile Shop Management System” done
at Gogate Jogalekar College, Ratnagiri, has not been in any case duplicated to submit to
any other university for the award of any degree. To the best of my knowledge other than me,
no one has submitted to any other university.

The project is done in partial fulfillment of the requirements for the award of degree
of BACHELOR OF SCIENCE (INFORMATION TECHNOLOGY) to be
submitted as final semester project as part of our curriculum.

Mrs .Shraddha Vijaykumar Dhepse

 ABSTRACT
The title of project is “Mobile Shop Management System”. It will help to organize
mobile shop data in very systematic way. This application will reduce the possible errors
while entering the data. No formal knowledge is needed for the user to use this system.
Mobile Shop Management System, as described above can lead to error free, secure, reliable,
and fast management system.

I used ASP.NET as front end with Visual Basic.NET and back end is MS SQL server.
In this project there are several different forms such as login page, stock, purchase, sale,
report.

So, this project will efficirntly manage the all data. Also, it consumes less time
consumption. The main and important benefit of this system is that it is very much user
friendly and accurate. So the user fell so much comfortable to work with it.
 ACKNOWLEDGEMENT

I would like to express my sincere gratitude to everyone for supporting me throughout

my project. First, I wish to express my sincere gratitude to my guide Mr .Varunraj pandit sir
for his enthusiasm, patience, Insightful comments, helpful comments and information,
practical advice and unceasing ideas that have helped me tremendously at all times. His
immense knowledge, profound experience has enabled me to compete this project
successfully. without his support and guidance. This project would not have been possible.

I also wish to express my sincere thanks to HOD of the Department of Information

Technology Mrs. Medha Sahsrabuddhe , Vice Principal Dr. Vivek Bhide and Principal of
GJC Mr. P.P.Kulkarni for their support and the facilities they have made available. I am also
grateful to the staff of department of information technology for their consistent support and
assistance.

I also wish to express my sincere thanks to our college for their support and for the
facilities they have made available. Thanks all for your encouragement. This project has been
a wonderful experience where we have learnt and experienced many beneficial things
Sr. No. Content Page No.
1 Introduction
1.1 Background
1.2 Objectives
1.3 Purpose, Scope and Applicability
1.3.1 Purpose
1.3.2 Scope
1.3.3 Applicability
2 System Analysis
2.1 Existing System
2.2 Proposed System
2.3 Requirement Analysis
2.3.1 Software Requirement
2.3.2 Hardware Requirement
2.4 Planning and Scheduling-Gantt Chart
3 System Design
3.1 Modules
3.2 Database
3.3 Figures
3.4 User Interface Design
3.5 Test Cases Design
Sr. No. Figure Name Page No.

E
1 -R Diagram

2 Activity Diagram

3 Sequence Diagram

4 Use-Case Diagram

5 Class Diagram
 INTRODUCTION

1.1 Background:

The mobile shop management system is developed for desktop system to facilitate
mobile shop owners management of customer details and inventory data which we include
mobile phones and accessories.

This software will provide in a simple and easy to operate user interface which can be
managed by any user without having prior in depth knowledge of the computer system.

Mobile shop management system is application software designed to take advantage of

todays technology and reduce or avoid the burden of storing data on paper and files.

1.2 Objectives:

1.The main intension of this system is to reduce the manual work.

2.This system will help to manage and access data faster than older system, so it will
save a lot of time.
3.The main objective of the mobile shop management system is to manage details of
stock, purchase, sale.
4.Easy to generate and print bill.
1.3 Purpose, Scope, and Applicability

1.3.1Purpose:

The purpose is to build an easy, user friendly system that will reduce the effort of
manual data collection.
This will allow the admin to collect and store the data.

1.3.2 Scope:

Admin stores all information of the mobiles

This software is specifically designed for the owner of the shop.
Admin can provide a print of bill to the customer through this software.
Purchase bill and sale bill report will be managed through this system.

1.3.3 Applicability:

By using this system admin can easily handle data and work is completed with less time.

As this system maintains the backup hence this is more secured so we can store the data
with the help of backup system. This system is userfriendly.
 2.System Analysis
2.1 Existing System :

In the existing system details are maintained manually. Due to this the data retrieved is
the time consuming.
Difficulty in managing data
Lack of security

Limitations of existing system:

 Speed of process is very low
 Wastage of paper and manpower
 Offline data handling is quite difficult and time consuming .

2.2 Proposed System:

The current system will be automated and userfriendly.
It will maintain data security
It provide quick access to any data. This reduces the workload of user and it is also a
time saving process.
By maintaining all the work on computer will increase our accuracy as well as speed of
our work.

Advantages of proposed system:

 All the information about sale, purchase, stock will be maintain properly in this
system.
 It is user friendly and easy to handle.
 Save a lot of time and effort.
 Accuracy and security can be maintained easily.
 2.3. Requirement and System Analysis

Hardware Requirements:

Processor =Intel dual core and above

RAM = 4 GB or +

Display= 800x600,256 color (minimum)

Printer

Mouse or compatible pointing device

Software Requirement:

Operating System= Window 8/9/11

Back End= MSSQL ,C#

Font End= HTML, CSS, bootstrap, java script

Tool =visual studio

2.4 Planning And Scheduling – Gantt Chart
 3.System Design
3.1 Modules

Module 1: Login

Admin will login through this module and Admin will get facilities to change his details
through this method.

Module 2: Stock

Stock module is used to manage the stock. The admin will have authority to add, delete, edit
the information.

Module 3: Purchase

In this module, admin purchases the product from vendor.

Module 4: Sale

It has been developed for managing the sales. If you want to print the bill then print
functionality has been implemented.

Module 5: Report

This section contains all the reports from the system.

 3.2 DATABASE
Table: Login

Column Name Type Constraints Description

Username varchar(50) Not null Add username
Password varchar(50) Not null Add password

Table: Stock

Column Name Type Constraints Description

Stock_ID Numeric Not null Create unique ID
Model_name varchar(50) Not null Name of the Model
RAM INT Not null Specifies RAM configuration for
specific smartphone model
ROM INT Not null Specifies ROM configuration for
specific smartphone model
Colour varchar(50) Not null Colour of the model
Size FLOAT Not null Specify physical dimension of
model
Stock_price FLOAT Not null Price of the model
Stock_quantity INT Not null Quantity of the model
Table : Purchase

Column Name Type Constraints Description

Purchase_ID Numeric Not null Create unique ID
Purchase_date Date Not null Model added date
Purchase_quantit INT Not null Quantity of the model
y
Model_name varchar(50) Not null Name of the model
RAM INT Not null Specifies RAM configuration for
specific smartphone model
ROM INT Not null Specifies ROM configuration for
specific smartphone model
Colour varchar(50) Not null Colour of the model
Size FLOAT Not null Specify physical dimension of
model
Purchase_price FLOAT Not null Price of the model
Vendor_name varchar(50) Not null Name of the vendor
Vendor_phnno varchar(50) Not null Phone number of the vendor

Table : Sale

Column Name Type Constraints Description

Sale_ID Numeric Not null Create unique ID
Customer_name varchar(50) Not null Name of the customer
Sale_date Date Not null Model sale date
Sale_price FLOAT Not null Price of the model
Model_name varchar(50) Not null Name of the model
Sale_Quantity INT Not null Quantity of the model
 3.3 Figures
1.E-R Diagram:
2. Activity Diagram:
3. Sequence Diagram:

4. Use-Case Diagram
5. Class Diagram:
Conclusion
It has been a great pleasure for us to work on this exciting and challenging project.
This project proved good for us as it provided us knowledge of not only programming
language of ASP.NET but also about all the handling procedures related to “Mobile
shop management system”.

This is user friendly since it has been developed in visual studio successful GUI
environment. since the connection can be extended to any database. The control will
be more powerful.

This project was really a wonderful learning experience for me and I enjoyed each
and every phase of work.
We have tried our best to make the system a lot more easier for user and we hope that
they won’t face any difficulties while using the application.