Garys Consultancy Firm, Inc. operates accounting and financial consultancy centres in a number of regions in Queensland and the main head office is in Toowoomba. The centres have done well, and the company is planning to improve their business information system and to develop a web-based system. William is the owner of the firm and he runs the firm for last 10 years. Gary discussed with IT manager, Mary Peter, to develop a new information system for the company. During the project, Mary will work closely with Patrick Lewis, who will manage the new project. This new information system will support its business and information management and replace a mix of paper-based and legacy systems.

You are enjoying your job as a junior IT help desk at Garys firm. Last week, Mary asked you to help her plan the new information system project. Mary knows that you have completed studying several information systems courses at USQ, and that you have studied project management tools and techniques as well.

Specifically, she wants you to get ready for the next set of systems development tasks, which will be requirements modeling for the new system. Yesterday, Mary called you into her office to discuss the specific tasks she wants you to perform. You will explore the possibility of a business support system for the scheduling, billing, accounting, HR and payroll functions of the practice as well as a system to support the accounting applications of Customer Taxation records and Supplier records so that it allows each office worker to conduct their job more efficiently.

After meeting with Mary, you sit down and review your notes. She wants you to treat the set of tasks as a project, and to use project management skills to plan the tasks. You began the systems analysis phase at Garys consultancy firm by completing a series of interviews, reviewing existing reports, and observing office operations. You also acquired more information and developed a set of DFDs, process descriptions, and a data dictionary. The next step in the SDLC is to perform an object-oriented analysis of the new system.

Based on Marys analysis and your report, Gary decides to move forward with in house development of a new business support system.

Question 2 (10 marks)

2.1) Many organizations have had their database system hacked and customer data were stolen. Identify the precautions that Gary needs to take to make the database secure (5 marks)

2.2) According to the case study, you need to submit an investigation report to Gary. When designing reports, the essential goal is to match the report to Garys specific information needs. Which type of report you would choose and justify (5 marks)