11-11-2016, 11:44 AM
1469512951-AutomobileManagementSystemProjectreport1.doc (Size: 2.46 MB / Downloads: 5)
Introduction of Project
This is a software which can be used by a automobile center for keeping the records of items which is to be transacted for purchase and sell. It helps to keep a record of all the transactions and a password login is created for security.
In proposed system we do not have to maintain everything manually. Throught this system if any transaction occurs it is corresponding entries is done automatically because database management system gives facility of having relationship between the table.
In proposed system we do not have to maintain different accounting books.
Advantages of proposed System
Easy to generate report for any transaction.
It is very much faster than manual system.
Easy and fastest record finding technique.
It is very much flexible to work.
Man power required is very less.
Data can be stored for a longer period.
Abstract
In manual system we have to maintain accounting Books, bills etc. In manual system we make four entries for any one transaction in different books. Then we prepare the cash book. And book advantage and disadvantage of manual system is list below:-
Advantage :-1) There is no requirement of power.
Disadvantage:-1) Difficult to maintain accounting and Transaction books.
2) Difficult to generate a report.
3) It is very much time consuming.
4) Difficult to search a record
5) Data may not be perfect human error.
Automobile system deals with the purchase and sales of the good and maintains the stock. It contains various forms and reports with different function. It has the menus created for different forms and reports. When you click the menu, It opens the related forms about the customer, vendor, Items and Transaction.
OBJECTIVES
Easy to generate report for any transaction.
It is very much faster than manual system.
Easy and fastest record finding technique.
It is very much flexible to work.
Man power required is very less.
Data can be stored for a longer record.
SYSTEM REQUIREMENT
Hardware requirement:-
This software requires following minimum hardware configuration:
Processor: Pentium-iii
RAM: 256 MB
Hard Disk: 4.3GB
Floppy Disk: 1.44 MB
CD Drive
Monitor-15” Color Monitor
Software Requirement:-
Microsoft Visual Basic 6.0
Oracle 8i
TECHNOLOGIES USED
Visual Basic 6.0
Oracle 8i
Visual Basic 6.0:-
Visual Basic syntax ideally suited for producing windows application. Ms Word, Ms Access and Ms PowerPoint all share Visual Basic for application, the exact same language syntax in Visual Basic-6.0.
What is to Visual Basic? “Visual” part reflects to the method used to create the graphical user interface. Rather than writing numerous lines of codes to describe the appearance and to location of interface elements, we simply add pre-built object into place on screen.
The “Basic” part refers to the BASIC language, a language used by more programmers then any other language in the history of computing. Visual Basic has evolved from the original BASIC language and how contains several tools, objects, functions etc. We can apply GUI animation. Beginners can create useful application by learning just a few of the language.
Visual Basic continues the tradition of simple, powerful And easy to learn a language yet adds enough extended capabilities to satisfy the most jaded developer.
Several significant facts contribute to Visual Basic is bright future. First, Visual Basic is huge product. Millions of developers of all skills levels are producing application with Visual Basic. Secondly, Visual Basic is powerful development system. It contains built-in functions to its intrinsic feature Visual Basic provides the object that can be loaded at run time or bound the distributable application. Thirdly, Visual Basic also well supported by third party products. Microsoft is indisputably the largest and most successful company in the world.
In contrast to the absolute system of the past, Visual Basic has an undesirably bright and shining future.
Whether your goal is to create a small utility for yourself or your work group, a large enterprise-wide system or even distributed applications spanning the globe via the tools Internet, Visual Basic has the tools we need.
Oracle 8i:-
Basic concept of database
A database is coherent collection of data with some inherent meaning, built and populated with data for a specific purpose.
Database stores data that is useful to us. This data is only a part of entire data available in the world around us.
To be able to successfully design and maintain databases we have to do the following:
1. Identify which part of the world’s data is of interest to us.
2. Identify what specific objects in that part of the world’s data are Of interest to us.
So from above, we come to know that the objects, their attributes and their relationship between them are of interest to us are stored in the databases that is designed,
built and populated with data for a specific purpose.
CHARACTERISTICS OF A
DATABASE MANAGEMENT SYSTEM:
It represents complex relationships between data.
Keeps a tight control of data redundancy.
Enforces user-defined rules to ensure the integrity of table data.
Has a centralized data dictionary for the storage of information pertaining to data and its manipulation.
Ensures data access authorization.
Have automatic, intelligent backup and recovery procedures for data.
Have different interfaces via which users can manipulate data.
TOOLS OF ORACLE
Oracle is kernel package that has a number of tools, these tools allow the programmer to create database objects, forms and reports, graphs etc. These are as follows:
SQL*PLUS:-
SQL*PLUS is made up of distinct parts. Interactive SQL is designed to create access and maintain all data structures. Like tables, index etc. It can also be used for interactive data manipulation.
PL/SQL:-
PL/SQL is used to create programs for validation and manipulation of table data. PL/SQL adds to the power interactive SQL and provides the user with all facilities of a standard, Modern Day programming environment.
ORACLE FORMS:-
This tools is used to create a data entry screen along with suitable menu Objects. It handles data gathering and data validation in a commercial application.
REPORT WRITER:-
Report Writer allows programmers to prepare innovative reports using data from the oracle structure like tables, Views etc.
ORACLE GRAPHICS:-
Oracle graphics tools is used to prepare graphs using data from oracle structure like table, views etc. It is part of commercial application.
FEASIBILITY STUDY
A feasibility analysis is undertaken to determine the possibility or probability of either improving the existing system or developing a completely new system.
It helps to obtain an overview of the problem and to get rough assessment of whether feasible solution exists.
There are three aspects in feasibility study portion of the preliminary investigation.
1) Operational feasibility
2) Technical feasibility
3) Economical feasibility
Operational feasibility :-
It is a measure of how well a proposed system solves the problems, and takes advantages of the opportunities identified during scope definition and how it satisfies the requirements identified in the requirements analysis phase of system development.
Operational feasibility covers two aspects. One is the technical performance aspect and other is the acceptance within the organization. Operational feasibility determines how the proposed system will fit the current operations and what, if any job restructuring and retraining may be needed to implement the system.
In the system operational feasibility checks, whether the user who is going to use the system is able to work with the software with which the system id coded and also the mind of the user going to use system. If the user does not understand or is able to work on the system further development is waste.
The system is easy to learn and it will require a vary short time to learn the operation of the system for a person having knowledge in accounting. So that system was operationally feasible
Technical feasibility :-
This involves questions such as whether the technology needed for the system exists, how difficult it will be to build, and whether the firm has enough experience using that technology. The assessment is based on an outline design of system requirements in terms of Input, Processes, Output, Fields, Programs, and Procedures. This can be quantified in terms of volumes of data, trends, frequency of updating, etc. in order to estimate whether the new system will perform adequately or not.
The technical feasibility in the proposed system deals with the technology used in the system. It deals with the hardware and software used in the system whether they are of latest technology or not. It happens that after a system is prepared a new technology arises and the user wants the system based on that technology. Thus it is important to check the system to be technically feasible.
The minimum memory requirement is 32MB of RAM while 64MB is better to have for better performance. As far as software is concerned, Oracle 8i and Visual Basic
6.0(Professional Version) should be installed on the server. There should be printer attached for printing bills, purchase receipt, sales receipts and other reports.
Economic feasibility :-
Economic analysis is the most frequently used method for evaluating the effectiveness of a new system. More commonly known as cost/benefit analysis, the procedure is to determine the benefits and savings that are expected from a candidate system and compare them with costs. If benefits outweigh costs, then the decision is made to design and implement the system.
Implementation of this system will be a lifetime investment, which will ensure returns to the store of good services and market value throughout the future. So the system is found economically feasible.
SYSTEM REQUIREMENT SPECIFICATION
Introduction:
A System Requirements Specification (SRS) is a document where the requirements of a system that is planned to be developed are listed.
(a)Background:-
This project provides master data, and after entering the data, whenever required the same is found automatically and displayed on the program entry is made manually showing uniqueness of products and company so, they can differentiate every thing. This provides the facility showing detail of company product by selecting a particular record. This project retrieves the data on selecting the name of particular product. This project provides the facility which shows the stock & transaction just by clicking so we check that which item has less. There is requirement of some reports like daily selling, items under minimum stock…etc. during the run time of system if user has input any wrong data or some error is occurred then system inform his/her. Security also should be there so that no other person can any type of changes in selling, stock or transaction because it is all very confidential matter.
Also, the system should be user friendly and Window based so that no specialized and extensive learning is required. Simple knowledge of the Computer is sufficient for operating the system successfully.
b) Abstract:-
In manual system we have to maintain accounting Books, bills etc. In manual system we make four entries for any one transaction in different books. Then we prepare the cash book. And book advantage is no requirement of power and disadvantage is Difficult to maintain accounting and Transaction books and Difficult to generate a report.
Automobile system deals with the purchase and sales of the good and maintains the stock. It contains various forms and reports with different function. It has the menus created for different forms and reports. When you click the menu, It opens the related forms about the customer, vendor, Items and Transaction.
Constraints:-
This software must be run in the windows platform.
This software also run on that pc which has vb 6.0 & oracle 8i programming and database languages.
Product details will be not accepted then may be any data is missing.