Question

Set up 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 increase a simple system solution. Your systems analysis report have to include the following:

1. Description of problem and its organizational and business impact.

2. Proposed solution, solution objectives, and solution probability.

3. Costs and benefits of 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 solution.

5. Management, organization, and technology issues to be addressed by the solution, including changes in business processes.

On the basis of the requests you have identified, design the database and populate it with at least ten records per table. Consider whether you can use or vary the existing customer database in your design. Print out database design. Then use the system you have created to generate queries and reports that would be of most interest to management. Generate several prototype data input forms for the system and review them with your instructor. After that revise prototypes.