GEMS & JEWELLERY

SHOP MANAGEMENT SYSTEM

A

Project Report

On

“Gems & Jewellery Shop Management System”

In

Partial Fulfilment of

Bachelor of Computer Application

BCA-III(Sem-V)

By

MR.MAYURESH G BADAYA

&

JASLEEN SINGH SAHANI

Under Guidance of

Mrs.Swati.S. Shinde

To

“University of Pune”

Through

Sinhgad TechnicalEducation Society

Nivruti Babaji Navale College of Commerce

Kusgaon(Bk)

Lonavala,Pune

2010-2011

CertificateThis is to certify that MAYURESH G. BADAYA & JASLEEN SINGH

SAHANI has successfully completed the project report on “GEMS & JEWELLERY SHOP MANAGEMENT SYSTEM” as partial fulfillment of Bachelor of Computer Application course affiliated to University of Pune during academic year 2010-2011.

This work is original work carried out by him & has not been submitted to any of the University/Institute for an award of any degree/diploma.

Place: - Lonavala

Date: - OCTOBER 2010

Principal External Examiner Project Guide

INDEX

1. Introduction

o Introduction to system

o Scope of the system

o Proposed System

2. Analysis

o Fact Finding Technique

o Feasibility Study

o Hardware & Software Requirement

3. System Design

o E-R Diagram

o Context Level Diagram

o Data Flow Diagram

o File Design

4. Form Design (with input values)

5. Reports

6. Advantages & Limitations

7. Future Enhancement

8. Bibliography

Acknowledgement

At first I would like to give heartiest thanks to my guide Mrs.Swati Shinde for her valuable suggestions,guidance and endless contribution of time for successful completion of my project.I am also thankful to her for providing me all the facilities needed during the project development.

Secondly, I am thankful to my college for granting me permission and kind co-operation for conducting this project. Last but not the least , I would like to thank all my friends for their everlasting support and encouragement.

Thanks

Name:-Mayuresh G Badaya

&

Jasleen Singh Sahani

Introduction

As we all know the management of anything involves a lot of database requirement,transactions

and other complicated processes.Thus making software and computerizing all the work of the

company saves a lot energy and manual work thus saving cost by reducing the manpower

required to do the huge amount of work.

Our software is quite small and simple as well as easy to handle as it requiresvery low

maintenance.This software involves very less number of steps for entering,modifying or

retrieving the data.Thus it is quite fast to work with.

One more speciality is the management of stock according to each single product available in

the company and multiple user accounts facility.This facility makes the software much secure as

only users with full access acxcounts can perform the appropriate activity.Thus all the

information of the customers will be safe,which is one of the very important concerns nowadays.

Scope

This existence of the system or software you developed is of much much importance.The

software should be such that it must be universally accepted and should be able to use every

where in it’s own field of application.It can be widely used at various jewellery companies

maintaining various products like gemstones, jewellery product etc. As it maintains efficient

records keeping it adds plus point in use of it.Also it provides facility to update it’s data which is

used offently and is stored by the adminintrator.

Proposed System

This software is implemented in programming language Visual Basic and database stored in

MS-Access. Connection between this projects and database are done in ODBC of control

panels.

Active-x controls are used in the project that inbuilt applications are available for the project.

System

1:-Purchase;-

This includes product ID, product type, product size,quantity, price, purchase date

and name and details of the supplier.

2:-Sales:-

This includes customer details, contact person, product type, product size, product

shape, quantity, price and sales date.

3:-Stock:-

This includes detail of the product in stock. This shows the product type, product

size and quantity of the product available in stock. I also checks for the stock if quantity to be

sold is greater than quantity available in stock.

Reports:-

1:-Sales Report:-

This report is used to view all the information of the sales. It shows the day wise sales and month wise sales report. It can be used to take bill for a particular customer as single sales report for that particular customer.

2:-Purchase Report:-

This report is used to view all the information of the purchase. This report shows the details of the purchases made for every single product of its own type;

3:-Stock Report:-

This report is used to view all the information of the stock available.

Objectives

This software is specially prepared for accessing of data the whole management is done by keeping in mind the process of handling data in a jewellary shop. Its does data file handling in a more appropriate manner. The main aim of this software is to obtain maximum task in minimum time.

Contents:-

Availability of jewellery item –It keeps the up-to-date information about the jewellery available in the store quantity, price & contents.

Stock information- It checks whether the jewellary in sufficient supply, if not then gives warning.

Easy access – for checking the existence of a specification in the jewellary store can be done by enter wine name.

Billing – Bill of the total number of jewellery purchased per customer can be generated there itself.

Limit access – It provides limited access to user other than ADMIN for security concern.

FEASIBILTY STUDY

A feasibility analysis usually involves a through assessment of the operational(need),

financial and technical aspects of a proposal. Feasibility study is the test of the system proposal

made to identify whether the user needs may be satisfied using the current software and

hardware technologies, whether the system will be cost effective from a business point of view

and whether it can be developed with the given budgetary constraints. A feasibility study should

be relatively cheap and done at the earliest possible time. Depending on the study, the decision is

made whether to go ahead with a more detailed analysis.

When a new project is proposed, it normally goes through feasibility assessment.

Feasibility study is carried out to determine whether the proposed system is possible to develop

with available resources and what should be the cost consideration. Facts considered in the

feasibility analysis were.

Technical Feasibility

Economic Feasibility

Behavioral Feasibility

HARDWARE-SOFTWARE REQUIREMENT SPECIFICATIONS

Hardware Requirement

RAM : 4GB

PROCESSOR : P4

HARD DISK : 512MB

PRINTER : INKJET/DOT MATRIX

Software Requirements

Operating System : Windows XP

Front-End : VISUAL BASIC 6.0

Back-End : MICROSOFT ACCESS

Form Design:-

Czsales:-

Name Datatype DescriptionSno Autonumber Primary KeyCompany name TextProduct Type TextProduct Size NumberQuantity NumberPrice NumberTotal Number

Czpurchase:-

Name Datatype DescriptionSno Autonumber Primary KeyCompany name TextProduct Type TextProduct Size NumberQuantity NumberPrice NumberTotal Number

Czstock:-

Name Datatype DescriptionItem TextSize NumberQuantity Number

Jewellery Sales:-

Name Datatype DescriptionSno Autonumber Primary KeyCompany name TextProduct Type TextQuantity NumberPrice NumberTotal Number

Jewellery Purchase:-

Name Datatype DescriptionSno Autonumber Primary KeyCompany name TextProduct Type TextQuantity NumberPrice NumberTotal Number

Jewellery Stock:-

Name Datatype DescriptionItem TextQuantity NumberDate Text

Semi-Precious Sales:-

Name Datatype DescriptionCompany Name TextItem TextProduct Shape TextProduct Size NumberQuantity NumberPrice NumberTotal NumberSales Date Text

Seme-Precious Purchase:-

Name Datatype DescriptionCompany Name TextItem TextProduct Shape TextProduct Size NumberQuantity NumberPrice NumberTotal NumberPurchase Date Text

Seme-Precious Stock:-

Name Datatype DescriptionItem TextProduct Shape TextProduct Size NumberQuantity Number

Payment:-

Name Datatype DescriptionSno Autonumber Primary KeyPayment made To TextFor Purchase Of TextAmount NumberAmount Piad NumberBalance NumberDate Text

Receive Payment:-

Name Datatype DescriptionSno Autonumber Primary KeyPayment Receive From TextFor Sales Of TextAmount NumberAmount Received NumberBalance NumberDate Text

Login:-

Name Datatype DescriptionUser Name TextPassword Text

Order:-

Name Datatype DescriptionOrder No Autonumber Primary KeyOrder From TextOrder Date TextShape TextSize NumberQuantity NumberPrice NumberTotal Number

Splash Form:-

Login Form:-

Main Form:-

Cz Sales Form:-

Cz Purchase Form:-

Cz Stock Form:-

Jewellery Sales Form:-

Jewellery Purchase Form:-

Jewellery Stock Form:-

Semi-Precious Sales Form:-

Semi-Precious Purchase Form:-

Semi-Precious Stock Form:-

Order Form:-

Payment Form:-

Semi-Precious Stock Report:-

Jewellery Stock Report:-

Cz Stock Report:-

Semi-Precious Purchase Report::-

Jewellery Purchase Report:-

Cz Purchase Report:-

Exit Form:-

DATEFLOW DIAGRAM (CONTEXT LEVEL)

Semi-Precious Details

Cz Details

Jewellery Detail

Purchase Quotation Details

Purchase Quotation Details

Sales Details

Order DetailsSales Details

Order details

Feedback details

Inquiry Details

REPORTS

CUSTOMERMANAGEMENT

SUPPLIER

0.0

GEMS & JEWELLERY

SHOP MANAGEMENT

ADMIN

Data Flow Diagram {First Level}

PaymentDetailsPaymentDetails

Sales DetailsSalesDetails

ProductDetails

ProductDetails

OrderDetails

Customer Details

OrderDetails

Customer Details

Order Details

ProductDetailsProductDetails

Order Details

Quatation Details

Product DetailsProduct Details

Quatation Details

Supplier file

1.0

Supplier process

Supplier

2.0

Order ProcessOrder File

Admin

3.0

Customer Process

Customer FileCustomer

4.0

Sales ProcessSales File

5.0

Payment & Bill Process

Payment & Bill File

Admin

Customer

MIS Reports

Supplier Report

Purchase & Bill Report

Customer Report

Order Report

Sales Report

6.0

ReportManager

Sales File

Order File

Customer File

Supplier File

Payment & Bill File

ADVANTAGES

Automation of day to day work of “GEMS & JEWELLERY SHOP MANAGEMENT SYSTEM”.

Usage of system would help in proper storage of daily record. Save time consumption. Computerized auditing can be done. Error free stock management system of raw material. Real time updates of the database when any sale or purchase is made. Quick & faster access of stored data of customer whenever required by

the user. Ease the burden on the employees to update the stock report. No expertise required for handling the system. Reduce extra employee cost. Reduced time to search the record. System is very helpful to display all the records. Password can be reset easily. If three times password is typed wrong then the login window will exit.

LIMITATIONS OF SYSTEM

Employee must be trained to use computer system.

The hardware requirements limit the use of hard disk drive (HDD) LESS

THEN 20GB. Vast product data to be handled due course of time needs

suitable data backup devices to be used.

The application can’t work on operating system other than windows.

Handling of an oracle requires an expert hand.

The system is not web supported, because these limitations systems

capabilities are not utilized in a wide range.

No separate database available for different products.

There is no any facility to backup data in another storage location.

When power of system is off improperly then unsaved data recovery is

not available.

Computerized system may lead to unemployment.

FUTURE ENHANCEMENT

There is a scope for the enhancements in the available system. The

enhancement can be noted as:-

Automatic reordering date signals

Automatic reordering quantity recognitions. By calculating the sale

purchase ratio of the different products.

Online availability of products.

Online purchase of products.

Online advertising of Company & Products.

CONCLUSION

The system works efficiently in the present situation. The uniqe

features like automatically database update & stock display proved

helpful in the daily work of the stock

There are some limitations like delicate database connectivity, but for

small reasons the system proves to be efficient.

The system can be enhanced in the near future by making it online

ordering/selling/payments.

It can be used for online advertising.

BIBLIOGRAPHY

Visual Basic 6.0 Programming Black Book by Steven Holzner.

Programming with Visual Basic 6.0 by Mohammed Azam.

Nirali Prakashan VISUAL BASIC by Umakant S. Shirshetti & Mrs.

Bhavana Chaudhari.

Vast knowledge of MRS. SWATI S. SHINDE

Sites:-

www.google.com (For Images)

www.planet-source.com (Connectivity Reference)

E R Diagram:-

CUSTOMER Jewellery shop

ProductAdmin Staff

has

Buys

Stock

manages

Buys

types

CZ

Jewellery Semi Precious

Number Name

Type

Size

Size

Type

Size

Type