Primary Task Response: Within the Discussion Board area, write 400–600 words that respond to the following questions (listed below) with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas:
Before you start this assignment, please read the story entitled Joe’s Sporting Goods Reporting. This can be found in the Relational Database Languages MUSE. This can also be found in your text materials for Week 3.
This is a direct link to Joe’s Sporting Goods Reporting.
After reviewing the story, conduct research online into the various possibilities for analyzing and approaching the system documentation problems presented and propose possible solutions. Address the following:
- Discuss the specific recommendations that you would make based on your personal experience and research.
- Discuss the impact (from the perspective of various stakeholders) of the lack of documentation.
- How can technology be used as an enabler and facilitator of effective documentation procedures and processes?
- Provide specific examples of how you would solve the documentation problems, and provide a rationale for your suggestions.
- How can you apply the lessons that you learned from the story to your own retail store problem?
- Provide feedback on the recommendations that your classmates made.
Responses to Other Students: Respond to at least 2 of your fellow classmates with at least a 100-word reply about their Primary Task Response regarding items you found to be compelling and enlightening. To help you with your discussion, please consider the following questions:
- What did you learn from your classmates’ suggestions for solving the problem?
- What additional questions do you have after reading the suggested techniques for solving the problem?
- What clarification do you need regarding the method for solving the problem?
- What differences or similarities do you see between your problem-solving technique and that of other classmates?
Primary Task Response: Within the Discussion Board area, write 400–600 words that respond to the following questions (listed below) with your thoughts, ideas, and comments. This will be the foundation
Story: Sporting Goods S tore Reporting 1 Joe’s company, a small sporting goods company, conducts a high volume of business on a daily basis. Although business has been good, he suspects that the competition may have an advantage over him; however, this feeling cannot be translated into something worthwhile. Although the company has been using a relational database system to manage its business, getting the data into the system has proven to be much easier than getting data out of the system. Apparently, the system designers did not include all of the necessary tables that are needed to store the information that is necessary to run the business effectively. Unfortunately, none of the scripts that were used to create the system and run the necessary reports were documented anywhere. This lack of doc umentation will make it expensive to bring another information technology (IT) consultant in to assess the situation because of the amount of time it will take in researching the system capabilities. As a business owner, Joe knows what goals and objectives he wants to accomplish with his business. However, he has found it difficult to make solid business decisions because the system never generates the reports that he wants or needs. He is frustrated because he invested a lot of money into the system about a year ago; yet he feels like he makes decisions more by gut feeling than by actual data that he pulls from the system. He knows that his competition has an internal IT staff that can run the reports that are needed, and because of this, Joe feels that his competition could eventually run him out of business. Joe does not even know what information the database is actually storing (or capable of storing), and he feels that he could make better use of his system if he had an idea as to what capabilities it p ossessed. Joe also voiced concern over his inability to fully understand the state of his business. He felt foolish when certain questions from shareholders came up about the financial state of the business, and he was not able to answer with any reasonabl e certainty or accuracy. Moral of the Story All of the scripts that are needed to create the database schema, select data from the system for reporting purposes, and that are used to support the front -end graphical user interface must be documented clearl y and concisely. The technical part of the system needs to be documented using terminology that is common to database designers, and the end -user documentation must be written in such a way that the nontechnical employee can understand what the system is c apable of. By having the end stakeholders make a list of reports that they want, a matching report name that the system provides can assist users in identifying which report matches their needs at a given time. This is especially beneficial when the missio n and goals of the owner clearly state what reports will provide the information that is needed to make effective business decisions. A checklist that matches the mission and goals with the system capabilities can serve as a tool for ensuring that the syst em is doing its job.