1. Use the background information to create a short summary (one short paragraph)
about the “Personal Trainer” business.
2. Create an organisation chart for the Personal Trainer business.
3. Use the information above to describe the area of the organisation under study (i.e.
the business functions that will be handled by the new information system).
4. Add the background information, organisation chart, and business functions to your
Report document in Part A: Initial Investigation.
1. Either by yourself or with another class member, brainstorm all the functions that
the Personal Trainer system might fulfil. Keep it at a very high level.
2. Prepare a draft System Vision Document for the new Personal Trainer system. This
System Vision Document will be revised when you find out more about the
requirements for the system. An example System Vision Document can be seen in
Figure 1.8 of your textbook (Figure 1.5 in the 6th ed).
3. Add your System Vision Document to your Report document in Part A: Initial
1. Create a table, listing all tasks separately, with their duration;
2. Identify all dependencies, and indicate what predecessor tasks are required;
3. Construct a Gantt chart in Microsoft Project or other project management software;
4. Identify the PERT/CPM chart in the software, and identify the critical path;
5. Determine the overall duration of the project;
6. Take clear screenshots of the Gantt chart and PERT/CPM chart and paste into your
Report document in Part A: Initial Investigation under Project Management.
7. Include the overall duration and critical path in your report.
1. What are the risks associated with this project? Create a list of up to 10 risks and
their likelihood of happening (see Study Guide topic 4, activity 4.6 for an example of
how this should be set out).
2. Define the anticipated benefits of the new system. This should include both tangible
and intangible benefits. Wherever possible, translate the intangible benefits into
anticipated tangible benefits.
Personal Trainer Case Study ISY00243 2016 Page 5
3. Define the expected costs of the new system. Look at the examples given in
workshop activities for some examples of expense categories. It is ok to give
estimates at this point.
4. Use two or more costâ€benefit analysis techniques to decide whether to proceed
with the project.
5. Create a new section in Part A of your report: Risk and Cost Benefit Analysis. Insert
your work from above, and give a clear indication as to whether it is feasible to
continue with the project.
6. Does the proposed system present a strong business case? Why or why not? Include
a recommendation as to whether the system should proceed, as the final part of
your preliminary report. The Preliminary Investigation part of your Report can now
1. What factâ€finding techniques, apart from interviews, would you recommend to
Sarah, to find out the requirements for the new system?
2. Identify a staff member (make up their name) and their job role at a Personal Trainer
3. Develop a list of questions for an interview with this staff member. Identify the time
anticipated for the interview. Review your topic on creating interview questions, and
make sure you include suitable question types.
4. Include the interview plan in the Appendices for your Report.
5. Include the recommendations for other factâ€finding techniques, in your Report
1. Write down a list of the main functions needed to be handled by the new system.
2. What are the roles that will be interacting with the system?
3. Using all the information that you know about the Personal Trainer business so far,
create a useâ€case diagram for the new system.
4. Select four useâ€cases and write a brief useâ€case description for them.
5. Pick one of these useâ€cases and write a full useâ€case description for it. Use an activity
diagram in the full description.
6. Include the following in your report:
the useâ€case diagram;
the brief useâ€case descriptions;
the full useâ€case description, including your activity diagram.
1. Review the Personal Trainer factâ€finding summary and all other information you
have about the required system.
2. Draw an ERD with crowsâ€foot cardinality notation. Assume that system entities
include members, classes, merchandise, and fitness instructors (at minimum).
3. Design tables in 3NF. As you create the database design, identify primary and foreign
keys by underlining primary keys, and making foreign keys italic.
4. If you add primary keys which use codes – for example a code for the instructorID,
then identify the format of these codes.
5. Create suitable sample data to populate the fields for at least three records in each
6. Include the following in your report:
The ERD you have completed;
The database design (schemas) in 3NF;
Formats of codes used;
Sample data for each table.
1. Create a system sequence diagram for one of the use cases identified in Activity 6.
2. Add this system sequence diagram to your report in the appropriate area.
3. Search online for potential commercial software packages for Personal Trainer.
Identify two packages, and compare their features, and their suitability to be used as
the new system.
4. Present four options for the new system in your report. One of these must be inâ€
house development, and two of the others may be the commercial packages in (3)
Personal Trainer Case Study ISY00243 2016 Page 9
5. Review your feasibility analysis for the new system. Taking all options into
consideration, make a recommendation for the new system, in your “Conclusion and
Ensure your report is professionally presented. This means your report should include:
a title page, with the name of the Report, and the analyst’s name (your name);
an executive summary;
a table of contents, with page numbers;
page numbers on all pages except the title page;
Headings, subâ€headings, dotâ€points and numbering where necessary. Headings
should be numbered or the structure should otherwise be easily identified;
Appendices where necessary;
Formatting and whitespace (space where there is no text or pictures) used
Page orientation used appropriately. For example, if you have an ERD that will show
better in landscape orientation than portrait orientation , set a Section break
(Page Layout > Breaks) before this page, set the page to landscape and then set
another Section break to start the new page in portrait again.
Hand in your report via the Assignment Link on MySCU.