Prepare a systems analysis report detailing Ace's problem and a system solution that can be implemented using PC database management software. Then use database software to develop a simple system solution. Your systems analysis report should include the following:
1. Description of the problem and its organizational and business impact.
2. Proposed solution, solution objectives, and solution feasibility.
3. Costs and benefits of the solution you have selected. The company has a PC with Internet access and the full suite of Microsoft Office desktop productivity tools.
4. Information requirements to be addressed by the solution.
5. Management, organization, and technology issues to be addressed by the solution, including changes in business processes.
On the basis of the requirements you have identified, design the database and populate it with at least 10 records per table. Consider whether you can use or modify the existing customer database in your design. Print out the database design. Then use the system you have created to generate queries and reports that would be of most interest to management. Create several prototype data input forms for the system and review them with your instructor. Then revise the prototypes.
The example solution file represents one of many alternative database designs that would satisfy Ace's requirements. This file can be found in the Microsoft Access file named: MIS12ch13 solutionfile.mdb.