Explore BrainMass

Explore BrainMass

    Decision Support System Application

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED 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 March 4, 2021, 7:41 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 ...