System analysis and design 9th ed
1-Review the Personal Trainer fact-finding summary in chapter 4 and draw an ERD with cardinality notation. Assume that system entities include members, activities and services, and fitness instructors.
2-Design tables in 3NF. As you create the database, include various codes for at least three of the fields
Chapter 4 Fact-Finding Summary:
PERSONAL TRAINER, INC.
Personal Trainer, Inc., owns and operates fitness centers in a dozen Midwestern cities. Thecenters have done well, and the company is planning an international expansion by opening anew "supercenter" in the Toronto area. Personal Trainer's president, Cassia Umi, hired an ITconsultant, Susan Park, to help develop an information system for the new facility. During theproject, Susan will work closely with Gray Lewis, who will manage the new operation.
Background
During requirements modeling for the new system, Susan Park met with fitness centermanagers at several Personal Trainer locations. She conducted a series of interviews,reviewed company records, observed business operations, analyzed the BumbleBee account-ing software, and studied a sample of sales and billing transactions. Susan's objective was todevelop a list of system requirements for the proposed system.
Fact-Finding Summary
• A typical center has 300-500 members, with two membership levels: full and limited.Full members have access to all activities. Limited members are restricted to activitiesthey have selected, but they can participate in other activities by paying a usage fee. Allmembers have charge privileges. Charges for merchandise and services are recorded ona charge slip, which is signed by the member. At the end of each day, cash sales andcharges are entered into the BumbleBee accounting software, which runs on a computerworkstation at each location. Daily cash receipts are deposited in a local bank and cred-ited to the corporate Personal Trainer account. The BumbleBee program produces adaily activity report with a listing of all sales transactions. At the end of the month, thelocal manager uses BumbleBee to transmit an accounts receivable summary to thePersonal Trainer headquarters in Chicago, where member statements are prepared andmailed. Members mail their payments to the Personal Trainer headquarters, where thepayment is applied to the member account.• The BumbleBee program stores basic member information, but does not include infor-mation about member preferences, activities, and history.• Currently, the BumbleBee program produces one local report (the daily activity report)and three reports that are prepared at the headquarters location: a monthly member salesreport, an exception report for inactive members and late payers, and a quarterly profit-and-loss report that shows a breakdown of revenue and costs for each separate activity.During the interviews, Susan received a number of "wish list" comments from local man-agers and staff members. For example, many managers wanted more analytical features sothey could spot trends and experiment with what-if scenarios for special promotions anddiscounts. The most frequent complaint was that managers wanted more frequent informa-tion about the profitability of the business activities at their centers.To enhance their business, managers wanted to offer a computerized activity and well-ness log, a personal coach service, and e-mail communication with members. Managers alsowanted better ways to manage information about part-time instructors and staff. Several staff members suggested a redesign for the charge slips or scannable ID cards.