17-06-2014, 03:30 PM
ELECTRONIC SHOP MANAGEMENT SYSTEM
[attachment=64983]
INTRODUCTION
The age in which we live is quite different from our parents or any other generations.It is characterized by rapid changes in technology,life style and values that at times difficult comprehend from average individuals,any sufficient advanced new technology is basically undistinguishable from magic.
The selected topic is “ELECTRONIC SHOP MANAGEMENT SYSTEM”.It provides information about item details,purchase details,staff details,branch details,booking details etc.The project efficiently handles all the operations in an Electronic shop. Such as management of purchase,sales,branch,bill etc.The advantage of our project is it is easy to use,user friendly,time saving etc.
It is a Data base project.The proposed system is developed in Visual Basic 6.0.
SQL Server is the back end
SYSTEM ANALYSIS
System analysis is the process of gathering and interpreting facts, diagnosing problems and using the facts to improve the system. Analysis is a detailed study of various operations performed by a system and their relationship within and outside of the system. This involves gathering information and using structured tools for analysis
ABOUT THE EXISTING SYSTEM
In the various shops the item details,sales details etc are kept as manual records.so It is very difficult to maintain the data,a number of registers are needed there is a chance of loss of data.At the same time doesnot provide security of data.If we want to get the details of a particular product or sale we have to search the entire record.Item details as well as bill details are stored separately in different registers,so if a person wants to know the details, he has to refer a number of registers, sometimes there is a chance of data inconsistency, and data redundancy.
Computerization reduces the communication gap because anything is programmed as per schedule and omission of information is not possible at all
DISADVANTAGES OF THE EXISTING SYSTEM
The existing system has some limitations that can be said as follows:
The existing system is manual and time consuming.
A number of registers, books etc are used which need huge storage space.
Retrieval of information in time is impossible.
Lacks of security.
PROPOSED SYSTEM
Taking into account the shortcoming of the existing system, a new computerized system was proposed with Visual Basic 6.0 as front end and SQL server as back end. High speed and ease of use are the main features of the proposed system.
The proposed system allows acceptance of details of each item and to store it in a datbase.It prevents unauthorized access.By using the system we can record the item details,bill details,staff details,branch details,booking details etc.
Using the system we can easily search the details of particular purchase.. We are providing the help facility for accessing in a user-friendly manner.
Its make possible by just clicking on the required buttons that are displayed on the screen. Separate forms have been designed for each of these options presented on the screen. These are specific and easy to understand.
ADVANTAGES OF PROPOSED SYSTEM
The various advantages can be summarized as follows:
Through this system,automatic updating, , editing, searching of records are made possible.
Data redundancy is avoided as compared to manual system.
Greater efficiency reduced the time taken to process the work and makes less susceptible to errors.
Easy in handling data and provides timely reports.
The system is user friendly.
Data manipulation is more reliable and accurate.
Better security is provided.
Enables to view large volume of data in shorts time.
Visual Basic 6.0
VB is Visual Design Environment, designing from that makes up user interface, adding codes to the forms and objects such as buttons, textboxes, labels and required support code in adding modules. It is a higher performance, highly integrated development environment that allows creating, building and debugging and debugging window applications faster and easier than ever before. It is a graphical user interface. Online help is also available.
VB has become a popular environment due to the following features:
Visual Basic application is event driven, which means that the user is in control of the application.
Visual Basic application is a complete windows application development system.
Visual Basic supports the basic principle of object-oriented design.
Compartmentalize different aspects of the application as objects and develop and
test them independently.
.
SQL Server
Microsoft SQL Server 2005 is a set of components that work together to meet the data storage and analysis needs of the largest web sites and enterprise data processing system.The topic in SQL Server Architecture describe how the various components work together to manage data effectively
FEATURES OF SQL SERVER 2005
Enterprise-Level Database Features
The SQL Server 2000 relational database engine supports the features required to support demanding data processing environments. The database engine protects data integrity while minimizing the overhead of managing thousands of users concurrently modifying the database. SQL Server 2000 distributed queries have been plugged into the .net allow you to reference data from multiple sources as if it were a part of a SQL Server 2000 database, while at the same time, the distributed transaction support protects the integrity of any updates of the distribute data. Replication allows you to also maintain multiple copies of data, while ensuring that the separate copies remain synchronized.
Internet Integration
The SQL Server 2005 database engine includes integrated XML support.It also has the scalability,availability and security features required to operate as data storage component of the largest Web sites.The SQL Server 2005 programming model is integrated with the Windows DNA architecture for developing Web applications, and SQL Server 2005 supports features such as English Query and the Microsoft Search Service to incorporate userfriendly queries and powerful search capabilities in Web application.
Data warehousing
SQl Server 2005 includes tools for extracting and analyzing summary data for online analytical processing.SQL Server also includes tools for visually designing databases and analyzing data using English-based questions.
DATA FLOW DIAGRAM
The data flow diagrams were first developed by Larry Constantine as a way of expressing system requirements in a graphical form: this led to a modular design. A DFD, also known as a “Bubble chart”, has the purpose of clarifying system requirements and identifying major transformation that will become programs in system design. A DFDconsists of a sequence of bubbles joined by lines. The bubbles represent data transformation and the line represent the data flow in systems.
Several rules are used in drawing DFDS.
. Process should be named and numbered.Each should be representative of the
process.
The direction if flow is from top to bottom and from left to right.
When a process is exploded into lower level details,they are numbered.
The names of data stores ,source , and destinations shoulb be written in capital letters.
[attachment=64983]
INTRODUCTION
The age in which we live is quite different from our parents or any other generations.It is characterized by rapid changes in technology,life style and values that at times difficult comprehend from average individuals,any sufficient advanced new technology is basically undistinguishable from magic.
The selected topic is “ELECTRONIC SHOP MANAGEMENT SYSTEM”.It provides information about item details,purchase details,staff details,branch details,booking details etc.The project efficiently handles all the operations in an Electronic shop. Such as management of purchase,sales,branch,bill etc.The advantage of our project is it is easy to use,user friendly,time saving etc.
It is a Data base project.The proposed system is developed in Visual Basic 6.0.
SQL Server is the back end
SYSTEM ANALYSIS
System analysis is the process of gathering and interpreting facts, diagnosing problems and using the facts to improve the system. Analysis is a detailed study of various operations performed by a system and their relationship within and outside of the system. This involves gathering information and using structured tools for analysis
ABOUT THE EXISTING SYSTEM
In the various shops the item details,sales details etc are kept as manual records.so It is very difficult to maintain the data,a number of registers are needed there is a chance of loss of data.At the same time doesnot provide security of data.If we want to get the details of a particular product or sale we have to search the entire record.Item details as well as bill details are stored separately in different registers,so if a person wants to know the details, he has to refer a number of registers, sometimes there is a chance of data inconsistency, and data redundancy.
Computerization reduces the communication gap because anything is programmed as per schedule and omission of information is not possible at all
DISADVANTAGES OF THE EXISTING SYSTEM
The existing system has some limitations that can be said as follows:
The existing system is manual and time consuming.
A number of registers, books etc are used which need huge storage space.
Retrieval of information in time is impossible.
Lacks of security.
PROPOSED SYSTEM
Taking into account the shortcoming of the existing system, a new computerized system was proposed with Visual Basic 6.0 as front end and SQL server as back end. High speed and ease of use are the main features of the proposed system.
The proposed system allows acceptance of details of each item and to store it in a datbase.It prevents unauthorized access.By using the system we can record the item details,bill details,staff details,branch details,booking details etc.
Using the system we can easily search the details of particular purchase.. We are providing the help facility for accessing in a user-friendly manner.
Its make possible by just clicking on the required buttons that are displayed on the screen. Separate forms have been designed for each of these options presented on the screen. These are specific and easy to understand.
ADVANTAGES OF PROPOSED SYSTEM
The various advantages can be summarized as follows:
Through this system,automatic updating, , editing, searching of records are made possible.
Data redundancy is avoided as compared to manual system.
Greater efficiency reduced the time taken to process the work and makes less susceptible to errors.
Easy in handling data and provides timely reports.
The system is user friendly.
Data manipulation is more reliable and accurate.
Better security is provided.
Enables to view large volume of data in shorts time.
Visual Basic 6.0
VB is Visual Design Environment, designing from that makes up user interface, adding codes to the forms and objects such as buttons, textboxes, labels and required support code in adding modules. It is a higher performance, highly integrated development environment that allows creating, building and debugging and debugging window applications faster and easier than ever before. It is a graphical user interface. Online help is also available.
VB has become a popular environment due to the following features:
Visual Basic application is event driven, which means that the user is in control of the application.
Visual Basic application is a complete windows application development system.
Visual Basic supports the basic principle of object-oriented design.
Compartmentalize different aspects of the application as objects and develop and
test them independently.
.
SQL Server
Microsoft SQL Server 2005 is a set of components that work together to meet the data storage and analysis needs of the largest web sites and enterprise data processing system.The topic in SQL Server Architecture describe how the various components work together to manage data effectively
FEATURES OF SQL SERVER 2005
Enterprise-Level Database Features
The SQL Server 2000 relational database engine supports the features required to support demanding data processing environments. The database engine protects data integrity while minimizing the overhead of managing thousands of users concurrently modifying the database. SQL Server 2000 distributed queries have been plugged into the .net allow you to reference data from multiple sources as if it were a part of a SQL Server 2000 database, while at the same time, the distributed transaction support protects the integrity of any updates of the distribute data. Replication allows you to also maintain multiple copies of data, while ensuring that the separate copies remain synchronized.
Internet Integration
The SQL Server 2005 database engine includes integrated XML support.It also has the scalability,availability and security features required to operate as data storage component of the largest Web sites.The SQL Server 2005 programming model is integrated with the Windows DNA architecture for developing Web applications, and SQL Server 2005 supports features such as English Query and the Microsoft Search Service to incorporate userfriendly queries and powerful search capabilities in Web application.
Data warehousing
SQl Server 2005 includes tools for extracting and analyzing summary data for online analytical processing.SQL Server also includes tools for visually designing databases and analyzing data using English-based questions.
DATA FLOW DIAGRAM
The data flow diagrams were first developed by Larry Constantine as a way of expressing system requirements in a graphical form: this led to a modular design. A DFD, also known as a “Bubble chart”, has the purpose of clarifying system requirements and identifying major transformation that will become programs in system design. A DFDconsists of a sequence of bubbles joined by lines. The bubbles represent data transformation and the line represent the data flow in systems.
Several rules are used in drawing DFDS.
. Process should be named and numbered.Each should be representative of the
process.
The direction if flow is from top to bottom and from left to right.
When a process is exploded into lower level details,they are numbered.
The names of data stores ,source , and destinations shoulb be written in capital letters.