INFS 4950 Project

Your Name:___________________________

INFS 4950 Project Topic and Description

In the INFS 4950 final project you are required to either (1) complete a web application for the MountainGoat Outfitters retail store using the Web Application starter files and database provided in D2L, or (3) select a Web Application to develop of your choice.

If you choose to complete the development of the MountainGoat Outfitters application, you will need to come up with four user stories to implement. These user stories could be selected or modified from the list of user stories provided below, or you may come up with your own user stories for the MountainGoat Outfitters application. You need to complete at least 4 user stories to fulfill the requirements for this project. The first user story is provided for you and includes the functionality of adding, updating, and deleting data in a database table (covered in chapter 4 of your textbook). This user story is required.

**Very Important Note: If you choose to develop a Web Application other than MountainGoat Outfitters, you will also need to create the SQL Database for your proposed Web Application. The development of a SQL Database will count as 2 user stories.

Please place an “X” beside the option you choose for the final project

_____ I choose to develop the MountainGoat Outfitters starter files and database provided here D2L.

List at least 4 User Stories that you plan to develop for MountainGoat Outfitters

1. As an Administrator of MountainGoat Outfitters, I need to add, edit, and delete employee information so that I can keep the most current and accurate information about my employees in the system.

2. ______________________________________________________

3. ______________________________________________________

4. ______________________________________________________

NOTE: Some examples of User Stories that you may choose from (but are not limited to) include the following. You may reword the User Stories as you see fit. Also, please feel free to be creative and come up with your own user stories. Think about what an end-user (whether an administrator or other end-user) at MountainGoat Outfitters might want in this web application and base your user stories upon your own perspective and evaluation.

1. As an administrator of MountainGoat Outfitters, I would like to generate a list of all my customers with their email addresses so that I can send them the latest promotion events at our stores.

2. As an administrator of MountainGoat Outfitters, I would like to view a list of all my products (items) along with their categories so that I can have a reference to all the products we sell.

3. As an administrator of MountainGoat Outfitters, I would like to have the option to filter my list of products by the categories of Backpacks, Sleeping Bags, and Tents so that I can evaluate the portfolio of products we carry within each of these three categories. (Note: you could add this filtering option to the web page you created for user story #2)

4. As an administrator of MountainGoat Outfitters, I would like to view a list of all my employees and be able to filter the list by position (Manager, Buyer/Seller, and Seller) so that I can evaluate my human resources in each of these positions.

5. As an administrator of MountainGoat Outfitters, I would like to view a list of all my customers and have the option to filter this list by the state of Tennessee and in North Carolina so that I can evaluate my customer base in each of the states.

6. As an administrator of MountainGoat Outfitters, I would like to add, edit, and delete category information so that I can keep the most current and accurate information about the categories of products I sell.

7. As an administrator of MountainGoat Outfitters, I would like to view a list of products that are priced above a specified amount so that I can readily identify products that are selling at various prices and tailor sales and promotions to align with these items.

8. As an administrator of MountainGoat Outfitters, I would like to view a list of products and have the products filtered by city so that I can evaluate how products are selling in each city.

9. As an administrator of MountainGoat Outfitters, I would like to view a list of my employees, commission rates, and commission dollar amount based upon their sales, so that I can evaluate the commission expense allocated to my selling staff.

10. As an administrator of MountainGoat Outfitters, I would like to view a list of products and quantities sold sorted in decreasing order by purchase date so that I can evaluate how well products are currently selling.

11. As an administrator of MountainGoat Outfitters, I would like to view total sales by category to evaluate how my sales are allocated in each category.

12. As an administrator of MountainGoat Outfitters, I would like to view total purchases and sales filtered by category to help evaluate the profitability of each category.

_____ I choose to select a different Web Application to develop. The title of the Web Application I will develop is:​​​​​​​​​​​​​​​​​​​​​__________________________________________________. I understand that I will need to develop my own SQL Server database for this application.

Include a short description of the Web Application you will be developing here:

Proposed User Stories (include at least 2 user stories) for the Project (Short Description of each Use Case)

User Story 1: As a _____________, I would like to add, edit, and delete ______________ information so that I can keep the most current and accurate information about _______________ in the system.

User Story 2: