You're not going to master the rest of your life in one day. Just relax. Master the day. Than just keep
Idea Transcript
AMPICS LIBRARY
A Project Report On Mobile Store Management System
Submitted to Acharya Motibhai Patel Institute of Computer Studies Ganpat Vidyanagar- 384012 Developed By Guided By Patel Jignesh M. [Exam No. 11032211156] Patel Kishan V. [Exam No. 11032211171]
Mrs. Asha K. Patel
Group No. C-20 BCA Semester – VI
Page 1 of 61
1
Project Profile AMPICS LIBRARY
Project Title
Mobile Store Management System
Project for
City Gold Mobile Shop
Project Objective
The main aim of this system is to keep All the records like purchase,sales,stock through our software.
Application
Windows Application
Front End Tool
Microsoft Visual Studio 2010 ( VB.NET)
Back End Tool
Microsoft Sql Express Edition Server 2008
Project Co-ordinator
Mrs. Asha K. Patel
Project Guide
Mrs. Asha K. Patel
Group No.
C-20
Developed By
Patel Jignesh M. Patel Kishan V.
Submitted To
Acharya Motibhai Patel Institute of Computer Studies Ganpat Vidyanagar-384012 Page 2 of 61 2
AMPICS LIBRARY
About Organization
Name :-
City Gold Mobile Shop
Owner :-
Mr. Vishnu Patel
Object:-
The main aim of this system is to keep All the records like purchase,sales,stock through our software. This is very helpful to manage all the product detail and basic detail.
Description :-
City Gold Mobile Shop was started in 2000, it has start at that time. Mr. Vishnu Patel is the owner of City Gold Mobile Shop.
Product :-
Mobiles
Address :-
48/Appollo Enclave Modhera Char Rasta ,Mehsana
Mobile No. :-
9998569593
Page 3 of 61
3
AMPICS LIBRARY
Existing System In existing system there will be not any type facilities which are easy for work in our Shop. Existing System provider : The existing System required more time for processing. The process is very slow and lengthy. Not any type of security is provide so it may lost data.
Difficult serch the pervious data. More men power is required.
Page 4 of 61
4
AMPICS LIBRARY
Need For The New System
The Shop want to developed application for making their system secure and easy to use for all the employee.
Need for New System : The important result is to make the work easier, faster and time consuming. Any change in information can be easy done and all files are automatically updated. System security and authorization. The system is user friendly and any one having computer knowledge can handle it easily. Searching facility as well as generation of report like customer,bill,stock and salling became easy. Page 5 of 61
5
AMPICS LIBRARY
Hardware And Software Requirement (Recommended) Hardware Requirement :RAM
512 MB
Required Space
200 MB
Printer
laser printer(Any type of printers)
Processor
Core i5 & above
Software Requirement :-
Operating System
Window XP and Above
Front End Tool
. NET Framework 4.0 Microsoft Visual Studio 2010
Back End Tool
Microsoft Sql Server 2008 Page 6 of 61
6
AMPICS LIBRARY
Page 7 of 61
7
START AMPICS LIBRARY
ID & PASSWORD
CHECK AUTHETICATION?
NO
YES
STOCK AVAILABLE
CHECK STOCK
STOCK NOT AVAILABLE
SALES
PURCHAGES
GIVE BILL
RECEIVE BILL
RECEIVE PAYMENT
GIVE PAYMENT UPDATE STOCK
REPORT Page 8 of 61
STOP
8
AMPICS LIBRARY
CONTEXT LEVEL DFD
Request for Mobile info
Customer Mobile Info.
0.0 Mobile Store Management System
Acknowledge info
Give Order info
Supplier Request for Order
Mange stock,order,supplier and customer info
Admin Page 9 of 61
9
FIRST LEVEL DFD AMPICS LIBRARY
UID & P/W info
Admin
Check UID & P/W
1.0 Login
LOGIN_MST Verify login
Verify info Purchase & Supplier
Supplier Invoice info
Stock vrify info
User info
2.0 Purchase
Payment info
Verify info
Supplier info Update stock Purchase info
3.0 Stocks
ITEAM_MST SUPPLIER_MST
Stock inq.
STOCK_MST Stock veryfy info
Stock info
Customer
PURCHASE_MST
New & exiting item
Stock inqiry
Item info
Purchase info
4.0 Sales
Update stock Sales info Customer info
SALES_MST CUSTOMER_MST
Sales info Genrate report info
5.0 Genrate report
Report info
Report Page 10 of 61
10
AMPICS LIBRARY
Stock info
Inq. For Stock info
2.1 Check Quantity
Verify Stock info
STOCK_MST Stock info verify
Stock info Supplier info Supplier info
Verify Supplier info
2.2 Identify Supplier
SUPPPLIER_MST Verify Supplier info Availability of Stock
Supplier info
Admin
Availability of Stock
Verify Stock info
2.3 Decide Quantity Item
Delivery Item & Payment info
Stock Verify info Purchase info
Update Stock Item info
Req. Purchase Order
STOCK_MST
2.4 Purchase Return Order
PURCHASE_MST STOCK_MST
Purchase Oder info
SUPPLIER_MST Require info Purchase info Purchase info
PURCHASE_RETN_MST Page 11 of 61
11
AMPICS LIBRARY
Verify Order info Req. for Order info
Customer
Customer info
Giving Bill info Payment info
Return Item info
Admin
4.1 Place Order
Order info STOCK_MST Verify Order info
Stock Verify info Update Stock info Order Item info 4.2 SALES_MST Selling Customer info CUSTOMER_MST Sales info Bill info BILL_MST 4.3 Bill Detail Billing Payment info PAYMENT_MST Sales Payment info Return Item info SALES_RETU_MST 4.4 Sales Return
Sales Retn Info Generate Report info 4.5 Report
Match Invoice
Update Stock Report info
SALES_MST STOCK_MST
Report Page 12 of 61 12
AMPICS LIBRARY
Page 13 of 61
13
AMPICS LIBRARY
LOGIN_MST Field Name
Data Type
Size
Constraint
Description
User Name
Varchar
10
Primary key
User Name
Password
Varchar
10
Not Null
Password
Page 14 of 61
14
AMPICS LIBRARY
SUPPLIER_MST Field Name
Data Type
Size
Constraint
Description
Sup_No
Numeric
4
Primary key
Supplier Number
Sup_Name
Varchar
20
Not null
Supplier Name
Sup_Address
Varchar
100
Not null
Supplier Address
City
Varchar
20
Not null
City
Mobile
Numeric
10
Not null
Mobile Number Page 15 of 61
15
AMPICS LIBRARY
ITEM_MST Field Name
Data Type
Size
Constraint
Description
It_No
Numeric
4
Primary Key
Item Number
It_Name
Varchar
20
Not Null
Item Name
It_company
Varchar
20
Not Null
Company Name
Total_Price
Numeric
6
Not Null
Total Price
Page 16 of 61
16
AMPICS LIBRARY
CUSTOMER_MST Field Name
Data Type
Size
Constraint
Description
C_No
Numeric
4
Primery key
Customer Number
C_Name
Varchar
20
Not null
Customer Name
C_Address
Varchar
100
Not null
Customer Address
City
Varchar
10
Not null
City
Mobile
Numeric
10
Not null
Mobile Number
Page 17 of 61
17
AMPICS LIBRARY
PURCHASE_MST Field name
Data type
Size
Constraint
Description
P_No
Numeric
4
Primery key
Purchase Number
Sup_No
Numeric
4
Forign key
Supplier Number
Quantity
Numeric
6
Not Null
Quantity
P_Date
Date
Not null
Purchase date
-
Page 18 of 61
18
AMPICS LIBRARY
PURCHASE_RETN_MST Field name
Data type
Size
Constraint
Description
Pur_No
Numeric
4
Primary key
Purchase return Number
P_No
Numeric
4
Foreign key
Purchase Number
Sup_No
Numeric
4
Foreign key
Supplier Number
Quantity
Numeric
6
Not unll
Quantity
Pur_Date
Date
-
Not null
Purchase return date Page 19 of 61
19
AMPICS LIBRARY
STOCK_DETAIL Field name
Datatype
Size
Constraint
Description
It_No
Numeric
4
Foreign key
Item Number
Quantity
Numeric
6
Not null
Item Quantity
Page 20 of 61
20
AMPICS LIBRARY
SALES_MST Field Name Data Type
Size
Constraint
Description
S_No
Numeric
4
Primary key
Sales Number
It_No
Numeric
4
Foreign Key
Item Number
S_Date
Date
-
Not null
Sales Date
Page 21 of 61
21
AMPICS LIBRARY
SALES_RETN_MST Field name
Datatype
Size
Constraint
Description
Sr_No
Numeric
4
Primary key
Sales return Number
S_No
Numeric
4
Foreign key
Sales Number
It_No
Numeric
4
Foreign key
item Number
C_No
Numeric
4
Foreign key
Customer Number
Quantity
Numeric
6
Not null
Quantity
Sr_Date
Date
-
Not null
Sales return date Page 22 of 61
22
AMPICS LIBRARY
BILL_MST Field name
Date type
Size
Constraint
Description
Bill_No
Numeric
4
Primary key
Bill Number
C_No
Numeric
4
Foreign key
Customer Number
S_No
Numeric
4
Foreign key
Sales Number
Page 23 of 61
23
AMPICS LIBRARY
Page 24 of 61
24
AMPICS LIBRARY
S-no
M
GENERATE User-Id
BILL
1
password bilno
C_no
1 1
ADMIN
1
1
GET
MANAGE MANAGE
C_no
M
MANAGE
C_Name
CUSTOMER 1 1
S_Name
S_no
Item name
M SUPPLIER 1 SUPPLY
Item Company Item no
M
M ITEM
M
PURCHASE Page 25 of 61
25
Process Algorithm AMPICS LIBRARY
Step1. Start Step:2. Enter Username and password. If they are valid then go to next step otherwise it take username and password again. Step:3. Admin Checks the stock, if it does not available then item is purchased in purchase process and stock is Updated. Step:4. If stock is already available then items are sold and stock is updated. Also bill is generated and is given to the customer. Step:5. Admin checks the purchased items, if any problem is there then item is returned and stock is updated. Step:6. Customer checks the sale items, if it is not proper then item is returned and stock is updated. Step:7.
Exit Page 26 of 61
26
AMPICS LIBRARY
Process Description Brief Description of Process • Login Process :This process checks the authentication and admin can able to access the application. •Purchase process :Supplier gives the information about purchased item. •Stock Process :Stock gives the information about which current stock is available. • Sales Process:The customer gives the order for item. The order information is stored into sales master and payment detail is given to the customer. Page 27 of 61
27
AMPICS LIBRARY
Page 28 of 61
28
AMPICS LIBRARY
Login Form
Page 29 of 61
29
AMPICS LIBRARY
Login Form
Page 30 of 61
30
AMPICS LIBRARY
Home Form
Page 31 of 61
31
AMPICS LIBRARY
Item Form
Page 32 of 61
32
AMPICS LIBRARY
Item Form
Page 33 of 61
33
AMPICS LIBRARY
Supplier Form
Page 34 of 61
34
AMPICS LIBRARY
Supplier Form
Page 35 of 61
35
AMPICS LIBRARY
Stock Form
Page 36 of 61
36
AMPICS LIBRARY
Purchase Form
Page 37 of 61
37
AMPICS LIBRARY
Purchase Form
Page 38 of 61
38
AMPICS LIBRARY
Stock Form
Page 39 of 61
39
AMPICS LIBRARY
Sales Form
Page 40 of 61
40
AMPICS LIBRARY
Stock Form
Page 41 of 61
41
AMPICS LIBRARY
Customer Form
Page 42 of 61
42
AMPICS LIBRARY
Customer Form
Page 43 of 61
43
AMPICS LIBRARY
Purchase Return Form
Page 44 of 61
44
AMPICS LIBRARY
Purchase Return Form
Page 45 of 61
45
AMPICS LIBRARY
Sales Return Form
Page 46 of 61
46
AMPICS LIBRARY
Sales Return Form
Page 47 of 61
47
AMPICS LIBRARY
Bill Form
Page 48 of 61
48
AMPICS LIBRARY
Bill Form
Page 49 of 61
49
AMPICS LIBRARY
Page 50 of 61
50
AMPICS LIBRARY
Customer Report
Page 51 of 61
51
AMPICS LIBRARY
Customer Report
Page 52 of 61
52
AMPICS LIBRARY
Purchase Report
Page 53 of 61
53
AMPICS LIBRARY
Bill Report
Page 54 of 61
54
AMPICS LIBRARY
Sales Report
Page 55 of 61
55
AMPICS LIBRARY
Supplier Report
Page 56 of 61
56
AMPICS LIBRARY
Testing The testing is the process to check the program and find the errors.
There are basic three type of testing 1) code testing 2) Specification testing 3) Unit testing 1> Code testing The code testing strategy examines the login of the program. To follow this testing method, the analyst develops test cases that result in executing every instruction in the program. 2> Specification testing The specification stating with the program should do and how it should perform under various condition by Examining the result the analyst can determine Whether the program according to its specified requirements. :The analyst must perform both unit testing and system testing. Page 57 of 61
57
AMPICS LIBRARY
3> Unit Testing:In this testing each and every program is tested individually using record to see whether that program produced satisfactory outputs and validation also. Example: If input value is numeric and user giving character then proper message will display in message box.
Page 58 of 61
58
AMPICS LIBRARY
Post implementation review After the system is implemented and conversion is complete, user usually conducts a review of the system.
The new system needs less man power and provides information on time.
Saves data entry duplication work.
It also provide the locking system and password protection so it is reliable.
Page 59 of 61
59
AMPICS LIBRARY
Future Enhancement
There are the Future Enhancements we are going to do in our system. And may be some other kind future changes will be possible in our system also.
We convert our system into website. Pay payment via Credit / Debit Card.
Next version will also resolve any error or mistake remained unsolved in this version.