Billing System - Spogel.com

1 International School of Informatics and management, JaipurBilling SystemSynopsisTEAM GROUP - 04 TEAM MEMBERS -ANIL KUMAR ANJANA -BHAIYA LAL ANJANA -SAURABH JAINPROJECT GUIDE - Ms JYOTI KHURANA (Lecturer of MCA)Table Content1)Introduction2)Objective3)Projec t category4)Types of Reports5)Technologies and tools6)Hardware7)Future scope8) Analysis of Present System9)Problem of Existing System10)Characteristic of Proposed System11)Feasibility for Feasibility Perspective12)Data flow diagram13)Entity Relation Diagram14)Data tables15)Flow chart16)Input forms17)Conclusion 1. IntroductionThe project Billing System is an application to automate the process of orderingand Billing of a Departmental store.

2 This web based application is designed consideringthe chain of departmental store which is located in various cities. This application alsoadministrates its users and This project will serve the following objectives:-1 Add and maintain records of available and maintain customer and maintain description of new and maintain new entered category of economic/financial reports to the owner monthly or weekly a convenient solution of Billing an easy to use environment for users and Project category RDBMS:The project is based on the concept of RDBMS ( Relational DatabaseManagement System ).

3 A database which store data in the form of tables which has related with each other in asparticular manner . of reports Sales Customer Product Date Report (Report of a particular Day) Report and Tools1 Web Technology: (Microsoft visual studio 2005 framework )2 Database: MySQL Server-2005 3 Development Tool: MS Visual Studio 20054 Web Server: IIS5 Web browser.

4 Internet Explorer service pack 16 Languages Used: C#.net, JavaScript7 Others: Themes, CPU configuration- AMD processors 4000+ series- RAM 1 GB DDR2 Monitor -17 colorOperating System -Windows XP with service pack Scope 1 This project will help the store keeper in fast billing2 This project enable store keeper to maintain a great database of allcustomers visited and purchase product from will enable to see report regarding product and to maintain in future OF PRESENT SYSTEMB efore we begin a new System it is important to study the System that will beimproved or replaced (if there is one).

5 We need to analyze how this systemuses hardware, software, network and the people resources to convert dataresources, such as transaction data, into information products, such asreports and displays. Thus we should document how the information systemactivities of input, processing, output, storage and control are OF EXISTING SYSTEM1. Inability of modification of data:The managing of huge data effectively and efficiently for efficient results, storing the details of the consumersetc. in such a way that the database can be modified as not possible in the current user friendly: The existing System is not user friendly because the retrieval and storing of data is slow and data is not Difficulty in reports generating: Either no reports generating in acurrent System or they are generated with great difficulty reports taketime to generate in the current Manual operator control: Manual operator control is there and leadto a lot of chaos and Lot of paperwork.

6 Existing System requires lot of paper work andeven a small transaction require many papers fill. Moreover anyunnatural cause (such as fire in the organization) can destroy all data ofthe organization. Loss of even a single paper led to difficult situationbecause all the papers are Inability of sharing the data: Data cannot be shared in the existingsystem. This means that no two persons can use the same data inexisting System . Also the two departments in an organization cannotinteract with each other without the actual movement of No support in decision-making: Existing System does not supportmanagerial No support in strategic competitive advantage: Existing System donot support strategic competitive OF THE PROPOSED SYSTEM1.

7 Easiness in modification of data: The proposed System providesmanaging of huge data effectively and efficiently for efficient results,storing the details of the customers, employeesetc. in such a way thatthe database can be friendly: The proposed System is user friendly because theretrieval and storing of data is fast and data is maintained the graphical user interface is provided in the proposedsystem, which provides user to deal with the System very Reports are easily generated: Reports can be easily generated in aproposed System . So any type of reports can be generated in a proposedsystem, which helps the managers in a decisions-making activity.

8 4. Sharing the data is possible: Data can be shared in proposed means that two or more persons can use the same data in existingsystem provided that they have right to access that data. Also the twoor more departments in an organization can easily interact with eachother without the actual movement of No or very few paperwork: The proposed System either does notrequire paper work or very few paper works is required. All the data isfeted into the computer immediately and various bills and reports can begenerated through computers. Since all the data is kept in a database nodata of the organization can be destroyed.

9 Moreover work becomes veryeasy because there is no need to keep data on Support strategic competitive advantage: Proposed System supportsstrategic competitive advantages. Since the proposed systems provideeasiness in reports generating it will provide strategic advantages Computer operator control: Computer operator control will be thereno errors. Moreover storing and retrieving of information is easy. Sowork can be done speedily and in ANALYSIST itle: Feasibility report for the computerization of the various activities ofthe : The Company facing the problem of inconsistent and out of time information in its activities.

10 Very much time is consuming for reportgeneration, which is not very helpful for decision making. So we want asystem, which provide immediate of study: The analysis procedure comprised of field trips in thevarious departments of the company. The following documents and sourceswere looked up: The purchase order that contain items to be purchased. The accounts register. Purchase order issues to vendors. Bills receive from vendors. Bills give to the customers. Purchase return forms (if any ) give to FOR FEASIBILITY STUDYThe feasibility study is carried out to test whether the proposed System isworth being implemented.