Prepare an outline for a system design specification

Assignment Help Case Study
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.

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 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

Case study of the business of your choice

Report - Case Study of the Business of Your Choice,  This assessment requires you to identify and describe a notable example of business invention, entrepreneurship, or innova

Prepare a budget for the division of medicine

Prepare a budget for the Division of Medicine based on the material that Ms Monee has available to her. The budget does not need to be cashed flowed across the year, but it s

What conflicts must conoco resolve

What conflicts must Conoco resolve in deciding whether or not to develop block 16 in Ecuador's tropical rain forest.  How can Conoco achieve the necessary consensus to move fo

What accounts for andy garafallo'' success in business

What accounts for Andy Garafallo's success in the restaurant business? From a skills perspective, how would you describe the three managers: Kelly, Danielle, and Patrick? Wha

Complete the case study etsy breaking down a business model

Read how to analyze a case and then complete the steps below: - The introduction: a brief of my understanding of the case - The environmental analysis Stating the problem.

What type of culture is desired by tim brown

What type of culture is desired by Tim Brown to meet his goals? Does the company have this type of culture? Discuss. What is the most important lesson from this case? Discuss

Write memo to friedman and compton highlighting any concerns

Write a brief memo to Friedman and Compton highlighting any concerns that underlie the analyses you have performed in Part 1.  Without regard to (a), is it profitable to creat

Compare japan competitor and a u.s. competitor product

Firm has contacted you to participate in a focus group. The focus group will compare a Japan competitor product (J) and a U.S. competitor product (U) against China firm's pr

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd