This project is a computer system that will be used in an Insurance Brokers' office. The system is split into two parts. The first part of the program is the In-House Broker System (IHBS), which is to be used by the staff. The second part is the On-Line Quote System (OLQS), which can be used by anybody on-line. The OLQS enables clients or potential clients to instantly obtain motor or household quotes on-line.
The product enables the client to automatically receive the quote on-line. The client fills out the quote and, upon completion, they can purchase the quote using a credit card, they can reject the quote, or they can save the quote so they can come back to it later, in which case the quote is recalculated.
The IHBS will be used by the employees to add new clients, and to manage existing clients, take quotes (motor/household), manage the accounts and generate reports/letters for all departments. Letters are automatically filled out using the mail merge feature in Word, and reports are automatically formatted in Access. The reports have basic calculations done. Behind this system, there is a MSSQL Database running on a MMSQL Server.
The project has been planned to be having the view of distributed architecture, with centralized storage of the database. The application for the storage of the data has been planned. Using the constructs of MS-SQLServer and all the user interfaces have been designed using the ASP.Net technologies. The database connectivity is planned using the "SQL Connection" methodology.
The standards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff
The modules involved in this project are:
In-House Broker System (IHBS)
On-Line Quote System (OLQS)
Hardware Requirements :
Processor Pentium-III Intel 80486
Clock speed 800 MHZ or above
RAM 512 MB Ram or above
Monitor 15'' Color
HDD 20 GB
FDD 1.44 MB
CD drive LG 52X
Keyboard Standard 102 keys
Mouse 3 buttons
Software Requirements :
Servers - Microsoft Windows 2000, Microsoft SQL Server/ORACLE
Clients - Microsoft Internet Explorer and also FireFox, NetScape etc
Tools - Microsoft Visual Studio.NET
Services - ASP.NET XML Web Services
Languages - C#.NET/VB.NET