A PROJECT REPORT
ON
“Life Insurance Management System”
Project report submitted in partial fulfilment of the
requirement for the award of the degree of V Semester
BACHELOR OF COMPUTER APPLICATION
Prescribed By
Bangalore University
Submitted By:
Kajal Kumari : 17AGSB7034
Nuzhath Jahan: : 17AGSB7061
Chandana MB : 17AGSB7019
UNDER THE GUIDANCE OF
Mrs Bhavana Ashok
Lecturer, Department of Computer Science
Department of Computer Science
DEPARTMENT OF COMPUTER SCIENCE
B.M.S COLLEGE FOR WOMEN
NAAC RE-ACCREDITED 'A' GRADE COLLEGE
Bugle Rock Road, Basavangudi, Bangalore – 560004
B.M.S COLLEGE FOR WOMEN
NAAC RE-ACCREDITED ‘A’ GRAGE COLLEGE
DEPARTMENT OF COMPUTER SCIENCE
Bugle Rock Road, Basavangudi, Bangalore -560004
CERTIFICATE
This is to certify that Kajal Kumari, Nuzhath Jahan, Chandana M.B have satisfactorily
completed the project entitled “Life insurance management system” in partial fulfilment of the
requirement for the award of degree of V Semester B.C.A (Bachelor of Computer Application) as
per curriculum of Bangalore University for the period July-December 2019.
Signature of Guide Head of the Department
Mrs.Bhavana Ashok Mrs. Nalini L
Signature of Examiners:
1)
2)
Examination Centre: B.M.S COLLEGE FOR WOMEN
Date of Examination:
ACKNOWLEGDEMENT
We would like to thank our Teachers Mrs.Bhavana Ashok for giving timely and valuable guidance
during successful completion of this project.
She has been a constant source of inspiration, motivation for hard work and very co-operative
throughout this project work. Through this column, it could be our utmost pleasure to express our
warm thanks to her for encouragement, co-operation and consent without which we might not be able
to accomplish this project. We also thank to all the staff members who were directly and indirectly
helped us throughout the project.
This project has been a new learning experience, which will stand worthy for us in years to come. We
would also like to thank our Principle Dr. N.Nanda and all the Teachers and staff in-charge of the lab
that provided with the facilities and allotted slots to work in the lab. We would also like to thank out
colleagues whose constructive criticism kept us alert.
Finally we would like to thank all individuals directly &indirectly related to our project.
Kajal Kumari
Nuzhath Jahan
Chandana M.B
DECLARATION
We Kajal Kumari, Nuzhath Jahan and Chandana M.B hereby declare that the project work entitled
“Life insurance management system” submitted to the BANGALORE UNIVERSITY is a record of
original work done by us under the guidance of Mrs.Bhavana Ashok. This project is submitted in the
partial fulfilled of the requirements for the award of degree of Bachelors of Computer Application in
Computer Science.
Kajal kumari,
Nuzhath Jahan.
Chandana M.B
INDEX
SL.NO CONTENTS PG.NO
1. ABSTRACT 1
2. INTRODUCTION 2
3. REQUIREMENTS
Functional Requirement 3
Non-Functional Requirement 4
System Requirement 5
4. SYSTEM DESCRIPTION
Modules 6
About Visual Basic 6.0 8
About SQL 2008 9
5. SYSTEM DESIGN
Flow Chart 10
Data Flow Diagrams 11
ER Diagram 14
Table Designs 15
6. SAMPLE CODING 17
7. TESTING 23
8. SCREENSHOTS 27
9. CONCLUSION 37
10. FUTURE ENHANCEMENT 38
11. BIBLIOGRAPHY 39
ABSTRACT
To implement an efficient framework for managing the insurance company and client information.
To manage every client insurance policies details and the cash payment for insuring by client.
To manage every branches of insurance and its belonging people who took insurance policy in the
insurance company. To evaluate the client behaviour and their insurance process for their policy. Our
proposed application will create automation system for managing the insurance company client
information which will be robust against the human intervention.
FUNCTIONAL REQUIREMENTS
SYSTEM REQUIREMENTS
Software Requirements:
Frontend: Visual Basic 6.0
Backend: SQL Server 2008
Hardware Requirements:
Processor: Intel Core tm i3 CPU 2gHz
RAM: 4.00GB
Input device: Keyboard and mouse
ABOUT VISUAL BASIC 6.0
Visual basic is one of the most popular programming languages on the market today. Microsoft has
positioned it to fit multiple purposes in development. The language ranges from lightweight visual basics
programming, to application specific, and finally, full fledges enterprise development with visual basic
6.0.
Features of visual basic 6.0
Visual basic 6.0 has many powerful features that are required in today’s programming world, which
includes features from the previous version.
Some of the features are:
1. Based on the basic language.
2. A common programming platform across all Microsoft office application-almost all
Microsoft application support visual basic 6.0 by sharing and reusing the code across
application.
3. Data access- key addition for helping programmers, builds database application in support
ActiveX data object, Microsoft’s new data access technology. Development tools include a
SQL editor, data environment for developing data objects and report design.
4. 32 bit support:-visual basic supports 32-bit applications.
5. Object type: New object types, called file system objects or FSO, has been added to visual
basic 6.0. These objects enable you to work faster and more easily with files and
directories.
6. Functions:- There are fourteen additional functions in visual basic 6.0 all of them deal with
string data. Some of them are: Call by name, filter and format currency, format number and
per cent.
7. Database enhancement:- Earlier version on visual basic used Data Access Object(DAO) and
Remote Data Objects(RDO) and to create database and front-end applications for the most
popular database formats. You can share visual basic code that uses data access objects with
other application that use Microsoft DAO.
8. Quick editing, testing and debugging:- The visual basic development environment includes
extensive editing and debugging tools.
9. Internet features:- What may be the most significant new functionality is the ability to
create both server and client side internet application.
10. New and updated controls:- Microsoft continues its legacy of creating and enhancing
controls supporting rapid application development.
11. Component creation:- Visual basic continues to emerge as a world class development tool
for creating and working with component ranging ActiveX controls to integration with
Microsoft’s transaction server.
12. Language features:- True to the long tradition of visual basic there have been many
languages enhancements that make working with strings, numbers and objects even easier
and more powerful.
ABOUT SQL SERVER 2008
SQL Server 2008 Express Edition is a free, easy-to-use, lightweight, and embeddable version of SQL
Server 2008. Free to download, free to redistribute, free to embed, and easy for new developers to use
immediately.
SQL Server 2008 Express Edition has the following benefits:
Fast to download and install: It's a compact download, and you can get up and running in as little
as 20 minutes.
Simplified administration: Automatically tune your database for optimal performance. For
convenience, you can use Microsoft Update to automatically receive the latest patches and updates,
enabling a high level of security and the latest features.
Free management tool: SQL Server Management Studio: You can download the SQL Server
Management Studio Express, an easy and efficient management tool for SQL Server Express. With
SQL Server Management Studio you enjoy a consistent management experience across all SQL
Server 2008 Editions.
Seamless integration with Visual Studio Express Editions.
Easy to deploy: Easily move or copy your SQL Server Express databases to another computer
MODULES
List of modules incorporate with Life Insurance management system is
Login
Client login
Management login
Registrations
Evaluation
Policies
Data flow diagram for Life insurance management system
Process- It tells the process state in a project.
Data Flow-It tells the flow of Data.
Source/Sink-It is the project source or sink.
Data Store- It stores the data in a particular file.
Relationship-It shows the relationship between function
units.
USER LOGIN
NAME DATATYPE DESCRIPTION
CLIENTNO INTEGER CLIENT NUMBER
PASSWORD INTEGER PASSWORD
REGISTRATION
NAME DATATYPE DESCRIPTION
ADDRESS VARCHAR(50) ADDRESS
AGE INTEGER AGE
DOB DATE DATE OF BIRTH
NAME VARCHAR(50) CLIENT NAME
EMAIL VARCHAR(20) EMAIL ID
CLIENTNO INTEGER CLIENT NUMBER
POLICY
NAME DATATYPE DESCRIPTION
CLIENTNO INTEGER CLIENT NUMBER
ADDRESS VARCHAR(50) ADDRESS
AGE INTEGER AGE
DOB DATE DATE OF BIRTH
NAME VARCHAR(50) CLIENT NAME
POLICYTYPE VARCHAR(10) POLICY TYPE
EMAIL VARCHAR(20) EMAIL ID
TESTING
Testing performs a very crucial role for quality assurance and for ensuring the reliability
of the software developed.
Testing is the phase where errors from the earlier phases must be detected. It is the first
step in revealing the errors in a program. The success of the testing for the errors in the
program depends critically on the test cases. The use of testing is not limited to the testing
phase alone. The result of testing is used later in maintenance also.
LEVELS OF TESTING
Verification is done on the output of each phase , but still faults are likely to remain
undetected . These faults will be eventually in the code. Testing isrelied upon to detect these
faults. For this , different levels of testing are used , which tests the different aspects of the
system.
The basic levels of Testing are:
Unit Testing
Integrated Testing
System Testing
UNIT TESTING
Unit testing is the first level of testing. It is the dynamic methods for the verification where
the program is actually compiled and executed. Unit Testing focuses on verification effort
of the software design. Using the detail design description as a guide , important control
paths are tested to uncover error within the boundary of the module. The goal of Unit
Testing is to test modules or "Units" and not the entire software system.
INTEGRATION TESTING
The next level of Testing is called Integration Testing. In this level many tested modules are
combined into sub - systems which are then tested. This is done to detect design errors. This
level of Testing emphasizes on the testing of the interfaces between the modules.
SYSTEM TESTING
The third level of testing is the system testing. When the system is put together, system testing is
done. In this, the system is used to see if all the requirements are met and whether it
performs as per the requirements
CONCLUSIONS
The system “life insurance management system” deals with the registration and processing of the client.
This system has been developed to satisfy the entire proposed requirement. The process of recording
details about policy, client is more simple and easy.
User friendly is the unique feature of the system. The system generates the report as and when required.
FUTURE ENHANCEMENT
We can update this software as official software.
The main advantage of this software is that there will be no loss in the user’s information.
Databases are easily handled so that there is no ambiguity.
Helps to maintain good record.
BIBLIOGRAPHY
www.StackOverFlow.com
www.Msdn.com
www.w3schools.com
www.NIIT.NET Project Guide
www.NIITADO.NetStudentReference
