Problem Statements Pro.ect: Member services information system Project manager: Sandra Shepherd Created by: Sandra Shepherd Last updated by: Robert Martinez Date created: January 9, 2003 Date last updated: January 15, 2003 Brief Statements of Problem, Opportunity, or Directive Proposed Solution Annual Priority or Rank Urgency Visibility Benefits 1. Order response time as measured from time of order receipt to time of cus- tomer delivery has increased to an average of 15 days. ASAP High $175,000 New development 2. The recent acquisitions of Private Screenings Video Club and Game- Screen will further stress the through- put requirements for the aurrent system. 6 months Med 75,000 New development 6 months New development 3. Currently, three different order entry systems service the audio, video, and game divisions. Each system is de- signed to interface with a different warehousing system; therefore, the intent to merge inventory into a single warehouse has been delayed. Med 515,000 After new system is developed, provide 4. There is a general lack of access to management and decision-making information. This will become ex- asperated by the acquisition of two additional order processing systems (from Private Screenings and Game- Screen). 12 months Low 15,000 3 users with easy-to-leam and use reporting tools. 5. There currently exist data incon- 3 months High 35,000 Quick fix then new sistencies in the member and order development files. 6. The Private Screenings and GameScreen file systems are incompatible with the SoundStage equivalents. Business data problems 6 months New development. Additioral quanti- Med Unknown fication of benefit might increase include data inconsistencies and lack urgency. of input edit controls. 7. There is an opportunity to open arder systems to the Internet, but security 12 months Low Unknown Future version of newly developed system and control are an issue. 8. The current order entry system is incompatible with the forthcoming automatic identification (bar-coding) system being developed for the warehouse. 65,000 Quick fix then new development 3 months High FIGURE 5-8 Sample Problem Statements

Problem Statements Pro.ect: Member services information system Project manager: Sandra Shepherd Created by: Sandra Shepherd Last updated by: Robert Martinez Date created: January 9, 2003 Date last updated: January 15, 2003 Brief Statements of Problem, Opportunity, or Directive Proposed Solution Annual Priority or Rank Urgency Visibility Benefits 1. Order response time as measured from time of order receipt to time of cus- tomer delivery has increased to an average of 15 days. ASAP High $175,000 New development 2. The recent acquisitions of Private Screenings Video Club and Game- Screen will further stress the through- put requirements for the aurrent system. 6 months Med 75,000 New development 6 months New development 3. Currently, three different order entry systems service the audio, video, and game divisions. Each system is de- signed to interface with a different warehousing system; therefore, the intent to merge inventory into a single warehouse has been delayed. Med 515,000 After new system is developed, provide 4. There is a general lack of access to management and decision-making information. This will become ex- asperated by the acquisition of two additional order processing systems (from Private Screenings and Game- Screen). 12 months Low 15,000 3 users with easy-to-leam and use reporting tools. 5. There currently exist data incon- 3 months High 35,000 Quick fix then new sistencies in the member and order development files. 6. The Private Screenings and GameScreen file systems are incompatible with the SoundStage equivalents. Business data problems 6 months New development. Additioral quanti- Med Unknown fication of benefit might increase include data inconsistencies and lack urgency. of input edit controls. 7. There is an opportunity to open arder systems to the Internet, but security 12 months Low Unknown Future version of newly developed system and control are an issue. 8. The current order entry system is incompatible with the forthcoming automatic identification (bar-coding) system being developed for the warehouse. 65,000 Quick fix then new development 3 months High FIGURE 5-8 Sample Problem Statements

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 6P

See similar textbooks