Info Systems Analysis & Design

MountainGoat Outfitters

MountainGoat Outfitters recently started business selling a variety of skiing, biking, hiking, and camping gear from a retail store located in Gatlinburg, TN. MountainGoat Outfitters’ mission is to provide customers with “the best gear at the best price” for exploring the surrounding Smoky Mountains. The owner of MountainGoat Outfitters would like to collect data on their operating activities in a database and have a web-based interface for interacting with this data. You were asked to develop this for MountainGoat Outfitters. However, the owner wants to see a prototype of the system before she commits to funding the entire development project.

MountainGoat Outfitters has a variety of items that need to be categorized for ease of inventory and sales monitoring. Each item must fall into one of their product categories (e.g. Downhill skis, tents, backpacks). Each item is grouped into a product category, has a unique stock keeping unit (SKU) product identifier assigned by MountainGoat Outfitters, a description of the product, and finally the current retail price. The sales that MountainGoat Outfitters makes to customers in its store must also be recorded. At this time, the store does not have any repair or maintenance services so item sales are the only aspect that need to be considered for sales. Similar to purchases, each sale could include various items and multiple quantities but only from one customer and one sales employee. When hired, each employee is assigned their employee identification code and negotiates a commission rate. This commission percentage needs to be recorded so the company can calculate each employee’s compensation based on their sales. MountainGoat Outfitters would also like to distribute mailers, emails, or catalogs in the future to previous customers; therefore, it collects contact information for each customer. It is important for management and staff to extract or filter information to answer questions about the business. MountainGoat Outfitters has a variety of questions that will need to be answered by the system. Questions include but are not limited to: “What are the details about our customers?”, “Which category of products is most popular for customers residing in Nashville?”, and “How much do we owe in commissions?”. There are likely to be many other questions that will need answered as well. Only the management should be able to receive answers to some questions.