1.2 Project Overview Title of Project:: Electronic Shop Management System
1.2 Project Overview Title of Project:: Electronic Shop Management System
1.2 Project Overview Title of Project:: Electronic Shop Management System
2 PROJECT OVERVIEW
Title of Project:
Buy ‘N’ Save Inventories with a vision for the future decided to have all its
operations computerized. To start with they decided to take up the inventory first.
Project Category:
This is a project which can be placed in the category of RDBMS & OOPS.
Hardware Requirements:
Pentium III, 700 MHz, 40 GB HDD, 256 MB RAM, A CD Writer / Reader, A Color
Monitor.
Software Requirements:
Vb 6.0
MS Access
MS Windows XP
For the Front-End I intend to use Visual Basic and for the Backend MS Access will be
used.
St.Philomena College,Puttur
1.4 INTRODUCTION TO VB 6.0
Visual Basic was designed to be easily learned and used by beginner programmers. The
language not only allows programmers to create simple GUIapplications, but can also
develop complex applications. Programming in VB is a combination of visually
arranging components or controls on a form, specifying attributes and actions of those
components, and writing additional lines of code for more functionality. Since default attributes
and actions are defined for the components, a simple program can be created without the
programmer having to write many lines of code. Performance problems were experienced by
earlier versions, but with faster computers and native code compilation this has become less
of an issue.
1.5 MS Access
Microsoft Access uses similar features to those found in other databases and
some other features that are unique. Most of these additional features are made
possible by Access’s tight integration with the Windows NT operating system. MS
Access contains the data storage options and the capability to store and process the
same volume of data as a mainframe or a mini computer.
MS Access is the latest Client/Server based RDBMS package from Microsoft.
Its new features provide a very high degree of performance making it comprehensive
package for database management. It is a largely used in medium-sized
establishments.
St.Philomena College,Puttur
1.6 STRUCTURE OF THE PROGRAM
Analysis:
St.Philomena College,Puttur
2.1 INTRODUCTION
The software project is initiated by the client needs. In the beginning, these
needs are in the minds of various people in the client organization. The requirement
analyst has to identify the requirements by talking to these people and understanding
their needs. For such systems, the requirements problem is complicated by the fact
that the needs and requirements of the system many not to be known even to the user-
they have to be visualized and created. Hence, identifying requirements necessarily
involves specifying what some people have in their minds. When inputs from multiple
people are to be gathered, as is often the case, these inputs are likely to be inconsistent
as well.
2.1.1 Purpose:
2.1.2 Scope:
St.Philomena College,Puttur
2.1.3 Definitions, Acronyms, Abbreviations
This program is a menu driven program. When we click the main menu the
different forms will be enabled. The program consists of the following modules:
Source listing
This module is suppose to identify the products by their discription.
Add products
This module is suppose to take the inputs from an input device.
Add customers
This module is capable of adding customers in the specified formats.
Searching
In this module the admin or emplyee can search the customer or
products from the database based on criterias
Transactions
This module will take up transactions like selling products, buying
products from supplier updating cash and updating the
bills.Appropriate actions will be taken.
Report Generation
This is a client program which will request for reports.
St.Philomena College,Puttur
2.1.4 References
The needed requirements for this project has been obtained from the
stock by observing manual records and also gathered some of the
information by asking questions.
Vb 6.0
2.1.5 Overview
St.Philomena College,Puttur
2.2.2 Product Functions
St.Philomena College,Puttur
2.2.5 Assumption and Dependencies
Assumptions:
The code should be free with compilation errors/syntax errors.
The product must have an interface which is simple enough to understand.
Dependencies:
All necessary hardware and software are available for implementing and use
of the tool.
The proposed system would be designed, developed and implemented based
on the software requirements specifications document.
End users should have basic knowledge of computer and we also assure that
the users will be given software training documentation and reference
material.
i. The application should be able to handle all the tasks in an efficient manner.
ii. The application should be able to provide up-to-date information.
iii. The application should be able to handle all the changes made.
The user interface is designed in Visual Basic.Net. The developer will have to
study the designing of the product. The use of the controls and the component from
the Add items feature of the Vb 6.0. The user of the product will get very user
friendly forms which will be very easy to work with.
St.Philomena College,Puttur
2.3.3 Performance Requirements
The system is supposed to be having good memory space and a Bigger Ram
above 256 MB preferably. The sound card and graphics card will have to be of good
quality and capacity.
Software Constraints:
Operating system Windows XP, 2003
Microsoft Visual Basic 6.0
MS Access
Hardware constraints:
Computer: INTEL compatible
256 MB RAM or higher
Pentium III
A CD Writer / Reader
A Color Monitor
St.Philomena College,Puttur
3.1 INTRODUCTION
The Design activity is often divided into separate phases – System Design and
Detailed Design. System Design is sometimes also called Top-Level Design. This
system design aims to identify and modules that should be in the system, the
specifications of these modules, and how they interact with each other to produce the
desired result. At the end of the System Design all the major data structures, file
formats, and the major modules in the system and their specifications are decided.
St.Philomena College,Puttur
3.4 DESCRIPTION OF PROGRAMS
A Context Flow Diagram is a top level (also known as level 0) data flow
diagram. It only contains one process node (process 0) that generalizes the function of
the entire system in relationship to external entities. In context diagram the entire
system is treated as a single process and all its inputs, outputs, sinks and sources are
identified and shown.
Box The Box is called an entity which represents a producer or a customer of the
Information
Arrow The Arrow represents the data flow. All arrows in the data flow diagram
are labeled. The arrowhead indicates the direction of data flow.
Parallel Lines Represents a repository of data that is to be stored for use by one or
more processes.
St.Philomena College,Puttur
CFD OF INVENTORY MANAGEMENT SYSTEM:
Report
Login
Update
Customer /
Products /
User
Electronic
Shop Mgt
System
Customer /
Product /
Update Transaction
St.Philomena College,Puttur
3.4.2 Data Flow Diagram (DFD):
A DFD represents flow of data through a system. Data flow diagrams are
commonly used during problem analysis. It views a system as a function that
transforms the input into desired output. A DFD shows movement of data through the
different transformations or processes in the system.
Dataflow diagrams can be used to provide the end user with a physical idea of
where the data they input ultimately has an effect upon the structure of the whole
system from order to dispatch to restock how any system is developed can be
determined through a dataflow diagram. The appropriate register saved in database
and maintained by appropriate authorities.
St.Philomena College,Puttur
Data Flow Diagram Notation
Function
File/Database
Input/output
Flow
St.Philomena College,Puttur
Data Flow Diagram of the Inventory Management
Level 0:
Input Output
Admin/User
System Data Base
Level 1:
Admin/User
Login
Not Valid
Valid
Main Screen
St.Philomena College,Puttur
Level 2:
Logged in
Admin/ Storekeeper
User
New
customr/prodcts
details DB
Customer
details
Sell to
Transactions customer/take
Of products from supplier
List of
Transactions DB
And customers
A B
St.Philomena College,Puttur
A B
Search
products
and DB
customers
Reports DB
Display
Logout
St.Philomena College,Puttur
Level 3:
Login Admin
Add/View/
Update Delete the
DB
Items
Reporting
Pending
Report
Paid
Report
St.Philomena College,Puttur
4.1 ER DIAGRAM
BuyAm
t PayAmt
Price
Purchase
ProductDes date
c
Name
Item Transaction
Code
1
Purchas
1
e
Customer
Confirm Has
Purchas Detail
e s
CID Add
N
Name
Has Product
Detail
s
IName
PId
Unit
Price
UPrice Tota
Quantity
l
Pric
e
St.Philomena College,Puttur
Amoun Quantity
t
Area State
St.Philomena College,Puttur