Electronic Shop Project Report 5k3q4q
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3b7i
Overview 3e4r5l
& View Electronic Shop Project Report as PDF for free.
More details w3441
- Words: 2,288
- Pages: 19
Coding Talks
1.2 PROJECT OVERVIEW Title of Project: Electronic Shop Management System
Objective of the 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.
1.3
Tools
/
Platform,
Hardware
&
Software
requirement
specifications Platform – Windows XP Front End – MS Visual Basic.Net Back End – MS Access
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
Coding Talks
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.
1.6 STRUCTURE OF THE PROGRAM St.Philomena College,Puttur
Coding Talks
Analysis: Electronic Store management system becoming an essential to efficiently manage inventories in computer age. Electronic Shop Management System is a workable application for retail store inventory and s management. It keeps a list STOCKS and products at a store and can do operations on them. The most important operation is a "PURCHASE", all the transactions and billing details and stock purchasing details involved on it. Why We Want to Hold Inventories •
Improve customer service
•
Reduce certain costs such as
•
Ordering costs
•
Stock out costs
•
Acquisition costs
•
Start-up quality costs
•
Contribute to the efficient and effective operation of the production system
St.Philomena College,Puttur
Coding Talks
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 -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: This project is aimed at providing an economically feasible security and communication system that will provide very good features that can fulfill the security needs of a small organization. The project will be supposed to implement the storage of products so that a large collection could be maintained with minimum storage space. This project will also be able to provide reports of products sold to the customer and brought to the store.
2.1.2 Scope: The project could be implemented in an average sized organization. An average company will not be very keen on spending loads of money on ledgers. Where as our project will greatly reduce the costs which is using common and cheap office items like database and desktop application. And also there is no requirement to store books or s. The data is directly stored in the database in the hard disk of the PC.
St.Philomena College,Puttur
Coding Talks
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.
•
Update and delete products This module will update and delete products.
•
Update and delete customers This module will be able to update and delete customers
•
Searching In this module the 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
bills.Appropriate actions will be taken. •
Report Generation This is a client program which will request for reports.
St.Philomena College,Puttur
updating
the
Coding Talks
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 Electronic Shop is a process of storing the products which is capable of maintaining storage of large amount of products. The primary purpose of this application is to implement the above stated functionality. The application should be capable enough to store the products and also perform some updating on the products that is stored. It will be having friendly GUIs that will guide the to easily achieve the same. The application shall also have some features like reports displaying in the same window. In addition to this the application also s feature to search products. It can also search products based on criteria so that the employees will be able to view the same. The application is to be fully developed under vb platform using Visual Basic 6.0
2.2 OVERALL DESCRIPTION
2.2.1 Product Perspective The product will be developed completely independent and standalone. Each will have to have an individual copy of the product.
St.Philomena College,Puttur
Coding Talks
2.2.2 Product Functions
The product functions will include the following areas: The application is capable enough to store different products and also perform some editng on them that is added.It will be having friendly GUI’s that will guide the to easily achive the same. •
Form
•
Form
•
Adding s
•
Adding products
•
Updating s
•
Updating products
•
Searching s and products
•
Report generations
2.2.3 Characteristics The of this product is supposed to be fairly educated about the usage of the computers. He should understand how to store products and he should have knowledge about various products so that they could be saved. A person who has no knowledge of computers will find it difficult to understand the system. But with a little knowledge it will be very easy to handle the project.
2.2.4 General Constraints Designed to run on Windows 98 and further versions.
St.Philomena College,Puttur
Coding Talks
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 s should have basic knowledge of computer and we also assure that
the s will be given software training documentation and reference material.
2.3 SPECIFIC REQUIREMENTS 2.3.1 Functional Requirements 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.
2.3.2 External Interface Requirements 2.3.2.1 Interfaces The interface is designed in Visual Basic.Net. The developer will have to study the deg of the product. The use of the controls and the component from the Add items feature of the Vb 6.0. The of the product will get very friendly forms which will be very easy to work with.
St.Philomena College,Puttur
Coding Talks
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.
2.3.4 Design Constraints 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
2.3.5 Other Requirements None
St.Philomena College,Puttur
Coding Talks
3.1 INTRODUCTION The purpose of the Design Phase is to a solution of the problem specified in the requirements document. This is the first step in moving from the problem domain to the solution domain. The design of a system is perhaps the most critical factor affecting the quality of the software; it has a major impact on the later phases is the Design Document. This Document is similar to a blueprint or a plan for the solution and is used later during implementation, testing and maintenance. 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.
3.2 APPLICABLE DOCUMENTS The document used for preparing system design is software requirement specification (SRS) for Inventory Management System.
3.3 FUNCTIONAL DECOMPOSITION The main functional component of Inventory Management System is: i)
St.Philomena College,Puttur
Coding Talks
3.4 DESCRIPTION OF PROGRAMS 3.4.1 Context Flow Diagram (CFD)
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.
NOTATIONS USED IN FLOW DIAGRAM:
Bubble The Bubble represents a process or transformation that is applied to the data which changes in some way. Each bubble is assigned a number. 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
Coding Talks
CFD OF INVENTORY MANAGEMENT SYSTEM:
Customer Information/ Products
/ Report
Update Customer / Products /
Electronic Shop Mgt System Update
Activities
Purchase / Transaction
St.Philomena College,Puttur
Customer / Product / Transaction
Report Generation
Coding Talks
3.4.2 Data Flow Diagram (DFD):
A Data Flow Diagram (DFD) is a graphical representation of the "flow" of data through an Information System. A data flow diagram can also be used for the visualization of Data Processing. It is common practice for a designer to draw a context-level DFD first which shows the interaction between the system and outside entities. This context-level DFD is then "exploded" to show more detail of the system being modeled.
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 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 saved in database and maintained by appropriate authorities.
St.Philomena College,Puttur
Coding Talks
Data Flow Diagram Notation
. Function
File/Database
Input/output
Flow
St.Philomena College,Puttur
Coding Talks
Data Flow Diagram of the Inventory Management
Level 0:
Input /
Output Data Base
System
Level 1:
/
Not Valid
Valid Main Screen
Level 2:
St.Philomena College,Puttur
Coding Talks
Logged in /
Storekeeper
New customr/prodcts details
DB
Customer details
Transactions Of products
Sell to customer/take from supplier
List of Transactions And customers
DB
A
B
St.Philomena College,Puttur
Coding Talks
B
A
Search products and customers
DB
Reports
DB
Display
St.Philomena College,Puttur
Coding Talks Level 3:
Add/View/ Update Delete the Items
Reporting
Pending Report Paid Report
4.1 ER DIAGRAM St.Philomena College,Puttur
DB
Coding Talks
BuyAm t
PayAmt
Price
Purchase date
ProductDes c Name Item Code
Transaction
N 1
Purchas e
1
Customer Confirm Purchas e CID
Has Detail s
Add N
Name
Has Detail s
Product
N Sino
Bill Details IName
PId
Unit Price
UPrice
Quantity Amoun t
Quantity
Tota l Pric e
St.Philomena College,Puttur Area
State
1.2 PROJECT OVERVIEW Title of Project: Electronic Shop Management System
Objective of the 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.
1.3
Tools
/
Platform,
Hardware
&
Software
requirement
specifications Platform – Windows XP Front End – MS Visual Basic.Net Back End – MS Access
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
Coding Talks
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.
1.6 STRUCTURE OF THE PROGRAM St.Philomena College,Puttur
Coding Talks
Analysis: Electronic Store management system becoming an essential to efficiently manage inventories in computer age. Electronic Shop Management System is a workable application for retail store inventory and s management. It keeps a list STOCKS and products at a store and can do operations on them. The most important operation is a "PURCHASE", all the transactions and billing details and stock purchasing details involved on it. Why We Want to Hold Inventories •
Improve customer service
•
Reduce certain costs such as
•
Ordering costs
•
Stock out costs
•
Acquisition costs
•
Start-up quality costs
•
Contribute to the efficient and effective operation of the production system
St.Philomena College,Puttur
Coding Talks
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 -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: This project is aimed at providing an economically feasible security and communication system that will provide very good features that can fulfill the security needs of a small organization. The project will be supposed to implement the storage of products so that a large collection could be maintained with minimum storage space. This project will also be able to provide reports of products sold to the customer and brought to the store.
2.1.2 Scope: The project could be implemented in an average sized organization. An average company will not be very keen on spending loads of money on ledgers. Where as our project will greatly reduce the costs which is using common and cheap office items like database and desktop application. And also there is no requirement to store books or s. The data is directly stored in the database in the hard disk of the PC.
St.Philomena College,Puttur
Coding Talks
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.
•
Update and delete products This module will update and delete products.
•
Update and delete customers This module will be able to update and delete customers
•
Searching In this module the 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
bills.Appropriate actions will be taken. •
Report Generation This is a client program which will request for reports.
St.Philomena College,Puttur
updating
the
Coding Talks
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 Electronic Shop is a process of storing the products which is capable of maintaining storage of large amount of products. The primary purpose of this application is to implement the above stated functionality. The application should be capable enough to store the products and also perform some updating on the products that is stored. It will be having friendly GUIs that will guide the to easily achieve the same. The application shall also have some features like reports displaying in the same window. In addition to this the application also s feature to search products. It can also search products based on criteria so that the employees will be able to view the same. The application is to be fully developed under vb platform using Visual Basic 6.0
2.2 OVERALL DESCRIPTION
2.2.1 Product Perspective The product will be developed completely independent and standalone. Each will have to have an individual copy of the product.
St.Philomena College,Puttur
Coding Talks
2.2.2 Product Functions
The product functions will include the following areas: The application is capable enough to store different products and also perform some editng on them that is added.It will be having friendly GUI’s that will guide the to easily achive the same. •
Form
•
Form
•
Adding s
•
Adding products
•
Updating s
•
Updating products
•
Searching s and products
•
Report generations
2.2.3 Characteristics The of this product is supposed to be fairly educated about the usage of the computers. He should understand how to store products and he should have knowledge about various products so that they could be saved. A person who has no knowledge of computers will find it difficult to understand the system. But with a little knowledge it will be very easy to handle the project.
2.2.4 General Constraints Designed to run on Windows 98 and further versions.
St.Philomena College,Puttur
Coding Talks
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 s should have basic knowledge of computer and we also assure that
the s will be given software training documentation and reference material.
2.3 SPECIFIC REQUIREMENTS 2.3.1 Functional Requirements 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.
2.3.2 External Interface Requirements 2.3.2.1 Interfaces The interface is designed in Visual Basic.Net. The developer will have to study the deg of the product. The use of the controls and the component from the Add items feature of the Vb 6.0. The of the product will get very friendly forms which will be very easy to work with.
St.Philomena College,Puttur
Coding Talks
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.
2.3.4 Design Constraints 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
2.3.5 Other Requirements None
St.Philomena College,Puttur
Coding Talks
3.1 INTRODUCTION The purpose of the Design Phase is to a solution of the problem specified in the requirements document. This is the first step in moving from the problem domain to the solution domain. The design of a system is perhaps the most critical factor affecting the quality of the software; it has a major impact on the later phases is the Design Document. This Document is similar to a blueprint or a plan for the solution and is used later during implementation, testing and maintenance. 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.
3.2 APPLICABLE DOCUMENTS The document used for preparing system design is software requirement specification (SRS) for Inventory Management System.
3.3 FUNCTIONAL DECOMPOSITION The main functional component of Inventory Management System is: i)
St.Philomena College,Puttur
Coding Talks
3.4 DESCRIPTION OF PROGRAMS 3.4.1 Context Flow Diagram (CFD)
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.
NOTATIONS USED IN FLOW DIAGRAM:
Bubble The Bubble represents a process or transformation that is applied to the data which changes in some way. Each bubble is assigned a number. 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
Coding Talks
CFD OF INVENTORY MANAGEMENT SYSTEM:
Customer Information/ Products
/ Report
Update Customer / Products /
Electronic Shop Mgt System Update
Activities
Purchase / Transaction
St.Philomena College,Puttur
Customer / Product / Transaction
Report Generation
Coding Talks
3.4.2 Data Flow Diagram (DFD):
A Data Flow Diagram (DFD) is a graphical representation of the "flow" of data through an Information System. A data flow diagram can also be used for the visualization of Data Processing. It is common practice for a designer to draw a context-level DFD first which shows the interaction between the system and outside entities. This context-level DFD is then "exploded" to show more detail of the system being modeled.
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 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 saved in database and maintained by appropriate authorities.
St.Philomena College,Puttur
Coding Talks
Data Flow Diagram Notation
. Function
File/Database
Input/output
Flow
St.Philomena College,Puttur
Coding Talks
Data Flow Diagram of the Inventory Management
Level 0:
Input /
Output Data Base
System
Level 1:
/
Not Valid
Valid Main Screen
Level 2:
St.Philomena College,Puttur
Coding Talks
Logged in /
Storekeeper
New customr/prodcts details
DB
Customer details
Transactions Of products
Sell to customer/take from supplier
List of Transactions And customers
DB
A
B
St.Philomena College,Puttur
Coding Talks
B
A
Search products and customers
DB
Reports
DB
Display
St.Philomena College,Puttur
Coding Talks Level 3:
Add/View/ Update Delete the Items
Reporting
Pending Report Paid Report
4.1 ER DIAGRAM St.Philomena College,Puttur
DB
Coding Talks
BuyAm t
PayAmt
Price
Purchase date
ProductDes c Name Item Code
Transaction
N 1
Purchas e
1
Customer Confirm Purchas e CID
Has Detail s
Add N
Name
Has Detail s
Product
N Sino
Bill Details IName
PId
Unit Price
UPrice
Quantity Amoun t
Quantity
Tota l Pric e
St.Philomena College,Puttur Area
State
Related Documents 3m3m1z
Electronic Shop Project Report 5k3q4q
October 2019 45
Mobile Shop Project Report 4t1w2a
December 2019 69
Project Report On Electronic Stethoscope 731e6
August 2021 0
Electronic Shop Management System 1a3o6i
December 2019 84
Shop Report 6e666n
December 2019 25