Ivey Publishing

Systems Analysis and Design Methods

Whitten, J.L., Bentley, L.D.,7/e (United States, McGraw-Hill Irwin, 2007)
Prepared By Mike Moffatt et al, Ph.D. Student, (Management Science)
Chapter and Title Chapter Matches: Case Information
Chapter 1:
The Context of Systems Analysis and Design Methods

CANADIAN FIREARMS PROGRAM
Derrick Neufeld, Zeying Wan

Product Number: 9B06E007
Publication Date: 2/16/2006
Revision Date: 9/17/2009
Length: 12 pages

The Canadian firearms program initially was established to set up a shared database. However, increasing costs of the firearms program is a concern for a number of Canadians. Should the federal government continue with the program, de-escalate or cancel the program. The case requires students to simultaneously evaluate the issues of the database design, software outsourcing, IS project management and change management. It can also be used to cover cost analysis, and political influences in decision-making.

Teaching Note: 8B06E07 (7 pages)
Industry: Public Administration
Issues: Politics; Cost Control; Information Systems; Project Management
Difficulty: 4 - Undergraduate/MBA


Chapter 2:
Information Systems Building Blocks

DEVELOPING INFORMATION SYSTEMS - AN EXERCISE WITH BUILDING BLOCKS
Deborah Compeau, Barbara L. Marcolin

Product Number: 9B04E025
Publication Date: 10/13/2004
Revision Date: 10/9/2009
Length: 1 pages

In teams of four to six people, each team works to develop a structure using building blocks. Various alterations to the terms of the assignment are made as the exercise unfolds, simulating the unpredictability of information systems development. Difference in the technology available to teams (both in terms of amount and type) simulate the challenge of differences in technology resources and later the challenge of integration, even with standard and simple technology.

Teaching Note: 8B04E25 (11 pages)
Issues: Information System Design; Systems Analysis; Information Systems
Difficulty: 4 - Undergraduate/MBA


Chapter 3:
Information Systems Development

KL WORLDWIDE ENTERPRISES, INC.: PUTTING IT TO WORK
Richard M. Kesner

Product Number: 9B05E023
Publication Date: 1/13/2006
Revision Date: 11/11/2015
Length: 21 pages

The KL Worldwide Enterprises Inc. case provides a rich context within which to explore the information technology (IT) issues that confront a global enterprise engaged in the manufacture, sales, and distribution of durable goods. The primary purpose is to give students a real-world, hands-on simulation of an IT systems development process that spans the entire lifecycle of an IT project from initial project scoping and justification through acceptance testing and deployment. The KL case emphasizes the design and delivery of enterprise resource planning, supply-chain management, decision support system, and e-commerce solutions for both for-profit and not-for-profit organizations. The case leads the reader into a consideration of the many opportunities to improve KL’s performance through the better design and integration of IT-enabled processes and services, including designing a new e-commerce or DSS capability and reengineering KL’s supply-chain and product design practices.

Teaching Note: 8B05E23 (9 pages)
Industry: Manufacturing
Issues: Operations Management; E-Commerce; Information System Design; Information Systems; Northeastern
Difficulty: 4 - Undergraduate/MBA


Chapter 4:
Project Management

RBC INVESTMENTS: PORTFOLIO PLANNING INITIATIVE
Derrick Neufeld

Product Number: 9B05E005
Publication Date: 4/11/2005
Revision Date: 10/20/2010
Length: 11 pages

The newly hired head of Strategic Resources Planning and Management at Royal Bank of Canada Investments (RBCI) must develop a dashboard mechanism for strategically assessing and managing RBCI's non-interest expenses, excluding brokerage fees associated with providing value-added service to clients. After a week of analysis, two things became apparent; first, the four major business units within RBCI were operating independently, neither collaborating on projects nor sharing information. Second, most of the non-interest expenses spent was related to information technology projects. Consider that RBCI was spending nearly $700,000 per day on service delivery, the senior management team was extremely eager to see what the head of Strategic Resources Planning and Management would propose. This case presents information technology portfolio management challenges facing large organizations, and challenges students to develop performance metrics that will be useful at the most senior levels of the organization.

Teaching Note: 8B05E05 (18 pages)
Industry: Finance and Insurance
Issues: Portfolio Management; Planning; Information Systems; Cost Control
Difficulty: 4 - Undergraduate/MBA


Chapter 5:
Systems Analysis

GOLDEN TULIP
Deborah Compeau, Darren Meister

Product Number: 9B04E022
Publication Date: 9/20/2004
Revision Date: 10/9/2009
Length: 5 pages

Golden Tulip is a small hotel that provides a unique hotel experience for business and pleasure travelers. The owner was concerned about the decrease in occupancy and hired an independent consultant, who must complete the analysis and design task for a new information system that would address promotion and reservation concerns.

Teaching Note: 8B04E22 (6 pages)
Industry: Accommodation & Food Services
Issues: System Design; Managing a Small Firm; Management Information Systems; Systems Analysis
Difficulty: 4 - Undergraduate/MBA


Chapter 6:
Fact-Finding Techniques for Discovery

INTERNET BANKING PROJECT IN INDUSTRIAL AND COMMERCIAL BANK OF CHINA (SHANGHAI)
Darren Meister, Lihua Huang, Yulin Fang, Yun Zhang

Product Number: 9B04E024
Publication Date: 9/20/2004
Revision Date: 10/9/2009
Length: 20 pages

The Industrial and Commercial Bank of China’s Shanghai branch has successfully launched its Internet-based private banking service. The vice director of e-banking felt that the project was a success in terms of schedule and quality, and he needed to present his experiences and lessons learned to senior management. Of particular importance were the e-banking system’s benefits to users, the consumer profile, impacts on the bank’s performance, and factors influencing the effective implementation of the system.

Teaching Note: 8B04E24 (10 pages)
Industry: Finance and Insurance
Issues: Computer System Implementation; Information System Design; Feasibility Analysis; e-banking; China
Difficulty: 4 - Undergraduate/MBA


Chapter 7:
Modeling Systems Requirements with Use Cases

SHANGHAI BELL - THE COLLABORATIVE PRODUCT COMMERCE SYSTEM (CPC)
Darren Meister, Yulin Fang, Jianguo Jia

Product Number: 9B04E023
Publication Date: 9/20/2004
Revision Date: 10/9/2009
Length: 19 pages

The research and development improvement manager at Shanghai Bell, a major telecommunications device manufacturer in China, has just finished a meeting with top management on strategic initiatives suggested in the corporate information systems plan report. One project that was suggested in the report — implementing a collaborative product commerce (CPC) system — is about to begin. The manager must review the project planning process and examine the extent to which the company, a European-Chinese joint venture, is ready to undertake the project.

Teaching Note: 8B04E23 (12 pages)
Industry: Manufacturing
Issues: Computer Systems Implementation; Information Systems Design; Feasibility Analysis; Telecommunications; China and Europe
Difficulty: 4 - Undergraduate/MBA


Chapter 8:
Data Modelling and Analysis

KNOWLEDGE MANAGEMENT AT ACCENTURE
Darren Meister

Product Number: 9B05E018
Publication Date: 11/28/2005
Revision Date: 10/9/2009
Length: 17 pages

Accenture has long been seen as a leader in knowledge management, having received awards for many years. Over the years though, islands of knowledge have developed throughout the organization and the delivery infrastructure has become progressively more expensive. In 2004, the global knowledge management lead has been given the mandate to lead a revitalization of knowledge management. This case outlines governance challenges in the global firm, the transition to a new IT infrastructure and the strategic challenges and opportunities facing knowledge management within Accenture.

Teaching Note: 8B05E018 (5 pages)
Industry: Administrative, Support, Waste Management and Remediation Services
Issues: Technological Change; Consulting; Knowledge Based Systems; Knowledge Management
Difficulty: 4 - Undergraduate/MBA


Chapter 9:
Process Modeling

COMPUTER SCHOOL'S.NET PROJECT (A)
Nicole R.D. Haggerty, Noah Ivers

Product Number: 9B04E005
Publication Date: 3/4/2004
Revision Date: 10/9/2009
Length: 13 pages

Computer School is a large post-secondary, career-focused education firm. The chief executive officer of the school has determined that the IT department is in a state of disarray. The IT department was not identified as part of the core business strategy but is deemed as fundamental to the operation of the organization. Before proceeding with growth strategy, the CEO knew that gaining control of this department and establishing procedures for managing these resources more effectively would be an important aspect of laying the foundation for growth.

Teaching Note: 8B04E05 (6 pages)
Industry: Educational Services
Issues: Management Information Systems; Management of Technology; Management of Professionals; Information Systems
Difficulty: 4 - Undergraduate/MBA


Chapter 10:
Object-Oriented Analysis and Modeling Using the UML

BUSINESS INTELLIGENCE STRATEGY AT CANADIAN TIRE
Nicole R.D. Haggerty, Darren Meister

Product Number: 9B03E019
Publication Date: 11/5/2003
Revision Date: 10/19/2009
Length: 13 pages

Canadian Tire Corporation consists of five main business groups: a large retail chain providing automotive parts, sports and leisure and home products; a financial division; a petroleum division; a specialty automotive parts division; and a retailer of casual and work wear clothing. The information technology group is faced with developing an implementation plan for the development of a business intelligence infrastructure and business capability at Canadian Tire Retail. Concurrent to this initiative is the development and implementation of an information technology strategy for Canadian Tire Corporation, which places a number of programs on the priority list, with business intelligence seen as a high priority item for which the organization can score some quick win business success.

Teaching Note: 8B03E19 (6 pages)
Industry: Retail Trade
Issues: Information Systems; Business Intelligence; Knowledge Based Systems; Information System Design
Difficulty: 4 - Undergraduate/MBA


Chapter 11:
Feasibility Analysis and the System Proposal

EDUCATION STORE
Barbara L. Marcolin, Frank Thirkettle, Chris Nelson

Product Number: 9B03E022
Publication Date: 11/28/2003
Revision Date: 10/21/2009
Length: 11 pages

The Education Store reviewed and provided sales of educational software for children in kindergarten to grade 12. The store took its direction from the local board of education and functioned with the administrative system of the school board but operated independently and was relatively free to make day-to-day decisions. The manager of the Education Store felt the existing database no longer kept up with the store's needs. A database designer had two weeks to analyze the store's requirements and develop a prototype. From the information he had, he wondered whether this task was an upgrade or a complete redesign. He must also look at a number of design issues, and who would ultimately maintain the database.

Teaching Note: 8B03E22 (13 pages)
Industry: Educational Services
Issues: Management Information Systems; Information System Design; System Design; Models
Difficulty: 4 - Undergraduate/MBA


Chapter 12:
Systems Design

BIG SERVER SOFTWARE
Michael Parent, Ken Mark

Product Number: 9B03E014
Publication Date: 5/28/2003
Revision Date: 10/19/2009
Length: 9 pages

The founder and president of Big Server Software has spent 12 years building his database software company. He now faces difficult decisions about how to take the company to the next level. Despite a string of minor successes and some failures, he believes that his product, a semantic database, represents the next and improved generation of database software. He must devise a plan to get his company going.

Teaching Note: 8B03E14 (8 pages)
Industry: Administrative, Support, Waste Management and Remediation Services
Issues: Market Entry; Startups; E-Commerce; Strategic Planning
Difficulty: 4 - Undergraduate/MBA


Chapter 13:
Application Architecture and Modeling

LONDON JETS
Michael R. Pearce, Joel Bycraft, Chad Hensler

Product Number: 9B02A022
Publication Date: 11/29/2002
Revision Date: 10/28/2009
Length: 11 pages

The marketing manager for a hockey team has been told by senior management that revenues for the next season must increase or the franchise will be sold. The previous year's high-budget advertising campaign did not bring in the single-ticket sales results he expected. A database of past ticket holders is available and the question arises how to use this database. Using pivot tables, and recency, frequency and monetary value analyses, he must determine how to increase the return on the marketing investment. An Excel spreadsheet, product 7B02A022, is also available.

Teaching Note: 8B02A22 (26 pages)
Industry: Arts, Entertainment, Sports and Recreation
Issues: Database Marketing; Sports Marketing; Analysis; Direct Marketing
Difficulty: 4 - Undergraduate/MBA


Chapter 14:
Database Design

TYNER-SHORTEN CLOTHIERS (CONDENSED): ACQUIRING PC HARDWARE AND SOFTWARE
Michael Parent, Sean Van Doorselaer

Product Number: 9A97E014
Publication Date: 10/17/1997
Revision Date: 2/3/2010
Length: 9 pages

Tyner-Shorten is a small, high-end men's clothing retail store looking to automate its client database in order to market itself more effectively to a growing clientele in a highly competitive market. The owner-managers of the store are looking to acquire a PC-based system. The case considers both the hardware and software decisions. In the case of hardware, the men must decide whether to purchase an integrated, turnkey system or a stand-alone PC. If the latter, two choices are presented: a technologically obsolete, but currently adequate PC, or a state-of-the-art PC. For software, the owner-managers must decide whether to build their own application using MS-Access, or to buy a standard, off-the-shelf package - the traditional make-buy decision.

Teaching Note: 8A97E14 (11 pages)
Industry: Retail Trade
Issues: Computer Applications; Computer Selection; Small Business; Information Systems
Difficulty: 4 - Undergraduate/MBA


Chapter 15:
Output Design and Prototyping

BUSINESS OF ART (VIDEO CASE)
Frank Thirkettle, Ron Murch

Product Number: 9B06E008
Publication Date: 1/31/2006
Length: 11 pages

Sharon Thirkettle is a visual artist who works primarily in oil-based paints and specializes in landscape and floral scenes. Sharon hasn't always seen her art as business and recently has noticed that a variety of information-based challenges and opportunities are beginning to occupy more of her time. This video case examines how a sole proprietorship, entrepreneurial business operates, with a strong focus on the need for a supportive database. By examining how the artist is approaching her operations, we can demonstrate the similarities between her situation and the data management challenges of larger, more traditional organizations and demonstrate viable solutions to her current information-based challenges. This video was developed for use in an introductory management information system course. The case can be approached from a variety of perspectives such as marketing, operations and e-commerce. The primary objective is to design and develop an operation prototype database solution to track inventory. This package consists of a video, product 9B06E008, and a support CD containing MS Access databases, product 7B06E008. Price of this video case is Cdn$95 / US$80. Please contact Ivey Publishing for distribution information. A demonstration of this video is available to registered customers. Please see product #9B06E008A below.

Teaching Note: 8B06E08 (58 pages)
Industry: Arts, Entertainment, Sports and Recreation
Issues: Information Systems; Managing a Small Firm; Information System Design; Systems Analysis
Difficulty: 1 - Introductory


Chapter 16:
Input Design and Prototyping

RBC ROYAL BANK: SERVICE PLATFORM IMPLEMENTATION
Deborah Compeau, Phoebe Tsai

Product Number: 9B05E001
Publication Date: 1/31/2005
Revision Date: 9/28/2009
Length: 16 pages

The vice-president - RBC Banking business & information solutions must develop an implementation plan for the bank's new paperless transaction system. The new system will reduce costs in proof processing and will facilitate the role of the customer service representatives, allowing the CSRs to shift from transactional to sales oriented roles. The system must be implemented across the company within 12 months. Challenges concerning the timing of installation, sequence of rollout, scope management and prioritization must be addressed.

Teaching Note: 8B05E01 (8 pages)
Industry: Finance and Insurance
Issues: Management Information Systems; Computer System Implementation
Difficulty: 4 - Undergraduate/MBA


Chapter 17:
User Interface Design

IIF AND QUATEAMS CREATING A CUSTOM CRM
Nicole R.D. Haggerty, Jordan Mitchell

Product Number: 9B04E030
Publication Date: 11/23/2004
Revision Date: 10/9/2009
Length: 19 pages

IIF (Institute of International Finance) was eight months into the customized development of a customer relationship management system (CRM) by a small software development firm, QuaTeams. IIF, a member organization, wants to replace their current CRM, an Access database, by integrating member information from different departments: economic research, membership, events and finance. In addition, they want to be able to handle the growing number of members and track the interactions between their staff and their membership. With two months to go before the scheduled launch, both sides must make decisions to overcome the remaining technical hurdles they have with the database and security. The IIF must also consider implementation issues and think of creative ways that the customer relationship management system can be used once the system is operational. The objective of the case is to introduce students to the development of a custom CRM and how the process of developing and implementing a CRM can change the way an organization deals with its customers.

Teaching Note: 8B04E30 (17 pages)
Industry: Finance and Insurance
Issues: Customer Relationship Management; Management Information Systems; Computer System Implementation; Project Management
Difficulty: 4 - Undergraduate/MBA


Chapter 18:
Object-Oriented Design and Modeling Using the UML

HILL & KNOWLTON: KNOWLEDGE MANAGEMENT
Darren Meister, Ken Mark

Product Number: 9B04E003
Publication Date: 3/4/2004
Revision Date: 10/9/2009
Length: 15 pages

Hill & Knowlton is a division of one of the world's largest communication services group. Tagging e-mail communications to support knowledge management codification and connection strategies is an important issue for managers. Issues related to privacy and performance need to be considered. The worldwide director of knowledge management at Hill & Knowlton needs to assess the degree to which tagging should be enforced in a communication services organization that supports numerous clients around the world.

Teaching Note: 8B04E03 (5 pages)
Industry: Administrative, Support, Waste Management and Remediation Services
Issues: Knowledge Based Systems; Communications; Knowledge Management; Leveraging Information Technology
Difficulty: 4 - Undergraduate/MBA


Chapter 19:
Systems Construction and Implementation

MERCEDES-BENZ USA: INVESTING IN IT INFRASTRUCTURE
Steven R. Kursh, Michael Hoch

Product Number: 9B06E003
Publication Date: 1/13/2006
Revision Date: 9/17/2009
Length: 10 pages

The national manager for technical training at Mercedes-Benz USA, is considering using streaming media and distance learning as a supplement to class-room based education, but is concerned that this innovative and risky IT investment could have a negative affect on the company's quality reputation. He needs to evaluate the viability of the e-learning option, including selecting between two vendors, Microsoft and Real Networks. This case provides students with an opportunity to develop a methodology based on capital budgeting analysis for evaluating and executing IT investments. The case is particularly valuable for helping students to consider the risks related to the execution of IT investments, even when an investment has a high ROI. Supplement material, Implications of Streaming Media: A Technical Note, product 9B06E002 is available.

Teaching Note: 8B06E03 (18 pages)
Industry: Retail Trade
Issues: Automotive; Telecommunication Technology; Computer System Implementation; Financial Analysis; Northeastern
Difficulty: 4 - Undergraduate/MBA


Chapter 20:
Systems Operations and Support

A HACKER ATTACK: AN E-COMMERCE NIGHTMARE (A)
Darren Meister, Carlie Bell

Product Number: 9B05E002
Publication Date: 3/7/2005
Revision Date: 9/28/2009
Length: 6 pages

The general manager of BookMart, a major online book, movie and CD store was struggling to manage a serious breach of the company's information systems, which jeopardized both the company's reputation and its ability to provide service to its customers. He must develop an immediate plan to address the security breach internally; how to communicate the situation to customers and the media and develop a long term plan that will minimize the risk against possible future attacks. The supplement A Hacker Attack: An e-Commerce Nightmare, product 9B05E003 looks at the general manager's short and long term plans.

Teaching Note: 8B05E02 (9 pages)
Industry: Retail Trade
Issues: Crisis Management; E-Commerce; Information Systems; Security Systems
Difficulty: 4 - Undergraduate/MBA