LIC AGENT MANAGEMENT

Yash Life
Insurance

…..INDEX…..

1. Preface…………………………………………………………
2. Acknowledgement…………………………………………....
3. Software & Hardware Requirement………………………...

4. Software Development Life Cycle……………………………

5. About Visual basic……………………………………………
6. about Oracle …..……………………………………………..
7. About This Project…………………………………………..
8. Documentation Part…………………………………………
9. Chart…………………………………………………………..
10. Diagram……………………………………………………..
11. Structure of Table………………………………………….
12. Design……………………………………………………….
13. Coding……………………………………………………….
14. Report……………………………………………………….
15. Grid………………………………………………………….
16. Testing………………………………………………………
17. Conclusion…………………………………………………..
 LIC AGENT MANAGEMENT
Yash Life
Insurance

18. Bibliography………………………………………………...

1. PREFACE

The project training in a student’s life is like a live experience in

the industry. So it is very essential part of the educational qualification.
Bachelor of Computer Application is the course offering me a unique
change to find the place of utilizing computer in meaningful way. It
provides me all the theoretical aspects with knowledge.

The project training in the 5th semester of the course gives me

the exposure to the real world. The aim of project training, by
understanding a live project, is to have practical experience of the real
world. It also clears the picture of practical field to prompt the students to
develop their qualities talents, etc. so that I can expand our view about the
implications of the theoretical knowledge in the practical field. We had the
opportunity for the same at various LIC Agents. The period of the trainings
would be around one and half month.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

3(I). SOFTWARE REQUIREMENT

 Minimum 64 mb RAM

 CD ROM drive

 Windows 98 & onwards

 Visual basic 6.0

 Oracle plus 8.0

3(ii). HARDWARE REQUIREMENT

 Pentium-III processor 550 MHZ or above

 Minimum 2 GB Hard disk

 Mouse, Keyboard

 Color Printer
 LIC AGENT MANAGEMENT
Yash Life
Insurance

4. SOFTWARE DEVELOP LIFE CYCLE

 Feasibility Study:-
An important outcome of the preliminary investigation is the
determination that the system requested is feasible or not. There are three
aspects of feasibility study.
Here an estimate is made of whether the identified user needs may be
satisfied using current software and hardware technologies. A feasibility
study should be relatively cheap and quick. The result should inform the
decision of whether to go ahead with a more detailed analysis.

The feasibility study is not a full-fledged system study. Rather, the

feasibility study is used to gather broad data to make a decision on whether
to proceed with system study. System project feasibility is assessed in three
principal ways.

1. Technical Feasibility:
2. Economical Feasibility:
3. Operational Feasibility:

1. Technical Feasibility:
The capability of the server was found sufficient in terms of
memory requirement.
After considering the data processing requirements and the
degree of scalability required by the organization, we have decided to
use as the Visual basic 6.0 front end development tool and Oracle plus
8.0 as the back end database for the system.
So, in terms of H/W and S/W, the platform was good enough
to meet the necessity.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

2. Economical Feasibility:
The cost involved in designing and developing a system should
be a good investment for the organization as it is internal application
used by the organization. The financial and economic issues raised
during preliminary investigation are answered below. The cost of
conducting full system investigation is justified since the system
development is in house.
No extra cost for the modification or addition of software and
hardware is required. So the proposed system is economically feasible.

3. Operational Feasibility:
Any project proposed can be beneficial only if it satisfies the
organization requirements. In any mature system setup, a new system
not needs to robust but also needs to communicate and work in
tandem with the other existing system.
The operational feasibility asks if the system will work when it
is developed and installed. The proposed system makes best efforts to
satisfy the requirement of both users and the customer keeping in
mind some infrastructure constraints. Developed system will provide
the adequate throughput and all necessary information to end-users.

 Requirements analysis and specification:-

The goal of the requirement analysis and specification phases to

clearly understand the exact requirement of customer and to
systematically organize these requirements into a specific document.

Requirement analysis involve obtaining a clear and through

understanding of the developed, with view to removing all
 LIC AGENT MANAGEMENT
Yash Life
Insurance

ambiguities and inconsistencies from the initial client perception of

the problem.

 Software Requirement Specification:-

The SRS document product the end of the requirement

specification phase, is called Black box specification of the problem.
Since during this phase system is analyzed and documented as a black
box, whose external behavior is observed.

The SRS document must specify all functional and performance

requirements, the formats of inputs, outputs. And any required
standard to be followed, and all design constrains. These
requirements at this stage are written using the end user terminology.

 Maintenance:-

Correct errors that were not discovered during the product

development phase. This is called corrective maintenance.

Improving the implementation of the system and enhancing the

functionalities of the system according to the requirement.

Porting the software to a new environment, e.g. to a new

computer or a to new operating system.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

5. ABOUT VISUAL BASIC

The project that is written is followed a relatively new type of

programming called EVENT-DRIVEN PROGRAMMING.

Event driven programming describes an application that waits

for an event and responds to that event when they happen. All
windowing operating system require event driven programming
techniques.

Microsoft refers to VISUAL BASIC as an event driven

programming language, which has many element of an object oriented
language.

Following points differ VISUAL BASIC as event driven programming

from Procedural Programming.

 In event driven programming the operating system tells the program

what’s going on.

 Event Driven Programming is object oriented programming.

 It does not specify the exact sequence of all operation.

 This allows user to switch from one program to another at any time.

 It does not specify the exact sequence of all operation.

 Event Driven Programming is never programming language.

 LIC AGENT MANAGEMENT
Yash Life
Insurance

FEATURE OF VISUAL BASIC 6.0

 Visual basic syntax ideally suited via for producing windows

application.

 MS word, Ms power and Ms access point all share visual basic

application, the exact same language syntax in visual basic 6.0.

 Visual basic continuous the tradition of simple, powerful and easy to

learn language yet adds enough extended capabilities to satisfy the
most jaded developer.

 Microsoft is indisputably the largest and most successful software

company in word.

 For all this and many more, visual basic is indisputably the most
attractive development environment currently available.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

6. FEATURES OF ORACLE

 It supports very large memory.

 It provides most useful tools for software development.

 It is a DDL (Data Definition Language) as it supports insert, update,

delete etc. it is DCL (Data Control Language) as it supports commit,
save point, grant and revoke.

 It is a DQL (Data Query Language) as it supports select command.

 It provides high security of data.

 It is most suitable for back-end supports of database.

 It is provides relationship creation facility among two or more table.

How the database system is beneficial?

 Data independence.
 The amount of redundancy in the stored data can be reduced.
 No more inconsistencies.
 The store data can be shared.
 Data integrity is maintained.
 Security of data can be implemented.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

7. ABOUT THIS PROJECT

INTRODUCTION:-

It took us great to develop this software in visual basic as Front

end and Oracle 8.0 Back end Interface. This Software is duly tested on
different environment of hardware and software. The data Security of this
Software is great as the data stored in various tables with unreadable
characters.

This Software accepts various data such as LIC Client

information, Plan information, Personal detail of Client and his or her
relatives with Physical details of client also, etc. It also accepts data such
as various plans along with its various parameters such as minimum and
maximum amount with term and an amount of the insurance. Printing
Personal detail Report will display Policy date to maturity date
 LIC AGENT MANAGEMENT
Yash Life
Insurance

8. DOCUMENTATION

Documentation
is a means of communication; a written record or a phase of a specific
project; it establishes design and performance criteria for phase of the
project.

The different helps and instruction are prepared to help the

users and the operators.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

9. CHART

START

DESIGN

CODING

VALIDATION & TESTING

IMPLEMENTATION

FINISH
 LIC AGENT MANAGEMENT
Yash Life
Insurance

DIAGRAM

LOGIN
PHYSICAL AGENT
DETAIL DETAIL

PERSONAL PARTY
DETAIL DETAIL

SPLASH
SCREEN
COMISSION SCREEN NOMINEE
DETAIL DETAIL

PREMIUM BRANCH
DETAIL DETAIL

NEW PLAN
BUSINESS DETAIL
 LIC AGENT MANAGEMENT
Yash Life
Insurance

11. DATA DICTONARY

Overview of Data Dictionary:-

A data dictionary is a term for information that describes the data
that will be held in the data base. It is a collection description of the data
objects or items in a data model for the benefit of programmers and other
who needs to refer the system.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

SPLASH SCREEN
LIC AGENT MANAGEMENT
Yash Life
Insurance

LOGIN FORM
LIC AGENT MANAGEMENT
Yash Life
Insurance

MDI FORM
LIC AGENT MANAGEMENT
Yash Life
Insurance

AGENT DETAIL
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PARTY DETAIL
 LIC AGENT MANAGEMENT
Yash Life
Insurance

NOMINEE DETAIL
 LIC AGENT MANAGEMENT
Yash Life
Insurance

BRANCH DETAIL
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PLAN DETAIL
LIC AGENT MANAGEMENT
Yash Life
Insurance
 LIC AGENT MANAGEMENT
Yash Life
Insurance

NEW BUSINESS
 LIC AGENT MANAGEMENT
Yash Life
Insurance

COMISSION DETAIL
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PREMIUM POSTING
LIC AGENT MANAGEMENT
Yash Life
Insurance
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PERSONAL DETAIL
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PHYSICAL DETAIL
LIC AGENT MANAGEMENT
Yash Life
Insurance
 LIC AGENT MANAGEMENT
Yash Life
Insurance

AGENT REPORT
 LIC AGENT MANAGEMENT
Yash Life
Insurance

COMISSION REPORT
LIC AGENT MANAGEMENT
Yash Life
Insurance

BRANCH REPORT
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PERSONAL REPORT
 LIC AGENT MANAGEMENT
Yash Life
Insurance

BUSINESS REPORT
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PHYSICAL REPORT
LIC AGENT MANAGEMENT
Yash Life
Insurance

PLAN REPORT
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance

AGENT GRID
LIC AGENT MANAGEMENT
Yash Life
Insurance

BRANCH GRID
LIC AGENT MANAGEMENT
Yash Life
Insurance

PARTY GRID
LIC AGENT MANAGEMENT
Yash Life
Insurance

NOMINEE DETAIL
LIC AGENT MANAGEMENT
Yash Life
Insurance

PLAN GRID
LIC AGENT MANAGEMENT
Yash Life
Insurance

PREMIUM GRID
 LIC AGENT MANAGEMENT
Yash Life
Insurance

COMISSION GRID
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PERSONAL GRID
 LIC AGENT MANAGEMENT
Yash Life
Insurance

PHYSICAL GRID
 LIC AGENT MANAGEMENT
Yash Life
Insurance

16. TESTING

 Testing plan:
Philosophy behind testing is to find errors. Test cases are
devised with this purpose in mind. A test case is a set of data that a
system will process as normal input. However, the data are created
with the express intent of determining whether the system will
process them correctly.

9.2 Testing Strategy:

Software products are normally tested first at the individual

component (or unit) level (called unit testing), also referred to as
“Testing in the small”.
Then the components are slowly integrated and tested at each level of
integration is tested (called System Testing). Integration and system
testing are known as “Testing in large”.
Thus, a software product goes through two levels of testing:
A. Unit Testing
B. System Testing
In unit testing the analyst tests the programs making up a system. For
this reason, unit testing is sometimes called program testing. Unit
testing gives stress on the modules independently of one another, to
find errors. This helps the tester in detecting errors in coding and
logic that are contained within that module alone.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

Unit testing can be stared performed from the bottom up, starting
with smallest and lowest-level modules and proceeding one at a time.

The important and essential part of the system development phase,

after designing and developing the software is system testing. We
cannot say that every program or system design is perfect and because
of lack of communication between the user and designer, some error
is there in the software development.

System testing is an important function to the success of the system.

System testing makes a logical assumption that if all the parts of the
system are correct, the goal will be successfully activated. Another
reason for system testing is its utility as a user-oriented vehicle before
implementation.

9.3 Testing Methods:

1. White Box:
Also known as glass box, structural, clear box and open
box testing. A software testing techniques whereby explicit
knowledge of the internal workings of the item being tested are used
to select the test data.
It uses specific knowledge of programming code to examine
outputs. The test is accurate only if the tester knows what the
program is supposed to do. It is concerned with testing the software
product; it cannot guarantee that the complete specification has been
implemented.

2. Black Box:
Also known as functional testing. A software testing
technique whereby the internal workings of item being tested are not
known by the tester.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

17. CONCLUSION

This package has been able to successfully incorporate the entire

requirement as per the requirement of LIC client agent system. Appropriate
care has been taken during database design maintain database integrity and
to avoid redundancy of data. Validation is done instantaneously to avoid
data redundancy of data. The policy provided a safe future, saving etc.

Designing and developing this DBMS-project was an interesting

experience. It really helped me to understand the database concepts, which
are of great importance these days.

The addition, deletion and modification of various details for

various forms like plan guide, personal detail, relative details, new policy
are very a user friendly, simple and easy. It is aimed at overcoming the
shortcoming of manually operated system. The quality factors like:
correctness,reliability,efficienty,usability,testability,maintainability,portabi
lity,accuracy,errors,tolerance,expandability and communicatively are all
successfully met with. Validation certification was done to see that the
package conforms to standards.
 LIC AGENT MANAGEMENT
Yash Life
Insurance

18. BIBLIOGRAPHY

Fundamentals of database systems:-

By:-Elmasri and Navathe

Microsoft Visual Basic 6.0

By:-Evangels petrotenous

Visual Basic Black Book

By: - Steven Holzner
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance
LIC AGENT MANAGEMENT
Yash Life
Insurance