Project Thesis Of Lis
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Project Thesis Of Lis as PDF for free.
More details
- Words: 6,053
- Pages: 70
Life Insurance System Department Of Computer Science
A Thesis Submitted For the Degree Of Bachelor Of Science (Information Technology)
By Faiza Soomro
Government Girls Degree College Sukkur Affiliated with Shah Abdul Latif University Khairpur
Govt: Girls Degree College Sukkur
Department of computer science Certificate This is certified that we have read the report submitted by Faiza Soomro,It is my judgment that this report on “Life Insurance System” is of sufficient standard to warrant its acceptance by the department of computer science, Government Girls Degree College Sukkur for the degree of bachelor of computer science in partial fulfillments of the requirement of BS(IT).
___________________ External Shah Abdul Latif University
___________________ Supervisor Madam Naila Govt: Girls Degree College Sukkur
__________________ Principal Madam Azra Tabbasum Govt: Girls Degree College Sukkur
Govt: Girls Degree College Sukkur
Dedication We dedicate this sincere effort to grace Almighty ALLAH. We also dedicate this effort to our Holy Prophet Hazrat Muhammad (Peace Be upon Him) who is the messenger of love, harmony brotherhood and compression to the entire universe. We also dedicate to our respected parents. Both are helped us for making that project. We all thanks to Almighty ALLAH and parents. Our parents gave financial support to develop that project. All success of our bright achievement goes to our parents and the teachers. They always pray to ALLAH for our success in every walk of our lives.
Govt: Girls Degree College Sukkur
Abstract This thesis concerned with the system of Life Insurance. This software will support the officials to maintain a computerized data base management system to promote legal maintenance of customers in Insurance Corporation in future. This software solved many problems. In this world there are many soft wares of insurance to keeping records of consumers and manage it but insurance system software is our little struggle for betterment. This system provides information with accuracy, reliability and high speed. This software keep records of policy holders, there complete history from purchasing the policy to mature that policy. Calculate the premium and maturity.
Govt: Girls Degree College Sukkur
Acknowledgement All praises to Almighty ALLAH, The Rehman and Raheem and his last Messenger Hazarat Muhammad (Peace Be upon Him) who has been the greatest blessing to mankind. We have completed our project and have been able to present out final theses along with software as per requirement of BSIT degree under the honorable committee of the teachers and faculty in charge of Govt: Girls Degree College Sukkur. Finally, a special recognition and acknowledgements are due and are cordially rendered to our project supervisor Respected Madam Naila Wahab for her technical and moral support and timely guidance throughout this project. We also very thanks full to Sir Anwar Ali Subehapoto, who is the head of P&Gs department in State Life Insurance Corporation in Sukkur Zone, he provided us complete information and forms. Thanks to Sir Tanveer Ahmed who guided us about VB.net.
Govt: Girls Degree College Sukkur
Preface This system is concerned with the management of Life Insurance System. This system provides user interface and easy access of register of policy, finding records, agent information and calculation of premium and maturity. The entire work is presented in nine chapters.
Chapter 1 It provides the brief introduction to Life Insurance System. It also gives the detailed functions and fields of Insurance System.
Chapter 2 This chapter defines the goals and objectives of Life Insurance System.
Chapter 3 This chapter deals with the steps, followed from beginning to end of the software development process.
Chapter 4 This chapter is concerned with database architecture, ERD, tables and data dictionary.
Chapter 5 This chapter is concerned with the project specification for the system design. It discusses hardware, software assortment.
Chapter 6 This chapter deals with how code has been designed for this application.
Govt: Girls Degree College Sukkur
Chapter 7 This chapter concerned with testing process and debugging.
Chapter 8 This chapter describes how to run and use Life Insurance System software.
Chapter 9 This chapter includes the conclusion and future recommendation.
Govt: Girls Degree College Sukkur
Table of Contents Chapter 1 Project Description 1.1 1.2
1.3 1.4
Page No
Introduction………………………….…………………………….1 Terminology………………………………………………….........1 1.2.1 Policy Type……………………………………………...1 1.2.2 Policy Number…………………………………………..1 1.2.3 Term………………………………………………..........2 1.2.4 Table……………………………………………….........2 1.2.5 Code No……………………………………………........2 1.2.6 Sum Assured……………………………………….........2 Policy Registration………………………………………………...2 Benefits of Insurance System……………………………………...3
Chapter 2 Goals and Objectives 2.1 2.2
Objectives According to Staff Management………………………5 Objectives According to Policy Holder…………………………...5
Chapter 3 Software Process Model 3.1 3.2
3.3
Problem Definition………………………………………………...8 The Linear Sequential Model……………………………………...8 3.2.1 Analysis……………………………………………………..8 3.2.2 Designing…………………………………………………...8 3.2.2.1 Interface Design………………………………….9 3.2.2.2 Advantages of Interface Designing………………9 3.2.3 Coding………………………………………………….........9 Gantt Chart……………………………………………………….10
Page No Govt: Girls Degree College Sukkur
Chapter 4 Database architecture 4.1 4.2 4.3
4.4
Entities Relationship Diagram (ERD)……………………………..13 Normalization………………………………………………...........15 RDBMS……………………………………………………………15 4.3.1 Add new policy…..…………………………………………15 4.3.2 Policy Detail…………………………………………...........16 4.3.3 Receive Payments…………………………………………..17 4.3.4 Find Payments………………………………………………17 4.3.5 Add New……………………………………………………17 4.3.6 Pay Salary…………………………………………………...18 4.3.7 Premium ……………………………………………………18 4.3.8 Maturity………………………………………………..........19 Data Dictionary…………………………………………................19
Chapter 5 Project Requirement Specification 5.1
Requirement Specification………………………………...............25 5.1.1 Hardware Specification……………………………………..25 5.1.2 Software Specification……………………………...............25 5.1.2.1 Operating System Specification……...............25 5.1.2.2 Language Specification ……………………..25
Chapter 6 Interface Design 6.1
Administrator Forms application……………………………….....30 6.1.1 Events used in the forms……………………………............30 6.1.1.1 Main form……………………………………..30 6.1.1.2 Employees Form………………………............32 6.1.1.3 Policy Form……………………………...........33 6.1.1.4 Members Form………………………………..35 6.1.1.5 Display all member forms………………….....36 6.1.1.6 Find Forms…………………………...............37
Page No Govt: Girls Degree College Sukkur
Chapter 7 Testing 7.1 7.2
Testing…………………………………………………………..…38 Testing Strategy……………………………………………………38 7.2.1 Event Testing………………………………………..38 7.2.2 Black-box testing……………………………………38
Chapter 8 User Guide 8.1
How to run operator forms………………………………………..41
Chapter 9 Conclusion and Recommendations 9.1 9.2
Conclusions………………………………………………………..58 Future recommendations…………………………………………..58
Bibliography Referred Books Web sites Other Resources
Govt: Girls Degree College Sukkur
Chapter # 1
Project Specification
1.1 Introduction
Govt: Girls Degree College Sukkur
Life Insurance System is a management of complete centralized database. This system keeping the records of Policy holders, finding records, agent information, calculate premium and maturity and quote sheets. This system is consisting of two parts. o Data base o User Interface Data base Database is development environment where the entire database id developed and user can access it. User interface This part is concern with the easy control of system database by user. The insurance information consists of information relation to the operations of the insurance industry. Each policy holder is identified the policy Number, terms, tables (plans), and sum assured. Each policy holder’s record is keeping manually as well as in computer system.
1.2 Terminology There are some terminologies related with Insurance system. These are given below:
1.2.1 Policy Type Policy type is plan which is selected by policy holder. Policy plans have different values and benefits. Policy plans have different values by different age in rate book.
1.2.2 Policy Number Page 1 Chapter # 1
Project Specification
Policy Number is a 9 digit code which is given to policy holder after registration of that policy. Govt: Girls Degree College Sukkur
1.2.3 Term These are years which is decided by policy holder that how many years the policy will complete.
1.2.4 Table These are plans which are appeared in the shape of 2 digit codes in rate book. Policy holder choose plan according to there benefits. In Insurance corporations codes are applied in form not table name.
1.2.5 Code No This is code which is given to policy holder before registration of policy Number. This is also known as propodent number.
1.2.6 Sum assured This is amount which is decided by policy holder that how much amount the policy holder will pay during time period of policy.
1.3 Policy Registration Policy registration is a process which is performs by particular employee in corporation. This is manually process. First person is come in the new business department and get the form of purchasing policy. That officer gives complete guidance to customer. When form is going to complete then medical check up and tests will start. When all requirements are full fill by customer, the manually form give to the policy registration officer. He checks all requirement of policy holder and do calculate the values and premium and then registers the policy number. After this process the Page 2 Chapter # 1
Project Specification
Govt: Girls Degree College Sukkur
Policy of policy holder is done. A conformation latter send to the policy holder’s residential address.
1.4 Benefits of Insurance System. There are a lot of benefits to doing Life Insurance. Insurance policy is the financial support for the family when policy holder becomes death. There are many plans for many persons and there are different benefits of each plan. Policy holders purchase policy according to there benefits.
Page 3
Govt: Girls Degree College Sukkur
Chapter # 2
Goals And Objectives
2.1 Objectives According to Staff Management The objectives according to staff management of Life Insurance System.
Govt: Girls Degree College Sukkur
1. The staff members can easily manage all the policy members’ information up-to-date. 2. Management can get fast easy and accurate reports when it needs. 3. Management can also count the premium and maturity easily because the software is also having the capability to calculate premium automatically. 4. Management has also another advantage of manage the information of the agents that are working in the organization. 5. Management has all the transaction and records of all its employees and policy members. 6. If any one wants to get the form u can get it by using the printer. 7. All the information is highly secured and no one can be entered in the system without the administrator or authorized user.
2.2 Objectives according to policy holder The policy holders have also lots of benefits of using the Life Insurance System. 1. The main objective of according to the policy holder is that they can
be easily registered and they have no any need to wait for the registration. Page 5 Chapter # 2
Goals And Objectives
2. The policy holders have also advantage to see their data when ever they want and it is easy to search out any one’s information by using the Proposer Name or number.
Govt: Girls Degree College Sukkur
3. The Policy members have also advantage of calculations that can
be done fastly and accurately. 4. The policy members have no need to pay the payment to the agent
they can pay any where and they have to show the bill and the operator of the software can easily add the payment.
Page 6
Govt: Girls Degree College Sukkur
Chapter # 3
Software Process Model
3.1 Problem Definitions The Software that is developed using database is complicated but this is very user friendly database system. Transactions in the database can be easily done using this software. A window based application Linear Sequential Model. We has adopted a sequential model to develop the system. The linear sequential model suggests a systematic, sequential approach to software development that beings at the system level and progresses through.
Govt: Girls Degree College Sukkur
o o o o
Analysis Design Coding Testing
Analysis
Design
Coding
Testing
3.2 Linear Sequential Model 3.2.1 Analysis This part of the system is very important because we don’t have any knowledge about any transactions of the system that we are going to develop. The system Life Insurance System is not based on the network so we have no need of any extra hardware or network environment. Analysis focuses on “what to do?” analysis defines only the structure of subject and doesn’t consider its implementation. Analysis is the Software Process Model systematic approach to problem solving. As we have followed the “The Linear Sequential Model”, we implemented this phase too.
3.2.2 Designing Design is the first step in the development phase of any engineered
Page 8 Chapter # 3
Software Process Model
product or system. It is a process that provides the sufficient details to permit system’s physical realization. It is the process of applying various techniques and principles for the purpose of defining a system.
3.2.2.1 Interface Design The first step in the software designing is the Interface design. We have lot of problems that what should be the interface how to design a user friendly Govt: Girls Degree College Sukkur
interface finally we have some idea from the other software’s that how to develop it. Control and Design of Interface of the Application Forms. The forms are the classes that hold many objects they can be said the containers that hold deferent controls form is the key element of the system. Administrator form Simple Form MDI Form Menu. Menu is the drop down list of elements a user can easily access it. File Menu Policy Member Payment Employee Calculation Quote Sheet Help can easily access Buttons.
3.2.2.2 Advantages of Interface Designing The interface is the designed screen in any powerful language, to store, manipulate, access and retrieve data easily. This part of the system provides facilities to the users of the system. The interface of the Insurance System is designed in the most powerful language called Microsoft Visual Basic.Net 2005. The interface is the user-friendly environment that every one can use easily. The importance of good user interface design can be the difference between product acceptance and rejection in the marketplace. If end-users feel it is not easy to learn, not easy to use, or too cumbersome, an otherwise excellent product could fail. Good User Interface Design can make a product easy to understand and use, which results in greater user acceptance.
3.2.3 Coding Each class or form contains a lot of sub routines and functions according to its work the code is purely OOP supported we have used. o o o o
Namespaces Classes Objects Variables Page 9
Govt: Girls Degree College Sukkur
Project Time Scheduling S.NO
Activity
Estimated Duration Weeks
1
Problem Definition
3 weeks
2
Feasibility Phase
3Weeks
3
Analysis Phase
2 Weeks
4
Design Phase
3 Weeks
5
Coding Phase
4 Weeks
6
Testing Phase
2 Weeks
7
Review Phase
2 Weeks
8-Oct 1
2
3
8-Nov 4
1
2
3
8-Dec 4
1
Govt: Girls Degree College Sukkur
2
3
Jan-09 4
1
2
3
Feb-09 4
1
2
3
4
Chapter # 4
Database Architecture
Entity Relationship Diagram
Govt: Girls Degree College Sukkur
Entities relationship diagrams are a major data-modeling tool and will help organize the data in the project into entities and define the relationship between the entities. This process has proved to enable the analyst to produce a good database structure so that the data can be stored and retrieved in a most efficient manner. Data models are tools used in analysis to describe the data requirements and assumptions in the system from a top – down perspective. Entities are the “things” about which we seek up. Attributes are the data we collect about the entities. Relationships provide the structure needed to draw information from multiple entities.
Page 12 Chapter # 4
Database Architecture
Entities Relationship Diagram
Govt: Girls Degree College Sukkur
Life Insurance System Accept Date
Term
Heig ht
Add New Policy
Weight
Policy year
Sum Assure d
Add New Employee
Qualificatio n
Proposer no Policy no Plan No
Hire Date
Calculation Reference
CNIC No
Date of Birth
Email Destinatio n No
Mobile No
N ame
Addres s Employee Id
Pay Salary
Receive Payments Salary Amount
Propodent No Receip t No
Amou nt Submit Date
Payment Date Accoun t No
Employe e ID Destinatio n No
Policy No
Page 13 Chapter # 4
Database Architecture
Govt: Girls Degree College Sukkur
Calculations Maturity Premium
Total Amount
Silver Jubilee Bonus
Premium To Paid
Term Of Insuranc e
Choose Policy Name
Sum Assured Payment Mode
Age
Policy End Date
Policy Mature Bonus
Due Date Bonus
Golden Jubilee Bonus
Policy Year
Policy Payment
Gander
Policy Star Date
Proposer Name Policy Id
Page 14 Chapter # 4
Database Architecture
Normalization Govt: Girls Degree College Sukkur
Normalization is the process of efficiency organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored. There are formal methods for qualifying “how normalized” a relational database is, and these classifications are called normal form (or NF).
RDBMS 4.3.1 Add_new_policy Field Name
Type
Prop_No Policy_No Policy_Year Plan_No Sum_Assured Term Accept_Date Height Weight Note
Number Number Datetime Number Number Number Datetime Number Number Text
Key Status
Description Form Number
Page 15 Chapter # 4
Database Architecture
4.3.2 Policy_Detail Govt: Girls Degree College Sukkur
Field Name
Type
Key Status
Description
Prop_No Prop_name F_name/H_name Address E-mail Phone/Mobile CNIC_No Date_of_birth Sex Age Nominee Occupation
Number Text Text Text Text Number Number Text Text Number Text Text
Form number Name of customer F name Residential address E-mail ID Mobile number NIC card number Date of birth Sex Age Nominee name Occupation
Office_address
Text
Office address
Office_phone Note
Number Text
Office phone
4.3.3 Receive_Payments Field Name
Type
Prop_No Receipt_No Propodent_No
Number Number Number
Amount Submit_date
Number datetime
Key Status
Description Form number Receipt number of payment After registration policy number will assign to the customer Amount Date of submit payment
Page 16 Chapter # 4
Database Architecture
4.3.4 Find_Payments
Govt: Girls Degree College Sukkur
Field Name
Type
Prop_No Receipt_No Propodent_No
Number Number Number
Amount Submit_date
Number Datetime
Key Status
Description Form number Receipt number of payment After registration policy number will assign to the customer Amount Date of submit payment
4.3.5 Add_New Field Name
Type
Employee_ID Destination_No
Number Number
Employee_name Address Mobile/Phone E-mail Date_of_birth Hire_date
Text Text Number Text Text Datetime
CNIC_No Qualification Rference Note
Number Text Text Text
Key Status
Description Code of employee Name of agent to add there account Name Residential address Contact number E-mail ID Date of birth When employee hire for that job NIC card number Qualification
Page 17 Chapter # 4 4.3.6
Database Architecture
Pay_Salary
Govt: Girls Degree College Sukkur
Field Name
Type
Employee_ID Destination_No
Number Number
Account-No Salary_amount Payment_date Note
Number Number datetime Text
Key Status
Description Code of employee Name of agent to add there account Account number of bank Amount Date of payment
4.3.7 Premium Field Name
Type
Choose_a_policy_name Term_of_assurance Payment_mode Gender Age Sum_assured Premium_to_be_paid
Text Number Text Text Number Number Number
Key Status
Description Select any policy Select years Select mode of payment Select gander Type age Type sum assured amount After calculation
4.3.8 Maturity Field Name
Type
Policy_ID Prop_name Policy_Year Policy_payment
Number Text Datetime Number
Key Status
Description Policy number Name of policy holder Year Payment of policy
Page 18 Chapter # 4
Database Architecture
Govt: Girls Degree College Sukkur
Policy_start_date Policy_end_date Bonuses Due_date_bonus Golden_jubilee_bonus Silver_jublee_bonus Policy_mature_bonus Total amount
Datetime Datetime
Start date of policy End date of policy
Number Number Number Number Number
Due date bonus Golden jubilee bonus Silver jubilee bonus Mature bonus After calculation
4.4 Data Dictionary In database management system a file that defines the basic organization of database. A database dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each of each field. Most database management systems keep the data dictionaries hidden from users to prevent them from by coincidence destroying its contents. Entities/Attributes
Type
Key Status
Valid
Add_new_policy Prop_No Policy_No Policy_Year Plan_No Sum_Assured Term Accept_Date Height Weight Note
Text Text Text Text Text Text Text Text Number
a-z a-z Date a-z a-z a-z a-z & 0-9 a-z & 0-9 0-9
Page 20 Chapter # 4
Database Architecture
Policy_Detail Govt: Girls Degree College Sukkur
Prop_No Prop_name F_name/H_name Address E-mail Phone/Mobile CNIC_No Date_of_birth Sex Age Nominee Occupation Office_address Office_phone Note
Number Text Text Text Text Number Number Text Text Number Text Text Text Number Text
0-9 a-z a-z a-z & 0-9 a-z & 0-9 0-9 0-9 Date a-z 0-9 a-z a-z a-z & 0-9 0-9 a-z
Number Number Number Number datetime
0-9 0-9 0-9 0-9 Date
Number Number Number Number Datetime
0-9 0-9 0-9 0-9 Date
Receive_Payments Prop_No Receipt_No Propodent_No Amount Submit_date
Find_Payments Prop_No Receipt_No Propodent_No Amount Submit_date
Page 20 Chapter # 4
Database Architecture
Add_New
Govt: Girls Degree College Sukkur
Employee_ID Destination_No Employee_name Address Mobile/Phone E-mail Date_of_birth Hire_date CNIC_No Qualification Rference Note
Number Number Text Text Number Text Text Datetime Number Text Text Text
0-9 0-9 a-z a-z & 0-9 Contact number a-z & 0-9 Date Date 0-9 a-z a-z a-z
Number Number Number Number datetime Text
0-9 0-9 0-9 0-9 Date a-z
Text Number Text Text Number Number Number
a-z 0-9 a-z a-z 0-9 0-9 0-9
Pay_Salary Employee_ID Destination_No Account-No Salary_amount Payment_date Note
Premium Choose_a_policy_name Term_of_assurance Payment_mode Gender Age Sum_assured Premium_to_be_paid
Govt: Girls Degree College Sukkur
Page 22 Chapter # 4
Database Architecture
Maturity Policy_ID Prop_name Policy_Year Policy_payment Policy_start_date Policy_end_date Bonuses Due_date_bonus Golden_jubilee_bonus Silver_jublee_bonus Policy_mature_bonus Total amount
Number Text Datetime Number Datetime Datetime
0-9 a-z Date 0-9 Date Date
Number Number Number Number Number
0-9 0-9 0-9 0-9 0-9
Govt: Girls Degree College Sukkur
Page 23
Chapter # 5
Project Requirement Specification
Govt: Girls Degree College Sukkur
5.1 Project Requirement Specification The project requirement specification is comprised of the entire requirement which we needed to develop our client server application. Following specifications are included. o Hardware specification o Software specification H
5.1.1 Hardware specification Hardware is the physical thing s which are used for develop this software. To get the better performance results of the application, following hardware specification are obligatory. o Pentium IV Intel o Minimum 128/256 MB RAM o Keyboard o Windows compatible Mouse o Hard disk
5.1.2 Software Specification 5.1.2.1 Operating System Specification 1. The system can be run on any operating system higher than windows 2. 2000 The system can be run very frequently on windows, 2000, XP,
vista or and can be run on any machine like IBM or Intel. 5.1.2.2 Language Specification 1. The language specification is not much higher the VB.NET 2005 can be easily installed on any P III computer having Ram more than 256.
Chapter # 5
Page 25 Project Requirement Specification Govt: Girls Degree College Sukkur
2. The processor requirement of VB.Net is just 1GHz. 3. You have to install .NET frame work to work on system and Visual Studio for more comfortable programming.
Visual Basic.Net .NET is Microsoft's strategy of software that provides services to people any time, any place, on any device. An accurate definition of .NET is, it's an XML Web Services platform which allows us to build rich .NET applications, which allows users to interact with the Internet using wide range of smart devices (tablet devices, pocket PC's, web phones etc), which allows to build and integrate Web Services and which comes with many rich set of tools like Visual Studio to fully develop and build those applications.
What is .NET Built On? .NET is built on the Windows Server System to take major advantage of the OS and which comes with a host of different servers which allows for building, deploying, managing and maintaining Web-based solutions. The Windows Server System is designed with performance as priority and it provides scalability, reliability, and manageability for the global, Webenabled enterprise. The Windows Server System integrated software products are built for interoperability using open Web standards such as XML and SOAP. Visual Basic .NET provides the easiest, most productive language and tool for rapidly building Windows and Web applications. Visual Basic .NET comes with enhanced visual designers, increased application performance, and a powerful integrated development environment (IDE). It also supports creation of applications for wireless, Internet-enabled hand-held devices. The following are the features of Visual Basic .NET with .NET Framework 1.0 and Visual Basic .NET 2003 with .NET Framework 1.1. This also answers why should I use Visual Basic .NET, what can I do with it?
Chapter # 5
Page 26 Project Requirement Specification Govt: Girls Degree College Sukkur
Appearance Appearance section of the properties window allows us to make changes to the appearance of the Button. With the help of BackColor and Background Image properties we can set a background color and a background image to the button. We set the font color and font style for the text that appears on button with ForeColor and the Font property. We change the appearance style of the button with the FlatStyle property. We can change the text that appears on button with the Text property and with the TextAlign property we can set where on the button the text should appear from a predefined set of options.
Debugging VB .NET Applications In this section we will focus on some common issues while debugging our applications and we will take a close look at the Debug Menu Visual Studio .NET provides us. Errors in programming are inevitable. Every one of us introduces errors while coding. Errors are normally referred to as bugs. The process of going through the code to identify the cause of errors and fixing them is called Debugging.
Page 27
Govt: Girls Degree College Sukkur
Chapter # 6
Interface Design
6.1 Administrator Forms application The VB.Net is the pure OOP language and also a event based language so we have used a built in classes and events in our software
Govt: Girls Degree College Sukkur
6.1.1 The Events Used in the Forms 6.1.1.1 Main Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. MainForm.Text b. MainForm.Forecolor c. MainForm.Backcolor d. MainForm.Name
• Event Name o
Label3_MouseEnter
•
Purpose of the Event a. When Mouse comes over the label
•
Procedure Called in the Event a. None
•
Properties used in the event a. None
• Event Name •
o
Label3_MouseLeave
Purpose of the Event a. When mouse leaves the label
Page 29 Chapter # 6
Interface Design
•
Procedure Called in the Event a. None
•
Properties used in the event a. None
Govt: Girls Degree College Sukkur
• Event Name o
Button1_Click
•
Purpose of the Event a. Click on the button
•
Procedure Called in the Event a. None
•
Properties used in the event a. Button1.Text b. Button1.Forecolor c. Button1.Backcolor d. Button1.Name
• Event Name o
MainForm_Resize
•
Purpose of the Event a. Resize the Form
•
Procedure Called in the Event a. None
•
Properties used in the event a. None
• Event Name o
Timer1_Tick
•
Purpose of the Event a. Start the timer
•
Procedure Called in the Event a. None
•
Properties used in the event a. Timer1.tick b. Timer1.Interval
Page 30
Govt: Girls Degree College Sukkur
Chapter # 6
Interface Design
6.1.1.2 Employees Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. EmployeeForm.Text b. Employee.Forecolor c. Employee.Backcolor d. Employee.Name
• Event Name o
AddButton_Click
•
Purpose of the Event a. Clear the Text Boxes
•
Procedure Called in the Event a. Clear
•
Properties used in the event a. AddButton.Text b. AddButton. Fore color c. AddButton. Back color d. AddButton.Name
• Event Name o
SaveButton_Click
•
Purpose of the Event a. Save the Record
•
Procedure Called in the Event a. Save
Page 31 Govt: Girls Degree College Sukkur
Chapter # 6 •
Interface Design
Properties used in the event a. SaveButton.Text b. SaveButton. Fore color c. SaveButton. Back color d. SaveButton.Name
• Event Name o
DeleteButton_Click
•
Purpose of the Event a. Delete The Record
•
Procedure Called in the Event a. Delete
•
Properties used in the event a. Delete Button.Text b. Delete Button. Fore color c. Delete Button. Back color d. Delete Button.Name
6.1.13 Policy Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. PolicyForm.Text b. Policy.Forecolor c. Policy.Backcolor d. Policy.Name
Page 32 Govt: Girls Degree College Sukkur
Chapter # 6
Interface Design
• Event Name o
AddButton_Click
•
Purpose of the Event a. Clear the Text Boxes
•
Procedure Called in the Event a. Clear
•
Properties used in the event a. AddButton.Text b. AddButton. Fore color c. AddButton. Back color d. AddButton.Name
• Event Name o
SaveButton_Click
•
Purpose of the Event a. Save the Record
•
Procedure Called in the Event a. Save
•
Properties used in the event a. SaveButton.Text b. SaveButton. Fore color c. SaveButton. Back color d. SaveButton.Name
• Event Name o
DeleteButton_Click
•
Purpose of the Event a. Delete The Record
•
Procedure Called in the Event a. Delete
•
Properties used in the event a. Delete Button.Text b. Delete Button. Fore color c. Delete Button. Back color d. Delete Button.Name
Govt: Girls Degree College Sukkur
Page 33 Chapter # 6
Interface Design
6.1.1.4 Members Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. MemberForm.Text b. MemberForm.Forecolor c. MemberForm.Backcolor d. MemberForm.Name
• Event Name o
AddButton_Click
•
Purpose of the Event a. Clear the Text Boxes
•
Procedure Called in the Event a. Clear
•
Properties used in the event a. AddButton.Text b. AddButton. Fore color c. AddButton. Back color d. AddButton.Name
• Event Name o
SaveButton_Click
•
Purpose of the Event a. Save the Record
•
Procedure Called in the Event a. Save
•
Properties used in the event a. SaveButton.Text b. SaveButton. Fore color
Govt: Girls Degree College Sukkur
Page 34 Chapter # 6
Interface Design
c. SaveButton. Back color d. SaveButton.Name
• Event Name o
DeleteButton_Click
•
Purpose of the Event a. Delete The Record
•
Procedure Called in the Event a. Delete
•
Properties used in the event a. Delete Button.Text b. Delete Button. Fore color c. Delete Button. Back color d. Delete Button.Name
6.1.1.5 Display All Members Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. DisplayMemberForm.Text b. DisplayMemberForm.Forecolor c. DisplayMemberForm.Backcolor d. DisplayMemberForm.Name
• Event Name o
•
cmdsearch_Click
Purpose of the Event a. Search The Record
Govt: Girls Degree College Sukkur
Page 35 Chapter # 6
Interface Design
•
Procedure Called in the Event a. Search
•
Properties used in the event a. cmdsearch Button.Text b. cmdsearch Button. Fore color c. cmdsearch Button. Back color d. cmdsearch Button.Name
6.1.1.6 Find Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. Find Form.Text b. Find Form.Forecolor c. Find form.Backcolor d. Find Form.Name
• Event Name o
cmdsearch_Click
•
Purpose of the Event a. Search The Record
•
Procedure Called in the Event a. Search
•
Properties used in the event a. cmdsearch Button.Text b. cmdsearch Button. Fore color c. cmdsearch Button. Back color d. cmdsearch Button.Name
Govt: Girls Degree College Sukkur
Page 36
Chapter # 7
Testing
7.1 Testing Govt: Girls Degree College Sukkur
Testing is defined as The operation of a functional unit and comparison of its achieved results with the defined results to establish acceptability.
7.2 Testing Strategies A testing strategy is general approach to the testing process. There are number of strategies available. We have applied following strategies to test our software after completion. Event testing Black box testing
7.2.1 Event testing It’s an event based approach where tests are based on the events which trigger system actions. As for our project events are used to perform certain operations. • • • • •
Search button_click() event to search any type of record. Add button_click() event add new data. Delete button_click() event delete the selected record. Save button_click() event save the records. Submit button_click() event doing calculation after get input from user.
7.2.2 black-box testing Black-box testing relies on the specification of this system or component which is being tested to derive test cases. The system is a “black-box” whose behavior can only be determined by studying inputs and related Page 38 Chapter # 7
Testing
Govt: Girls Degree College Sukkur
outputs. It’s called functional testing because mathematical functions can only be proved by specific inputs to calculate outputs. In our project while applying this testing technique, we specified following inputs to study whether required outputs are generated or not. • Enable add button to ensure that this button adds record or not. • Enabled login button to check that it logins to the system or not.
Page 39
Govt: Girls Degree College Sukkur
Chapter # 8
User Guide
8.1 How to run operator forms
Govt: Girls Degree College Sukkur
o Login Form This is login form of insurance system. If user put correct user name and password then login.
Page 41 Chapter # 8
User Guide
o Home Page This is home page of software where all fields are declared. User can open any field and modify that record, find records and doing calculation. Govt: Girls Degree College Sukkur
Page 42 Chapter # 8
User Guide
o Change Login Password
Govt: Girls Degree College Sukkur
To change the login password there is a field named file and click the change login pass. New window will open user type current password and new password. This process changes the change login password.
Page 43 Chapter # 8
User Guide
o Add New Policy
Govt: Girls Degree College Sukkur
To save new record in the field named policy member. There is a field add new policy, click it and new window will open to save new records. User can search any record in this field.
Page 44 Chapter # 8
User Guide
o Policy Detail
Govt: Girls Degree College Sukkur
To show complete detailed information of policy holder.
Page 45 Chapter # 8
User Guide
o Display all
Govt: Girls Degree College Sukkur
To display all records of every table which user wants to see?
Page 46 Chapter # 8
User Guide
o Receive payments
Govt: Girls Degree College Sukkur
To save the important information of receive payment of policy holder. Also display the records.
Page 47 Chapter # 8
User Guide
o Add New
Govt: Girls Degree College Sukkur
To save new record of new employee. Update the record and search any record.
Page 48 Chapter # 8
User Guide
o Find
Govt: Girls Degree College Sukkur
After select any table and put particular fields, to find any record.
Page 49 Chapter # 8
User Guide
o Pay Salary
Govt: Girls Degree College Sukkur
To save record of every employee.
Page 50 Chapter # 8
User Guide
o Premium
Govt: Girls Degree College Sukkur
To calculate premium value of new record.
Page 51 Chapter # 8
User Guide
o Maturity Calculate
Govt: Girls Degree College Sukkur
To calculate the maturity after completion of policy. Add bonuses of maturity.
Page 52 Chapter # 8
User Guide
o User Guide
Govt: Girls Degree College Sukkur
How to use this software? User guide for user understanding.
Page 53 Chapter # 8
User Guide
o About Software
Govt: Girls Degree College Sukkur
About software of Life insurance System.
Page 54 Chapter # 8
User Guide
o Show / Hide
Govt: Girls Degree College Sukkur
This is the option of show or hides the bar.
Page 55 Chapter # 8
User Guide
o Show /Hide
Govt: Girls Degree College Sukkur
After press this button bar will be hiding.
Page 56
Govt: Girls Degree College Sukkur
Chapter # 9
Conclusion And Recommendation
9.1 Conclusion Life insurance system is a single client user database, which shows following capabilities. Client can modify policy information o Add new record Govt: Girls Degree College Sukkur
o Delete records o Save records
Client can search every type of record. Client can change user name and password. Client can calculate premium value of any policy. Client can calculate maturity of policy with bonuses.
9.2 Future Recommendation
Registration and authentication for login using database. Quote sheets are available. All records are saving. Calculation.
Page 58
Govt: Girls Degree College Sukkur
Referred Books Programming VB .NET: A Guide For Experienced Programmers Introducing Microsoft Visual Basic 2005 for Developers
Govt: Girls Degree College Sukkur
Web Sites www.Statelife.com.pk www.startvbdotnet.com www.yahoo.com www.google.com
Other Resources Learning Softwares of VB.NET
Govt: Girls Degree College Sukkur
A Thesis Submitted For the Degree Of Bachelor Of Science (Information Technology)
By Faiza Soomro
Government Girls Degree College Sukkur Affiliated with Shah Abdul Latif University Khairpur
Govt: Girls Degree College Sukkur
Department of computer science Certificate This is certified that we have read the report submitted by Faiza Soomro,It is my judgment that this report on “Life Insurance System” is of sufficient standard to warrant its acceptance by the department of computer science, Government Girls Degree College Sukkur for the degree of bachelor of computer science in partial fulfillments of the requirement of BS(IT).
___________________ External Shah Abdul Latif University
___________________ Supervisor Madam Naila Govt: Girls Degree College Sukkur
__________________ Principal Madam Azra Tabbasum Govt: Girls Degree College Sukkur
Govt: Girls Degree College Sukkur
Dedication We dedicate this sincere effort to grace Almighty ALLAH. We also dedicate this effort to our Holy Prophet Hazrat Muhammad (Peace Be upon Him) who is the messenger of love, harmony brotherhood and compression to the entire universe. We also dedicate to our respected parents. Both are helped us for making that project. We all thanks to Almighty ALLAH and parents. Our parents gave financial support to develop that project. All success of our bright achievement goes to our parents and the teachers. They always pray to ALLAH for our success in every walk of our lives.
Govt: Girls Degree College Sukkur
Abstract This thesis concerned with the system of Life Insurance. This software will support the officials to maintain a computerized data base management system to promote legal maintenance of customers in Insurance Corporation in future. This software solved many problems. In this world there are many soft wares of insurance to keeping records of consumers and manage it but insurance system software is our little struggle for betterment. This system provides information with accuracy, reliability and high speed. This software keep records of policy holders, there complete history from purchasing the policy to mature that policy. Calculate the premium and maturity.
Govt: Girls Degree College Sukkur
Acknowledgement All praises to Almighty ALLAH, The Rehman and Raheem and his last Messenger Hazarat Muhammad (Peace Be upon Him) who has been the greatest blessing to mankind. We have completed our project and have been able to present out final theses along with software as per requirement of BSIT degree under the honorable committee of the teachers and faculty in charge of Govt: Girls Degree College Sukkur. Finally, a special recognition and acknowledgements are due and are cordially rendered to our project supervisor Respected Madam Naila Wahab for her technical and moral support and timely guidance throughout this project. We also very thanks full to Sir Anwar Ali Subehapoto, who is the head of P&Gs department in State Life Insurance Corporation in Sukkur Zone, he provided us complete information and forms. Thanks to Sir Tanveer Ahmed who guided us about VB.net.
Govt: Girls Degree College Sukkur
Preface This system is concerned with the management of Life Insurance System. This system provides user interface and easy access of register of policy, finding records, agent information and calculation of premium and maturity. The entire work is presented in nine chapters.
Chapter 1 It provides the brief introduction to Life Insurance System. It also gives the detailed functions and fields of Insurance System.
Chapter 2 This chapter defines the goals and objectives of Life Insurance System.
Chapter 3 This chapter deals with the steps, followed from beginning to end of the software development process.
Chapter 4 This chapter is concerned with database architecture, ERD, tables and data dictionary.
Chapter 5 This chapter is concerned with the project specification for the system design. It discusses hardware, software assortment.
Chapter 6 This chapter deals with how code has been designed for this application.
Govt: Girls Degree College Sukkur
Chapter 7 This chapter concerned with testing process and debugging.
Chapter 8 This chapter describes how to run and use Life Insurance System software.
Chapter 9 This chapter includes the conclusion and future recommendation.
Govt: Girls Degree College Sukkur
Table of Contents Chapter 1 Project Description 1.1 1.2
1.3 1.4
Page No
Introduction………………………….…………………………….1 Terminology………………………………………………….........1 1.2.1 Policy Type……………………………………………...1 1.2.2 Policy Number…………………………………………..1 1.2.3 Term………………………………………………..........2 1.2.4 Table……………………………………………….........2 1.2.5 Code No……………………………………………........2 1.2.6 Sum Assured……………………………………….........2 Policy Registration………………………………………………...2 Benefits of Insurance System……………………………………...3
Chapter 2 Goals and Objectives 2.1 2.2
Objectives According to Staff Management………………………5 Objectives According to Policy Holder…………………………...5
Chapter 3 Software Process Model 3.1 3.2
3.3
Problem Definition………………………………………………...8 The Linear Sequential Model……………………………………...8 3.2.1 Analysis……………………………………………………..8 3.2.2 Designing…………………………………………………...8 3.2.2.1 Interface Design………………………………….9 3.2.2.2 Advantages of Interface Designing………………9 3.2.3 Coding………………………………………………….........9 Gantt Chart……………………………………………………….10
Page No Govt: Girls Degree College Sukkur
Chapter 4 Database architecture 4.1 4.2 4.3
4.4
Entities Relationship Diagram (ERD)……………………………..13 Normalization………………………………………………...........15 RDBMS……………………………………………………………15 4.3.1 Add new policy…..…………………………………………15 4.3.2 Policy Detail…………………………………………...........16 4.3.3 Receive Payments…………………………………………..17 4.3.4 Find Payments………………………………………………17 4.3.5 Add New……………………………………………………17 4.3.6 Pay Salary…………………………………………………...18 4.3.7 Premium ……………………………………………………18 4.3.8 Maturity………………………………………………..........19 Data Dictionary…………………………………………................19
Chapter 5 Project Requirement Specification 5.1
Requirement Specification………………………………...............25 5.1.1 Hardware Specification……………………………………..25 5.1.2 Software Specification……………………………...............25 5.1.2.1 Operating System Specification……...............25 5.1.2.2 Language Specification ……………………..25
Chapter 6 Interface Design 6.1
Administrator Forms application……………………………….....30 6.1.1 Events used in the forms……………………………............30 6.1.1.1 Main form……………………………………..30 6.1.1.2 Employees Form………………………............32 6.1.1.3 Policy Form……………………………...........33 6.1.1.4 Members Form………………………………..35 6.1.1.5 Display all member forms………………….....36 6.1.1.6 Find Forms…………………………...............37
Page No Govt: Girls Degree College Sukkur
Chapter 7 Testing 7.1 7.2
Testing…………………………………………………………..…38 Testing Strategy……………………………………………………38 7.2.1 Event Testing………………………………………..38 7.2.2 Black-box testing……………………………………38
Chapter 8 User Guide 8.1
How to run operator forms………………………………………..41
Chapter 9 Conclusion and Recommendations 9.1 9.2
Conclusions………………………………………………………..58 Future recommendations…………………………………………..58
Bibliography Referred Books Web sites Other Resources
Govt: Girls Degree College Sukkur
Chapter # 1
Project Specification
1.1 Introduction
Govt: Girls Degree College Sukkur
Life Insurance System is a management of complete centralized database. This system keeping the records of Policy holders, finding records, agent information, calculate premium and maturity and quote sheets. This system is consisting of two parts. o Data base o User Interface Data base Database is development environment where the entire database id developed and user can access it. User interface This part is concern with the easy control of system database by user. The insurance information consists of information relation to the operations of the insurance industry. Each policy holder is identified the policy Number, terms, tables (plans), and sum assured. Each policy holder’s record is keeping manually as well as in computer system.
1.2 Terminology There are some terminologies related with Insurance system. These are given below:
1.2.1 Policy Type Policy type is plan which is selected by policy holder. Policy plans have different values and benefits. Policy plans have different values by different age in rate book.
1.2.2 Policy Number Page 1 Chapter # 1
Project Specification
Policy Number is a 9 digit code which is given to policy holder after registration of that policy. Govt: Girls Degree College Sukkur
1.2.3 Term These are years which is decided by policy holder that how many years the policy will complete.
1.2.4 Table These are plans which are appeared in the shape of 2 digit codes in rate book. Policy holder choose plan according to there benefits. In Insurance corporations codes are applied in form not table name.
1.2.5 Code No This is code which is given to policy holder before registration of policy Number. This is also known as propodent number.
1.2.6 Sum assured This is amount which is decided by policy holder that how much amount the policy holder will pay during time period of policy.
1.3 Policy Registration Policy registration is a process which is performs by particular employee in corporation. This is manually process. First person is come in the new business department and get the form of purchasing policy. That officer gives complete guidance to customer. When form is going to complete then medical check up and tests will start. When all requirements are full fill by customer, the manually form give to the policy registration officer. He checks all requirement of policy holder and do calculate the values and premium and then registers the policy number. After this process the Page 2 Chapter # 1
Project Specification
Govt: Girls Degree College Sukkur
Policy of policy holder is done. A conformation latter send to the policy holder’s residential address.
1.4 Benefits of Insurance System. There are a lot of benefits to doing Life Insurance. Insurance policy is the financial support for the family when policy holder becomes death. There are many plans for many persons and there are different benefits of each plan. Policy holders purchase policy according to there benefits.
Page 3
Govt: Girls Degree College Sukkur
Chapter # 2
Goals And Objectives
2.1 Objectives According to Staff Management The objectives according to staff management of Life Insurance System.
Govt: Girls Degree College Sukkur
1. The staff members can easily manage all the policy members’ information up-to-date. 2. Management can get fast easy and accurate reports when it needs. 3. Management can also count the premium and maturity easily because the software is also having the capability to calculate premium automatically. 4. Management has also another advantage of manage the information of the agents that are working in the organization. 5. Management has all the transaction and records of all its employees and policy members. 6. If any one wants to get the form u can get it by using the printer. 7. All the information is highly secured and no one can be entered in the system without the administrator or authorized user.
2.2 Objectives according to policy holder The policy holders have also lots of benefits of using the Life Insurance System. 1. The main objective of according to the policy holder is that they can
be easily registered and they have no any need to wait for the registration. Page 5 Chapter # 2
Goals And Objectives
2. The policy holders have also advantage to see their data when ever they want and it is easy to search out any one’s information by using the Proposer Name or number.
Govt: Girls Degree College Sukkur
3. The Policy members have also advantage of calculations that can
be done fastly and accurately. 4. The policy members have no need to pay the payment to the agent
they can pay any where and they have to show the bill and the operator of the software can easily add the payment.
Page 6
Govt: Girls Degree College Sukkur
Chapter # 3
Software Process Model
3.1 Problem Definitions The Software that is developed using database is complicated but this is very user friendly database system. Transactions in the database can be easily done using this software. A window based application Linear Sequential Model. We has adopted a sequential model to develop the system. The linear sequential model suggests a systematic, sequential approach to software development that beings at the system level and progresses through.
Govt: Girls Degree College Sukkur
o o o o
Analysis Design Coding Testing
Analysis
Design
Coding
Testing
3.2 Linear Sequential Model 3.2.1 Analysis This part of the system is very important because we don’t have any knowledge about any transactions of the system that we are going to develop. The system Life Insurance System is not based on the network so we have no need of any extra hardware or network environment. Analysis focuses on “what to do?” analysis defines only the structure of subject and doesn’t consider its implementation. Analysis is the Software Process Model systematic approach to problem solving. As we have followed the “The Linear Sequential Model”, we implemented this phase too.
3.2.2 Designing Design is the first step in the development phase of any engineered
Page 8 Chapter # 3
Software Process Model
product or system. It is a process that provides the sufficient details to permit system’s physical realization. It is the process of applying various techniques and principles for the purpose of defining a system.
3.2.2.1 Interface Design The first step in the software designing is the Interface design. We have lot of problems that what should be the interface how to design a user friendly Govt: Girls Degree College Sukkur
interface finally we have some idea from the other software’s that how to develop it. Control and Design of Interface of the Application Forms. The forms are the classes that hold many objects they can be said the containers that hold deferent controls form is the key element of the system. Administrator form Simple Form MDI Form Menu. Menu is the drop down list of elements a user can easily access it. File Menu Policy Member Payment Employee Calculation Quote Sheet Help can easily access Buttons.
3.2.2.2 Advantages of Interface Designing The interface is the designed screen in any powerful language, to store, manipulate, access and retrieve data easily. This part of the system provides facilities to the users of the system. The interface of the Insurance System is designed in the most powerful language called Microsoft Visual Basic.Net 2005. The interface is the user-friendly environment that every one can use easily. The importance of good user interface design can be the difference between product acceptance and rejection in the marketplace. If end-users feel it is not easy to learn, not easy to use, or too cumbersome, an otherwise excellent product could fail. Good User Interface Design can make a product easy to understand and use, which results in greater user acceptance.
3.2.3 Coding Each class or form contains a lot of sub routines and functions according to its work the code is purely OOP supported we have used. o o o o
Namespaces Classes Objects Variables Page 9
Govt: Girls Degree College Sukkur
Project Time Scheduling S.NO
Activity
Estimated Duration Weeks
1
Problem Definition
3 weeks
2
Feasibility Phase
3Weeks
3
Analysis Phase
2 Weeks
4
Design Phase
3 Weeks
5
Coding Phase
4 Weeks
6
Testing Phase
2 Weeks
7
Review Phase
2 Weeks
8-Oct 1
2
3
8-Nov 4
1
2
3
8-Dec 4
1
Govt: Girls Degree College Sukkur
2
3
Jan-09 4
1
2
3
Feb-09 4
1
2
3
4
Chapter # 4
Database Architecture
Entity Relationship Diagram
Govt: Girls Degree College Sukkur
Entities relationship diagrams are a major data-modeling tool and will help organize the data in the project into entities and define the relationship between the entities. This process has proved to enable the analyst to produce a good database structure so that the data can be stored and retrieved in a most efficient manner. Data models are tools used in analysis to describe the data requirements and assumptions in the system from a top – down perspective. Entities are the “things” about which we seek up. Attributes are the data we collect about the entities. Relationships provide the structure needed to draw information from multiple entities.
Page 12 Chapter # 4
Database Architecture
Entities Relationship Diagram
Govt: Girls Degree College Sukkur
Life Insurance System Accept Date
Term
Heig ht
Add New Policy
Weight
Policy year
Sum Assure d
Add New Employee
Qualificatio n
Proposer no Policy no Plan No
Hire Date
Calculation Reference
CNIC No
Date of Birth
Email Destinatio n No
Mobile No
N ame
Addres s Employee Id
Pay Salary
Receive Payments Salary Amount
Propodent No Receip t No
Amou nt Submit Date
Payment Date Accoun t No
Employe e ID Destinatio n No
Policy No
Page 13 Chapter # 4
Database Architecture
Govt: Girls Degree College Sukkur
Calculations Maturity Premium
Total Amount
Silver Jubilee Bonus
Premium To Paid
Term Of Insuranc e
Choose Policy Name
Sum Assured Payment Mode
Age
Policy End Date
Policy Mature Bonus
Due Date Bonus
Golden Jubilee Bonus
Policy Year
Policy Payment
Gander
Policy Star Date
Proposer Name Policy Id
Page 14 Chapter # 4
Database Architecture
Normalization Govt: Girls Degree College Sukkur
Normalization is the process of efficiency organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored. There are formal methods for qualifying “how normalized” a relational database is, and these classifications are called normal form (or NF).
RDBMS 4.3.1 Add_new_policy Field Name
Type
Prop_No Policy_No Policy_Year Plan_No Sum_Assured Term Accept_Date Height Weight Note
Number Number Datetime Number Number Number Datetime Number Number Text
Key Status
Description Form Number
Page 15 Chapter # 4
Database Architecture
4.3.2 Policy_Detail Govt: Girls Degree College Sukkur
Field Name
Type
Key Status
Description
Prop_No Prop_name F_name/H_name Address E-mail Phone/Mobile CNIC_No Date_of_birth Sex Age Nominee Occupation
Number Text Text Text Text Number Number Text Text Number Text Text
Form number Name of customer F name Residential address E-mail ID Mobile number NIC card number Date of birth Sex Age Nominee name Occupation
Office_address
Text
Office address
Office_phone Note
Number Text
Office phone
4.3.3 Receive_Payments Field Name
Type
Prop_No Receipt_No Propodent_No
Number Number Number
Amount Submit_date
Number datetime
Key Status
Description Form number Receipt number of payment After registration policy number will assign to the customer Amount Date of submit payment
Page 16 Chapter # 4
Database Architecture
4.3.4 Find_Payments
Govt: Girls Degree College Sukkur
Field Name
Type
Prop_No Receipt_No Propodent_No
Number Number Number
Amount Submit_date
Number Datetime
Key Status
Description Form number Receipt number of payment After registration policy number will assign to the customer Amount Date of submit payment
4.3.5 Add_New Field Name
Type
Employee_ID Destination_No
Number Number
Employee_name Address Mobile/Phone E-mail Date_of_birth Hire_date
Text Text Number Text Text Datetime
CNIC_No Qualification Rference Note
Number Text Text Text
Key Status
Description Code of employee Name of agent to add there account Name Residential address Contact number E-mail ID Date of birth When employee hire for that job NIC card number Qualification
Page 17 Chapter # 4 4.3.6
Database Architecture
Pay_Salary
Govt: Girls Degree College Sukkur
Field Name
Type
Employee_ID Destination_No
Number Number
Account-No Salary_amount Payment_date Note
Number Number datetime Text
Key Status
Description Code of employee Name of agent to add there account Account number of bank Amount Date of payment
4.3.7 Premium Field Name
Type
Choose_a_policy_name Term_of_assurance Payment_mode Gender Age Sum_assured Premium_to_be_paid
Text Number Text Text Number Number Number
Key Status
Description Select any policy Select years Select mode of payment Select gander Type age Type sum assured amount After calculation
4.3.8 Maturity Field Name
Type
Policy_ID Prop_name Policy_Year Policy_payment
Number Text Datetime Number
Key Status
Description Policy number Name of policy holder Year Payment of policy
Page 18 Chapter # 4
Database Architecture
Govt: Girls Degree College Sukkur
Policy_start_date Policy_end_date Bonuses Due_date_bonus Golden_jubilee_bonus Silver_jublee_bonus Policy_mature_bonus Total amount
Datetime Datetime
Start date of policy End date of policy
Number Number Number Number Number
Due date bonus Golden jubilee bonus Silver jubilee bonus Mature bonus After calculation
4.4 Data Dictionary In database management system a file that defines the basic organization of database. A database dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each of each field. Most database management systems keep the data dictionaries hidden from users to prevent them from by coincidence destroying its contents. Entities/Attributes
Type
Key Status
Valid
Add_new_policy Prop_No Policy_No Policy_Year Plan_No Sum_Assured Term Accept_Date Height Weight Note
Text Text Text Text Text Text Text Text Number
a-z a-z Date a-z a-z a-z a-z & 0-9 a-z & 0-9 0-9
Page 20 Chapter # 4
Database Architecture
Policy_Detail Govt: Girls Degree College Sukkur
Prop_No Prop_name F_name/H_name Address E-mail Phone/Mobile CNIC_No Date_of_birth Sex Age Nominee Occupation Office_address Office_phone Note
Number Text Text Text Text Number Number Text Text Number Text Text Text Number Text
0-9 a-z a-z a-z & 0-9 a-z & 0-9 0-9 0-9 Date a-z 0-9 a-z a-z a-z & 0-9 0-9 a-z
Number Number Number Number datetime
0-9 0-9 0-9 0-9 Date
Number Number Number Number Datetime
0-9 0-9 0-9 0-9 Date
Receive_Payments Prop_No Receipt_No Propodent_No Amount Submit_date
Find_Payments Prop_No Receipt_No Propodent_No Amount Submit_date
Page 20 Chapter # 4
Database Architecture
Add_New
Govt: Girls Degree College Sukkur
Employee_ID Destination_No Employee_name Address Mobile/Phone E-mail Date_of_birth Hire_date CNIC_No Qualification Rference Note
Number Number Text Text Number Text Text Datetime Number Text Text Text
0-9 0-9 a-z a-z & 0-9 Contact number a-z & 0-9 Date Date 0-9 a-z a-z a-z
Number Number Number Number datetime Text
0-9 0-9 0-9 0-9 Date a-z
Text Number Text Text Number Number Number
a-z 0-9 a-z a-z 0-9 0-9 0-9
Pay_Salary Employee_ID Destination_No Account-No Salary_amount Payment_date Note
Premium Choose_a_policy_name Term_of_assurance Payment_mode Gender Age Sum_assured Premium_to_be_paid
Govt: Girls Degree College Sukkur
Page 22 Chapter # 4
Database Architecture
Maturity Policy_ID Prop_name Policy_Year Policy_payment Policy_start_date Policy_end_date Bonuses Due_date_bonus Golden_jubilee_bonus Silver_jublee_bonus Policy_mature_bonus Total amount
Number Text Datetime Number Datetime Datetime
0-9 a-z Date 0-9 Date Date
Number Number Number Number Number
0-9 0-9 0-9 0-9 0-9
Govt: Girls Degree College Sukkur
Page 23
Chapter # 5
Project Requirement Specification
Govt: Girls Degree College Sukkur
5.1 Project Requirement Specification The project requirement specification is comprised of the entire requirement which we needed to develop our client server application. Following specifications are included. o Hardware specification o Software specification H
5.1.1 Hardware specification Hardware is the physical thing s which are used for develop this software. To get the better performance results of the application, following hardware specification are obligatory. o Pentium IV Intel o Minimum 128/256 MB RAM o Keyboard o Windows compatible Mouse o Hard disk
5.1.2 Software Specification 5.1.2.1 Operating System Specification 1. The system can be run on any operating system higher than windows 2. 2000 The system can be run very frequently on windows, 2000, XP,
vista or and can be run on any machine like IBM or Intel. 5.1.2.2 Language Specification 1. The language specification is not much higher the VB.NET 2005 can be easily installed on any P III computer having Ram more than 256.
Chapter # 5
Page 25 Project Requirement Specification Govt: Girls Degree College Sukkur
2. The processor requirement of VB.Net is just 1GHz. 3. You have to install .NET frame work to work on system and Visual Studio for more comfortable programming.
Visual Basic.Net .NET is Microsoft's strategy of software that provides services to people any time, any place, on any device. An accurate definition of .NET is, it's an XML Web Services platform which allows us to build rich .NET applications, which allows users to interact with the Internet using wide range of smart devices (tablet devices, pocket PC's, web phones etc), which allows to build and integrate Web Services and which comes with many rich set of tools like Visual Studio to fully develop and build those applications.
What is .NET Built On? .NET is built on the Windows Server System to take major advantage of the OS and which comes with a host of different servers which allows for building, deploying, managing and maintaining Web-based solutions. The Windows Server System is designed with performance as priority and it provides scalability, reliability, and manageability for the global, Webenabled enterprise. The Windows Server System integrated software products are built for interoperability using open Web standards such as XML and SOAP. Visual Basic .NET provides the easiest, most productive language and tool for rapidly building Windows and Web applications. Visual Basic .NET comes with enhanced visual designers, increased application performance, and a powerful integrated development environment (IDE). It also supports creation of applications for wireless, Internet-enabled hand-held devices. The following are the features of Visual Basic .NET with .NET Framework 1.0 and Visual Basic .NET 2003 with .NET Framework 1.1. This also answers why should I use Visual Basic .NET, what can I do with it?
Chapter # 5
Page 26 Project Requirement Specification Govt: Girls Degree College Sukkur
Appearance Appearance section of the properties window allows us to make changes to the appearance of the Button. With the help of BackColor and Background Image properties we can set a background color and a background image to the button. We set the font color and font style for the text that appears on button with ForeColor and the Font property. We change the appearance style of the button with the FlatStyle property. We can change the text that appears on button with the Text property and with the TextAlign property we can set where on the button the text should appear from a predefined set of options.
Debugging VB .NET Applications In this section we will focus on some common issues while debugging our applications and we will take a close look at the Debug Menu Visual Studio .NET provides us. Errors in programming are inevitable. Every one of us introduces errors while coding. Errors are normally referred to as bugs. The process of going through the code to identify the cause of errors and fixing them is called Debugging.
Page 27
Govt: Girls Degree College Sukkur
Chapter # 6
Interface Design
6.1 Administrator Forms application The VB.Net is the pure OOP language and also a event based language so we have used a built in classes and events in our software
Govt: Girls Degree College Sukkur
6.1.1 The Events Used in the Forms 6.1.1.1 Main Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. MainForm.Text b. MainForm.Forecolor c. MainForm.Backcolor d. MainForm.Name
• Event Name o
Label3_MouseEnter
•
Purpose of the Event a. When Mouse comes over the label
•
Procedure Called in the Event a. None
•
Properties used in the event a. None
• Event Name •
o
Label3_MouseLeave
Purpose of the Event a. When mouse leaves the label
Page 29 Chapter # 6
Interface Design
•
Procedure Called in the Event a. None
•
Properties used in the event a. None
Govt: Girls Degree College Sukkur
• Event Name o
Button1_Click
•
Purpose of the Event a. Click on the button
•
Procedure Called in the Event a. None
•
Properties used in the event a. Button1.Text b. Button1.Forecolor c. Button1.Backcolor d. Button1.Name
• Event Name o
MainForm_Resize
•
Purpose of the Event a. Resize the Form
•
Procedure Called in the Event a. None
•
Properties used in the event a. None
• Event Name o
Timer1_Tick
•
Purpose of the Event a. Start the timer
•
Procedure Called in the Event a. None
•
Properties used in the event a. Timer1.tick b. Timer1.Interval
Page 30
Govt: Girls Degree College Sukkur
Chapter # 6
Interface Design
6.1.1.2 Employees Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. EmployeeForm.Text b. Employee.Forecolor c. Employee.Backcolor d. Employee.Name
• Event Name o
AddButton_Click
•
Purpose of the Event a. Clear the Text Boxes
•
Procedure Called in the Event a. Clear
•
Properties used in the event a. AddButton.Text b. AddButton. Fore color c. AddButton. Back color d. AddButton.Name
• Event Name o
SaveButton_Click
•
Purpose of the Event a. Save the Record
•
Procedure Called in the Event a. Save
Page 31 Govt: Girls Degree College Sukkur
Chapter # 6 •
Interface Design
Properties used in the event a. SaveButton.Text b. SaveButton. Fore color c. SaveButton. Back color d. SaveButton.Name
• Event Name o
DeleteButton_Click
•
Purpose of the Event a. Delete The Record
•
Procedure Called in the Event a. Delete
•
Properties used in the event a. Delete Button.Text b. Delete Button. Fore color c. Delete Button. Back color d. Delete Button.Name
6.1.13 Policy Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. PolicyForm.Text b. Policy.Forecolor c. Policy.Backcolor d. Policy.Name
Page 32 Govt: Girls Degree College Sukkur
Chapter # 6
Interface Design
• Event Name o
AddButton_Click
•
Purpose of the Event a. Clear the Text Boxes
•
Procedure Called in the Event a. Clear
•
Properties used in the event a. AddButton.Text b. AddButton. Fore color c. AddButton. Back color d. AddButton.Name
• Event Name o
SaveButton_Click
•
Purpose of the Event a. Save the Record
•
Procedure Called in the Event a. Save
•
Properties used in the event a. SaveButton.Text b. SaveButton. Fore color c. SaveButton. Back color d. SaveButton.Name
• Event Name o
DeleteButton_Click
•
Purpose of the Event a. Delete The Record
•
Procedure Called in the Event a. Delete
•
Properties used in the event a. Delete Button.Text b. Delete Button. Fore color c. Delete Button. Back color d. Delete Button.Name
Govt: Girls Degree College Sukkur
Page 33 Chapter # 6
Interface Design
6.1.1.4 Members Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. MemberForm.Text b. MemberForm.Forecolor c. MemberForm.Backcolor d. MemberForm.Name
• Event Name o
AddButton_Click
•
Purpose of the Event a. Clear the Text Boxes
•
Procedure Called in the Event a. Clear
•
Properties used in the event a. AddButton.Text b. AddButton. Fore color c. AddButton. Back color d. AddButton.Name
• Event Name o
SaveButton_Click
•
Purpose of the Event a. Save the Record
•
Procedure Called in the Event a. Save
•
Properties used in the event a. SaveButton.Text b. SaveButton. Fore color
Govt: Girls Degree College Sukkur
Page 34 Chapter # 6
Interface Design
c. SaveButton. Back color d. SaveButton.Name
• Event Name o
DeleteButton_Click
•
Purpose of the Event a. Delete The Record
•
Procedure Called in the Event a. Delete
•
Properties used in the event a. Delete Button.Text b. Delete Button. Fore color c. Delete Button. Back color d. Delete Button.Name
6.1.1.5 Display All Members Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. DisplayMemberForm.Text b. DisplayMemberForm.Forecolor c. DisplayMemberForm.Backcolor d. DisplayMemberForm.Name
• Event Name o
•
cmdsearch_Click
Purpose of the Event a. Search The Record
Govt: Girls Degree College Sukkur
Page 35 Chapter # 6
Interface Design
•
Procedure Called in the Event a. Search
•
Properties used in the event a. cmdsearch Button.Text b. cmdsearch Button. Fore color c. cmdsearch Button. Back color d. cmdsearch Button.Name
6.1.1.6 Find Form • Event Name o
Form1_Load
•
Purpose of the Event a. When form the connection is opened
•
Procedure Called in the Event a. Connection Object
•
Properties used in the event a. Find Form.Text b. Find Form.Forecolor c. Find form.Backcolor d. Find Form.Name
• Event Name o
cmdsearch_Click
•
Purpose of the Event a. Search The Record
•
Procedure Called in the Event a. Search
•
Properties used in the event a. cmdsearch Button.Text b. cmdsearch Button. Fore color c. cmdsearch Button. Back color d. cmdsearch Button.Name
Govt: Girls Degree College Sukkur
Page 36
Chapter # 7
Testing
7.1 Testing Govt: Girls Degree College Sukkur
Testing is defined as The operation of a functional unit and comparison of its achieved results with the defined results to establish acceptability.
7.2 Testing Strategies A testing strategy is general approach to the testing process. There are number of strategies available. We have applied following strategies to test our software after completion. Event testing Black box testing
7.2.1 Event testing It’s an event based approach where tests are based on the events which trigger system actions. As for our project events are used to perform certain operations. • • • • •
Search button_click() event to search any type of record. Add button_click() event add new data. Delete button_click() event delete the selected record. Save button_click() event save the records. Submit button_click() event doing calculation after get input from user.
7.2.2 black-box testing Black-box testing relies on the specification of this system or component which is being tested to derive test cases. The system is a “black-box” whose behavior can only be determined by studying inputs and related Page 38 Chapter # 7
Testing
Govt: Girls Degree College Sukkur
outputs. It’s called functional testing because mathematical functions can only be proved by specific inputs to calculate outputs. In our project while applying this testing technique, we specified following inputs to study whether required outputs are generated or not. • Enable add button to ensure that this button adds record or not. • Enabled login button to check that it logins to the system or not.
Page 39
Govt: Girls Degree College Sukkur
Chapter # 8
User Guide
8.1 How to run operator forms
Govt: Girls Degree College Sukkur
o Login Form This is login form of insurance system. If user put correct user name and password then login.
Page 41 Chapter # 8
User Guide
o Home Page This is home page of software where all fields are declared. User can open any field and modify that record, find records and doing calculation. Govt: Girls Degree College Sukkur
Page 42 Chapter # 8
User Guide
o Change Login Password
Govt: Girls Degree College Sukkur
To change the login password there is a field named file and click the change login pass. New window will open user type current password and new password. This process changes the change login password.
Page 43 Chapter # 8
User Guide
o Add New Policy
Govt: Girls Degree College Sukkur
To save new record in the field named policy member. There is a field add new policy, click it and new window will open to save new records. User can search any record in this field.
Page 44 Chapter # 8
User Guide
o Policy Detail
Govt: Girls Degree College Sukkur
To show complete detailed information of policy holder.
Page 45 Chapter # 8
User Guide
o Display all
Govt: Girls Degree College Sukkur
To display all records of every table which user wants to see?
Page 46 Chapter # 8
User Guide
o Receive payments
Govt: Girls Degree College Sukkur
To save the important information of receive payment of policy holder. Also display the records.
Page 47 Chapter # 8
User Guide
o Add New
Govt: Girls Degree College Sukkur
To save new record of new employee. Update the record and search any record.
Page 48 Chapter # 8
User Guide
o Find
Govt: Girls Degree College Sukkur
After select any table and put particular fields, to find any record.
Page 49 Chapter # 8
User Guide
o Pay Salary
Govt: Girls Degree College Sukkur
To save record of every employee.
Page 50 Chapter # 8
User Guide
o Premium
Govt: Girls Degree College Sukkur
To calculate premium value of new record.
Page 51 Chapter # 8
User Guide
o Maturity Calculate
Govt: Girls Degree College Sukkur
To calculate the maturity after completion of policy. Add bonuses of maturity.
Page 52 Chapter # 8
User Guide
o User Guide
Govt: Girls Degree College Sukkur
How to use this software? User guide for user understanding.
Page 53 Chapter # 8
User Guide
o About Software
Govt: Girls Degree College Sukkur
About software of Life insurance System.
Page 54 Chapter # 8
User Guide
o Show / Hide
Govt: Girls Degree College Sukkur
This is the option of show or hides the bar.
Page 55 Chapter # 8
User Guide
o Show /Hide
Govt: Girls Degree College Sukkur
After press this button bar will be hiding.
Page 56
Govt: Girls Degree College Sukkur
Chapter # 9
Conclusion And Recommendation
9.1 Conclusion Life insurance system is a single client user database, which shows following capabilities. Client can modify policy information o Add new record Govt: Girls Degree College Sukkur
o Delete records o Save records
Client can search every type of record. Client can change user name and password. Client can calculate premium value of any policy. Client can calculate maturity of policy with bonuses.
9.2 Future Recommendation
Registration and authentication for login using database. Quote sheets are available. All records are saving. Calculation.
Page 58
Govt: Girls Degree College Sukkur
Referred Books Programming VB .NET: A Guide For Experienced Programmers Introducing Microsoft Visual Basic 2005 for Developers
Govt: Girls Degree College Sukkur
Web Sites www.Statelife.com.pk www.startvbdotnet.com www.yahoo.com www.google.com
Other Resources Learning Softwares of VB.NET
Govt: Girls Degree College Sukkur
Related Documents
Project Thesis Of Lis
May 2020 15
Project Thesis
June 2020 3
Project Thesis
May 2020 16
Lis
May 2020 20
Graduation Project: Roverbot - Thesis
May 2020 13