Book Shop Management
Book Shop Management
Book Shop Management
1. INTRODUCTION
1.1 Statement of Problem
The aim of this project is to computerize the entire management of Bookshop. The system allows provision for Private & public purpose. It includes facility for storage, stock-table, Daily report. Stock-table department maintains record of each & every book & Stationary materials, its type, price, Author, date of delivery etc. If no book or stationary is available in the stock then seller gives an order to publisher for purchasing the material & then the stock gets updated. Every customer gets the bill details of the material he/she purchased. There is also a discount on the material which is purchased by customer. Daily the stock-table gets updated, so the sellers always have information about his changeable stock. Using computerized system the paper work is also gets reduced. With computerized system each task becomes simple, fast & accurate.
Automatic stock updation. To create goodwill in the market by making faster customer response, Accuracy and efficient information in the database of system.
Features: Reduces manual work such as down maintaining of paper work. Large database is managed easily. Reduces expenses over stationary. Provide online help to the user of system. Secured way of data Management. Increase in correctively and efficiency of work.
Introduction of Visual Basic:When the VB window is opened it shows startup screen used to select the type of project design in VB. VB window is called as an IDE [Integrated Developed Environment]. It refers as an IDE because it integrates many functions such as editing, compiling, linking and debugging within single environment. The VB IDE consists of:1] Menu Bar 2] Toolbar 3] Toolbox
5 JAYSINGPUR COLLEGE, JAYSINGPUR
4] Property window 5] Form layout window 6] Project explorer window 7] Object browser 8] Form designer 9] Code editor window
* Menu Interface Adding menus to it can enhance VB application. It offers a convenient and consistent way to group commands and an easy way for access them. Using the menu editor, we can add new commands to executing menus, create new menus bars, change and edit existing menus and menu bars. * Graphics VB provides a variety of ways to create and use graphics in an application, which adds styles, interest and visual structure to the interface of an application. Graphic objects such as lines, circles, and bitmaps can be displayed in visual basic in a quicker and easier way. * Multiple Document Interface A multiple document interface is used for opening many windows at the same time. All the document windows are contained in a parent window, which provides a workspace in the application.
6 JAYSINGPUR COLLEGE, JAYSINGPUR
Features of Visual Basic: Enhanced IDE (Interactive Development Environment):- Visual Basic has added of enhancement to environment to make interactive. 2. New database engine:- Visual Basic is completely 32 bit database engine. 3. Database Manager Utility:- V.B 5.0 onwards come with Visual data manager utility. You use visual data manager to map create and manipulate database with writing code. 4. Data control and Standard data bound controls:- For visual data access you can use data control and bound controls to create data browsing application without writing code. 5. Advanced data bound controls:- Visual Basic includes database combo (DBCombo), DB List, DB Grid etc. Data bound controls for writing advanced database applications. 6. New technology custom controls:- They are earlier custom controls based on OLE (Object Linking and embed) technology. Example: OCX control (third party control)also called ActiveX control.
1.
Application setup wizard:- With the application setup wizard we can create distribution diskette of your application. 8. Multiple Project:- Visual Basic supports project groups that contain more than one project. 9. Enumeration:- It provides you to create C style enumeration or enumerated data type to work with symbolic constants. 10. Numeric code Compiler:- visual Basic contains a native compiler to create compete executable file.
7.
Introduction to MS-Access :The term database means the collection of fields and records. In access the term database is collection of all tables that composes the complete system. Access offers a variety of features for different databases needs it can be used to develop three general type of application. 1] Application used to run small business:Access is excellent platform for developing an application that runs a small business, its wizards allows developers to quickly and easily build a foundation of the application. 2] Departmental Application:-
Access is perfect for developing application for department within large corporation. It is relatively easy to upgrade the user within a department to appropriate hardware. 3] Corporation wide application:Access might be best suited for departmental application. It can also used to produce application. It can also used to produce application that distribute throughout the organization. Visual Basic supports many database management systems. Mostly VB uses the Microsoft Access as backend tool.
Features of access:1. Working on other applications. 2. Working with sample application. 3. Working in the database window. 4. Using and customizing toolbars, shortcut menus. 5. Working with data. 6. Working with filters. 7. Printing and previewing.
menu bars
and
RAM
64 MB /above
64MB /above
3. SYSTEM ANALYSIS
3.1 Data Flow Diagram
Suppli er
Book-Master
Supp ly Updat e Chec k Info
Orde r
2.0 Sales
Sales Bill
BillInfo
Supp ly
Pay
Info
3.0 Accoun t
Upd ate
Pay
Register
Recei pt
A/C
Recei pt
Supplier Book-Master
Chec k
Info
Updat
Purch ase
Bill-Master
Customer
Book-
Amt
Bill no
Dis c
Bco de
Hass
H as
Dis c
a
Qty
Bco de
K ee p
Qty
SalesDetail
Bco de Pra te
Amt
Stock
Sto ck
PurchaseDetail
H as
H as
Sco de Cust no Scn o Sad d Typ e Due s Sco de Cno Pda te
Bill no
SalesMast
Sda te
Snam e
SupplyMast
Due s
NetA mt
H as
AmtPa id Cad d
H as
CustTrans
Cn m
Due s
Bill no
SupplyTrans
15
Phon e
4. SYSTEM DESIGN
4.1 Database Design
1. Book Master:
Field Name
Bcode Bnm Author Publication Edition Price Year Type
Data Type
Text Text Text Text Text Number Date/time Text
Width / Size
10 20 20 20 20 Single Medium Date 20
Constrai ns
Primary key ---------------
2. Customer Master:
Field Name Data Type Width / Size Constrai ns
16 JAYSINGPUR COLLEGE, JAYSINGPUR
Totdues
Number
20 30 30 Integer
Integer
3. Purchase Detail:
Field Name
Bill No. Bcode Qty Disc Amt
Data Type
Width / Size
10 10 20 20 20
Constrain s
Primary key ---------
4. Sales detail:
Field Name
Billno Qty Disc Amt Bcode
Data Type
Text Text Number Number Number
Width / Size
10 10 Integer Integer Integer
Constrai ns
---------
Primary key
5. Sales Transaction:
Field Name Billno Sdate Custno Netamt Amtpaid Dues Data Type Text Date/ Time Text Number Number Number Width / Size 10 Medium date 10 Integer Integer Integer Constrains
-------------
6. Stock:
Field Name Data Type Width / Size Constrain s
18 JAYSINGPUR COLLEGE, JAYSINGPUR
10 Integer Integer
Primary key
-----
7. Supplier Detail:
Field Name Billno Bcode Qty Disc Amt Data Type Width / Size Text 10 Text Number Number Number 10 Integer Integer Integer Constrain s Primary key
---------
8. Supply Master:
Field Name Scode Snm Sadd Scno Type Totdues Data Type Width / Size Text Text text text Text Number 10 30 30 15 30 Integer Constrain s Primary key
-----------
Loading of Project
Login Window
Wrong Password
Book Records
Supplier Information
Customer Master
Purchase Transaction
Sales Transaction
Supplier Information
Customer Records
5. USER MANUAL
To start this Software you should have all necessary files to execute the package. Assuming that user is having all necessary environment & he / she is at main menu of system. To start Book Shop Management, you should first log in the system with appropriate user name & password as shown below : User Name: granth Password: 123
1. MASTER FILES:
In the master menu you have three options that are a) Book Master b) Supplier Master c) Customer Master
2.
TRANSACTION:
In the transaction menu you have two options that are a) Sales Transaction b) Purchase Transaction
The basic keys used are as follows: *Operational Keys 1) New : This option is used for adding new information.
2 Modify : This option is used for making changes in existing record. 3) Delete : This option is used to delete particular record. 4) Clear : This option is used for refreshing the fields for new addition. 5) Exit : This option is used to come out from particular dialog box &
39 JAYSINGPUR COLLEGE, JAYSINGPUR
return to main menu. 6) Print: This option is used to print the report. 7) Save: This option is used to save the records.
3. REPORTS:
In any organization repots play an important role, since they help the owner in decision making. Any information system should produced reports giving consolidated information in any format required by user. In the report menu you have Six reports that are a) Book Information b) Supplier Information
c)
d) Customer Information
e) f)
4. EXIT:
When you click on the exit menu the system will ask you for whether every application is closed before closing the system.
40 JAYSINGPUR COLLEGE, JAYSINGPUR
6. FUTURE ENHANCEMENT
The present Book Shop Management System we have to insert the product code for billing but in future we can use the barcode reader for saving transaction time. In this system we can add additional utilities i.e. back-up. To ensure that the customer is able to receive a functional data base by the set deadline, rather than simply a security system, the full flexibility of the enhancement. Also, as analysis of the archive requirements that there be an archive to analyze, this part of the system has been left to later date. Only once the system has been operating the sometime will this information be useful (or available), so our efforts will mostly be concentrated on the day-to-day function of the database.
7. CONCLUSION
The present computerized system, Book Shop Management System is useful for creating up-to-date Customer registration information and billing information reports. It is very helpful package to keep record of every customer along with their detail information of the sales, purchase, and so on. This system is developed as simple as possible to user. Being user-friendly software the user doesnt find any difficulty in using it. Keeping detailed records of each and every customer is a lengthy and tedious job. This software overcomes these problems.
8. REFERENCE
REFERED BOOKS:
1) Visual Basic 6.0 2) System Analysis and Design 3) Database Management System : Mohammad Azam. : E. H. Awad. : Nirali Prakashan