Mertel Insurance is implementing a Microsoft® SQL Server® database that will track customer information, policy information, and transaction histories. The biggest concern is providing access to the information each team needs. Sales representatives need to access customer information to better serve their clients. Claims representatives must access policy information to determine coverage. Supervisors would like to access transaction histories to monitor employee performance. Compliance officers often must gather different and varied information for various regulatory agencies. Mertel executives want to monitor key metrics stored in the database to gauge company performance.What methods do you recommend that Mertel Insurance use to retrieve information from its databases? Will you use a custom application or a more generic tool such as SAP® BusinessObjects™ or Microsoft Excel? Would a team of analysts be in charge of running reports and distributing the information? Will the same approach work for all the users? Defend your recommendation.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Mertel Insurance is implementing a Microsoft® SQL Server® database that will track customer information, policy information, and transaction histories. The biggest concern is providing access to the information each team needs. Sales representatives need to access customer information to better serve their clients. Claims representatives must access policy information to determine coverage. Supervisors would like to access transaction histories to monitor employee performance. Compliance officers often must gather different and varied information for various regulatory agencies. Mertel executives want to monitor key metrics stored in the database to gauge company performance.What methods do you recommend that Mertel Insurance use to retrieve information from its databases? Will you use a custom application or a more generic tool such as SAP® BusinessObjects™ or Microsoft Excel? Would a team of analysts be in charge of running reports and distributing the information? Will the same approach work for all the users? Defend your recommendation.

 

 

Expert Solution
Step 1

For Mertel Insurance to retrieve information from its SQL Server database, It is using a combination of methods. Here the

methods are:

Custom application:

A custom application can be developed specifically for Mertel Insurance that provides access to the data based on the

specific needs of each team. For example, the custom application can provide an interface for sales representatives to

access customer information, while providing a separate interface for claims representatives to access policy

information.

Business Intelligence tools:

Tools such as SAP BusinessObjects or Microsoft Excel can be used to retrieve, analyze and present data in a meaningful

way. These tools can provide pre-built dashboards, reports and data visualization to support the needs of different

teams.

Report distribution:

A team of analysts can be in charge of running reports and distributing the information to the relevant teams. This

approach ensures that data is accurate, up-to-date and properly analyzed before being presented to the teams.

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education