Author Question: Assume a form is created for HAPPY INSURANCE database where a user can perform the following action: ... (Read 67 times)

karen · **on:** Jul 7, 2018

Assume a form is created for HAPPY INSURANCE database where a user can perform the following action:

A user highlights the first row of the CLIENT table and presses the delete key on the keyboard.
Write the SQL statement that will be issued on the user's behalf based on this action.

Question 2

Describe the different ways of categorizing CRM.

What will be an ideal response?

pami445 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

DELETE FROM client
WHERE clientid = 'C111';

Answer to Question 2

There are three general ways of thinking and talking about CRM. First, one can look at CRM purely from a functional perspective. In this view, there are two types of CRM; either sales force automation or customer support related. From a business strategy perspective one can view CRM as a business, technology, or customer relationship initiative. From an implementation perspective, CRM systems can be operational, analytical, or collaborative in their focus. Each perspective helps to explain the complex facets of CRM.