In the final project for this course, you will imagine that you are an IT business analyst intern at Sharpe Style in the scenario provided and have been asked by the owner to research options for improving the business’s performance through the use of technology. Specifically, the owner wants to expand the business’s retail presence into online sales and ensure a positive customer experience by incorporating intelligent systems into the website. You will create a business report for business owner Mary Sharpe that analyzes the business’s stated and anticipated technology and information system requirements, compares and contrasts different technology solutions available, and provides suggestions on technology opportunities that would support the business venture. You should explain in detail how the different options could help grow the business and/or improve operational efficiency and client satisfaction, using real-world examples and references to support the suggestions. You should also keep in mind that the business owner is not a technology specialist. Consequently, you should use nontechnical language in crafting the business report and remember that the owner may not always know what technology is needed to carry out a particular option or how much it costs.

Prompt: For Milestone Two, you will be assessing the database needs and options for Sharpe Style. After looking at how the SDLC applies to your final project, a good next step is looking at the data. Think small and see where your requirements take you. Remember that Mary is worried about how she will keep track of her inventory when she migrates into online sales. You will be using the Milestone Two section of the template to complete this assignment. Refer to the Sharpe Style scenario for details on the current state of the company and the business owner’s goals. Based on what you have learned in Module Three, assess the type of database technology the company will need to support new online services. Once you have established the company’s needs, you should research the available options. Present a minimum of two. Keep in mind that Mary Sharpe is looking for an inexpensive and easy-to-implement solution. What are the pros and cons of each option?

For this assignment, find a real-world example of what has or has not worked for another company. Talk about how this example informs the options you will present to Mary Sharpe. Make sure you site your source(s) appropriately. Remember that you are an intern and are not expected to make suggestions that encompass a deep level of technical detail. You are expected to provide a highlevel view of what would be required to help your business owner make an informed decision regarding database needs for online services. Use the Milestone Two section of the template and submit the template to your instructor for feedback and grading. Remember to incorporate instructor feedback before your final submission in Module Seven. Specifically, the following critical elements must be addressed: II. Database Needs and Options: Use this section of your report to assess the business’s database needs with respect to the proposed expansion into online sales, and lay out possible solutions for meeting the needs you identified. Specifically, you should address the following:

A. What type of database technology will the company need to support the new online services? Explain your answer. For example, how will the company keep track of inventory and customer information for sales in the retail versus the online store? Will two separate databases be needed? Will the company need to integrate its database(s) with other software to serve intelligent functions such as inventory tracking, order tracking, or payments?

B. Weigh the pros and cons of different solutions for addressing database needs in general terms. Justify your response. For example, will the option require migrating data to a new system? Will it require a different server setup? Is the cost of the solution outweighed by the potential benefits in terms of improving efficiency and increasing sales? To illustrate your point(s), you may want to include real-world examples of what has or has not worked for other companies.

Answer rating: 100% (QA)

There are two separate use cases Data Storage keep track of the inventory Warehouse RDBMS type of DB... View the full answer