1. System Analysis and Design refers to the procedures of examining or developing business systems with the intent of improving it through industry standard methodology and framework. For this assignment, you will write one report that covers the seven steps in the system analysis and design process based on a hypothetical firm’s business profile. Your report should focus on defining, justifying, and planning the project, and on the tasks associated with testing, implementing, and maintaining the proposes system. Your report should be a minimum of 2,000 words.

Scenario: Backyard Adventures (BA) is a guided tour and water sports rental company in Jacksonville, Florida run by two brothers, Shawn and Harry Weaver. They advertise Backyard Adventures in several local and regional magazines and web sites, but the Weavers don’t feel that it is attracting new business.

BA rents space at a nearby marina, where Shawn runs the office, and handles rentals on the days Harry’s busy with the tour groups. BA has two main business segments: rentals and guided tours but also does some instruction on the side if needed. Customers are required to make reservations in advance for scheduled tours but sometimes space is available for extra customers. Rentals are booked by reservations and walk-in customers.

Melissa Smith, a local college student, handles the telephone inquiries and reservations. Daily she enters the reservations in a binder, with tabs for each business activity. This list is used to back-up the Microsoft Access database that she uses to record reservations. Each morning, she runs a report that will print out the reservation list for the day. Not only does she maintain the reservation database, but she also uses an accounting software to keep BA’s books.

Although the BA database handles the basic information, Harry has noticed some drawbacks. On several occasions the reservations for the tours have conflicted with his availability. Shawn and Harry would like to get information about rental patterns, customer profiles, advertising effectiveness and future business opportunities. They have been talking about either updating their system or replacing it with a new information system that would meet their current and future needs but needs more details on which option is feasible for the company. Your job is to help come up with a plan to address these issues.