Prepare an outline for a system design specification

Reference no: EM131103142

Case Study Assignment 1

For this module, you are required to complete the Case Study: Personal Trainer, Inc.

Personal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The centers have done well, and the company is planning an international expansion by opening a new "supercenter" in the Toronto area. Personal Trainer's president, Cassia Umi, hired an IT consul-tant, Susan Park, to help develop an information system for the new facility. During the project, Susan will work closely with Gray Lewis, who will manage the new operation. Background After evaluating various development strategies, Susan prepared a system requirements document and submitted her recommendations to Cassia Umi, Personal Trainer's president. During her pre-sentation, Susan discussed in-house development and outsourcing options. She did not feel that a commercial software package would meet Personal Trainer's needs.Based on her research, Susan felt it would be premature to select a development strategy at this time. Instead, she recommended to Cassia that an in-house team should develop a design proto-type, using a relational database as a model. Susan said that the prototype would have two main objectives: It would represent a user-approved model of the new system, and it would identify all systems entities and the relationships among them. Susan explained that it would be better to design the basic system first, and then address other issues, including Web enhancements and im-plementation options. She proposed a three-step plan: data design, user interface design, and ap-plication architecture. She explained that systems analysts refer to this as the systems design phase of a development project.Cassia agreed with Susan's recommendation, and asked her to go forward with the plan

Tasks

1. In your discussion of the systems design phase, you mentioned normalization to Cassia. She would like you to explain the basics of normalization in plain English to help her understand the data design tasks.

2. Review the Personal Trainer fact-finding summary in Chapter 4 and draw an ERD with cardinality notation. Assume that system entities include members, classes, merchandise, and fitness instructors.

3. Design tables in 3NF. As you create the database, include various codes for at least three of the fields.

4. Use sample data to populate the fields for at least three records in each table.

Case Study Assignment 2

For this assignment, you will need to perform all of the tasks in the Case Study: Personal Trainer, Inc.

Background Susan and Gray finished their work on user interface, input, and output design. They developed a user-centered design that would be flexible and easy to learn. Now Susan turned her attention to the architecture for the new system.Susan wanted to consider their own organization and culture, enterprise resource planning, total cost of ownership, scalability, Web integration, legacy systems, processing methods, security issues, and corporate portal. She also needed to select a network plan, or topology, that would dic-tate the physical cabling and network connections, or consider a wireless network. When all these tasks were completed, she would submit a system design specification for approval.

Tasks

1. What would be the advantages of selecting an Internet-based architecture for the Personal Trainer's system?

2. If Personal Trainer wants to increase its Internet marketing efforts, what advice could you offer? Perform research to find out more about the topic of Web-based marketing before you answer Gray.

3. What software and hardware infrastructure will be necessary to ensure Personal Trainer can process point of sale transactions?

4. Prepare an outline for a system design specification and describe the contents of each section.

Reference no: EM131103142

Questions Cloud

Discussion-the balanced scorecard : The best strategies become obsolete as a firm's external and internal environments change. This is even more concerning among companies and organizations that have operations across different countries. Management should make decisions on what nee..

Determine the transfer function of the closed-loop circuit : Determine the transfer function of the closed-loop circuit and compute the bandwidth.

Launching of the new deal : Woodrow Wilson in the WWI, FDR and the Launching of the New Deal, Kennedy and the Cold War, write an essay that explores the social context of leadership.

What is the implied value of the warrants attached to bond : Gregg Company recently issued two types of bonds. The first issue consisted of 20-year straight debt with an 8 percent annual coupon. The second issue consisted of 20-year bonds with a 6 percent annual coupon and attached warrants. Both issues sold a..

Prepare an outline for a system design specification : What software and hardware infrastructure will be necessary to ensure Personal Trainer can process point of sale transactions? Prepare an outline for a system design specification and describe the contents of each section.

What is the output of the following code : What is the output of the following code

Is it spying or just good management : What are your feelings about having your communications monitored as an employee? Do you think you would use these techniques as a manager? Are there any situations it would be absolutely necessary to use these techniques?

Quantitative analysis research help : Prepare a 5-6 page report (excluding the cover page, the reference page, and any tables and graphs), which describes the uses of business forecasting. You need to include at least one real world example and apply at least two different methods of ..

What is the value of bsame : What is the value of bSame and why?

User Account

All Pages