Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Background

The British Insurance Company (BIC), is based in Coventry, and was originally setup in 2002 by David and Ellen Stewart, who had just completed their undergraduate degrees. The company has expanded recently and is currently servicing 4 main areas of the UK; these are shown as regions below.

A new information system is envisaged that would capture all of the current information and also provide for any future additions that the system might require.

BIC are offering a range of products Travel insurance, Life Insurance, Motor Insurance along with other types. These are sold to clients by an insurance advisor.

Further Information

The 4 Regions of the UK are indicated below with the number of advisors that are dedicated to that area:

       Region                  Advisors
i) The South-East          4
ii) The South-West        2
iii) The Midlands             3
iv) The North                  3

All of the Insurance Products offered by BIC are sourced (from major Insurance providers) by the Main Office, who then let the Insurance Advisors know which products can be sold on to their Customers, and these advisors also provide a range of Brochures (which describe the products) and Forms (to be completed and signed by the Customers).

There needs to be a HR component of the system would need to record all of the current employees of the company, along with the directors of the company. This would typically contain personal details of the employees (e.g. name, telephone, address, etc).

It is the job of the Insurance Advisors to visit Customers in their homes in order to ascertain their insurance requirements, and to help them fill in the Insurance Forms (some of which are quite complex) that must be completed in order to provide an accurate Insurance Quotation.

New Customers or Existing Customers: Typically will contact one of the Insurance Advisors for the Region, in which they live, this is to arrange such a visit when they need advice on other insurance products.

Each contact with a new or existing customer needs to be recorded into the system, especially details such as whether a follow-up is needed, or whether to send more information, along with information like time, date etc.

First thing every morning, each Insurance Advisor sends any Insurance Forms that they helped their Customers to complete the previous day back to the Head Office in Coventry.

BIC deal with a wide variety of insurance and will web search on behalf of their Customers in order to find the best deal on offer. Once an Insurance Quotation has been find outd it is sent by email directly to the Customer. Upon receipt of an Insurance Quotation, the Customer must then decide if they wish to go ahead with the insurance, in which case they must electronically sign an Acceptance Form and send this, together with their banking details for the full then they simply do nothing.

Upon receipt of a signed Acceptance Form, and accompanying payment, the Insurance Clerks send out the relevant Insurance Certificate to the Customer.

Problems?

BIC are having particular problems with the following areas of their business activity:

Standardising their forms and reports that the advisors use and relaying that information back to the Head Office

Reports at head office need to be generated on a monthly, 6 monthly and yearly basis to assess the success of the advisors, also how well each of the regions are performing.

Understand how well the products are performing in relevant regions. So better decisions can be made in regard to adopting new products and presenting these to customers.

Building up their customer base and accurately recording all the details concerning the customer, the products they have and any other contact information.

Supporting new and existing customers with information to help them decide on the right type of insurance to match their requirements.
The Company directors have requested that the new database be able to carry out the following transactions:

a. Enter the details of a new customer.

b. Enter the details of a new product.

c. Enter the details insurance quotations sent to customers.

d. Enter quotations made by advisors.

e. Record value web-search details of the product that have come to the market

Along with any other features which you deem necessary

Naturally NO CASE STUDY can capture all the details of the operations of the company; you are permitted to make any assumptions (provided you prepare these down).

Task 1

Business Case

Task 1A. Discuss why a relational database would be suitable for this organisation and provide (3) three reasons for this recommendation.

Task 1B.

Discuss using (3) three advantages that a database management system provides to an organisation (300 words).

Requirements Definition

Read the case study carefully, and decide what are the important (key) features of the system. Construct a basic prototype that will display the following:

Task 1C.

List typical reports that would be likely features of the database this requires you to assume the role of the user/manager and list three (3) likely reports he/she might need to do their job. Submit a hardcopy which shows the report, its main features, and then populate it with some likely test data. Submit a hardcopy that has a set of screen shots that illustrate the screen designs.

Note:

A suitable package to do the above task (A to D) would be Microsoft Word or any similar product.

Task 2

Development

Use database development strategy to decide the main elements of the database this will include nominating the:

Fields (also the primary keys and foreign keys)

Tables

Task 2A. Create a Data Dictionary which contains the following: table, field type, field size and field description

Note:

A suitable package to do Task 2B would be Microsoft Word or any similar product.

Database Design

Develop an initial prototype of this case study system, therefore in your design phase you and your team should create the following appropriate diagrams. Use the mysql Workbench (or equivalent tool set) to create the following:

Task 2B. An Entity - Relationship diagram.

Task 2C. Normalised Schema normalise to 3rd normal form. Provide a discussion that shows how you schema passes each of the normal forms.

Note:

A suitable package to do Task 2B would be EDraw, Microsoft Visio or any similar product.

Task 3

Implementation of a Relational Database

Task 3A.

Use the final normalised ER Diagram to create the physical database.

Use mysql server, Oracle Express or an equivalent relational database to create the system. Provide a screen shot of the final system that displays the entire set of tables.

Populate the Database

Task 3B. Enter six (6) records into the system that you can use to display to the client that the system can operate. Provide screenshots of the final system that displays (3) three of the tables with the mock data inserted.

User Help Guide

Task 3C. In order to complete the assignment, you need to provide a user manual that will describe how to use the system. Screenshots of the main menu and navigation between the sub-menus along with accurate descriptions is an important feature of this section of the assignment.

Note: You may use previous screenshots (forms, reports and data screens) to create this manual.

Improvement

Task 3D. Provide a lessons learned log that indicates what you found important and any improvements you wish to make for the next version of the database.

Note:
A suitable package to do Task 3A, Task 3B would be mysql server or any similar product.
A suitable package to do Task 3C, Task 3D would be Microsoft Word or any similar product.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91551

Have any Question? 


Related Questions in DBMS

Unlimited pickers is a group of workers who have joined

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to l ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

Data warehouse1 review the submission hokie resort

Data Warehouse 1. Review the submission Hokie Resort situation description to understand the problem domain(see Business Situation Description below) 2. Write the three most important questions that management must answe ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

Dfd1 draw a context diagram for the fiat for football

DFD 1. Draw a Context Diagram for the FIAT for Football process. 2. Draw a top level Data Flow Diagram for the FIAT for Football method. 3. Blow up any one non-trivial process into a first level Data Flow Diagram.

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

Discussionyou have been asked to help a critical

Discussion You have been asked to help a critical infrastructure company in analyzing the privacy and security of a SCADA system. Conduct research on the topic and answer the following: 1. How would you describe general ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen