Explore BrainMass

Decision Support System Application

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Write a paper demonstrating the application of your chosen DSS to a specific problem or set of problems. Include the role of the following components of a DSS as they pertain to your system: -description of the situation, intended users, database, and model base.

© BrainMass Inc. brainmass.com October 24, 2018, 9:04 pm ad1c9bdddf

Solution Preview

Footwear - Decision Support System 1
Description of the situation 1
Data Warehouse - Database, and Model Base 2
Logical database design 3
Physical database design 4

Footwear - Decision Support System

A fictitious firm, Footwear manufactures footwear and sells through two channels:
 Directly to customers and
 Through resellers.

Description of the situation
Footwear's marketing executives (these are intended users) need to extract the following information from the company's aggregate business data:
 The five states reporting the highest increases in youth product category sales within the past year,
 Total footwear sales in Baltimore City within the past month by product family,
 The 50 cities with the highest number of unique customers, and
 One million customers who are most likely to buy the new Walk-on-Air shoe model.

To build a system that provides this decision support information, the system analysts needs to address and resolve three fundamental issues:
 What data to gather and how to conceptually model the data and manage its storage,
 How to analyze the data, and
 How to efficiently load data from several independent sources.

These issues correlate to a decision support system's three principal components (see, Figure 1):
 A data warehouse server,
 Online analytical processing and data mining tools, and
 Back-end tools for populating ...

See Also This Related BrainMass Solution

Urgent: Managerial Accounting: Computerized Manufacturing System (Case)

You, H.H. Hilton, have just been hired by a small manufacturing firm. One of your talents that they sought to acquire was knowledge of, and ability to implement, and automated production system for the firm. Describe the system you would implement for this firm that produces only two products using raw materials, labor, and of course overhead.

View Full Posting Details