RFM Analysis sample includes scripts to build a new sample database that can be used to run the RFM analysis on

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

RFM ANALYSIS SAMPLE

 

This RFM Analysis sample includes scripts to build a new sample database that can be used to run the RFM analysis on. Below is a list of the SQL scripts and their purpose. Open the SQL files in SQL Server Management Studio and execute them in order.

 

Step 1: 

Create sample JONESCO database and load data.

1. 1-CREATE.SQL 

2. 2-INSERT.SQL

 

Step 2:

Create RFM Analysis Objects

1. 1-RFM-CREATE_RFM_TABLES.sql

2. 2-RFM-CREATE-SPROCS.sql

3. 3-RFM-SALES.sql

4. 4-RUN-RFM.sql

5. 5-VIEW-RFM.sql

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of