VIDEO SUPERSTORE

Video Superstore has hired you to design two online data entry screens. Based on what you

know about the operation of a video rental store, complete the following assignments.

1. Design a weekly operations summary report that will include overall data on rentals,new customers, late charges, and anything else you think a store manager might want to review.Be sure to include numeric activity and dollar totals.

2. Design a data entry screen for entering new members.

3. Design a video rental input screen. In addition to the video data, the video rental form must include the following fields: Member Number, Name, and Date.

4. Suggest at least three data validation rules that might help reduce input errors for the video rental system.

Existence Check 

Reasonable Check 

Validity Check

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

Following the decision to use an in-house team to develop a design prototype, Susan

began to work on the physical design for Personal Trainer’s new information system. At this

stage, she is ready to begin working with Gray on the output and user interface design.

Together, Susan and Gray will seek to develop a user-centered design that is easy to learn

and use. Personal Trainer users will include managers, fitness instructors, support staff, and

members themselves.

1. Create a detail report that will display all Personal Trainer courses in alphabetical order, with the course name and the instructor name in a group header; the Social Security number, name, and telephone number of each current student in the detail section; and the student count in a group footer.

2. Create a switchboard design with control buttons that lead to members, fitness instructors, activities and services, schedules, and fitness class rosters. Allow a user to add, update, or delete records in each area.

3. Suggest context-sensitive and specific Help for the switchboard and lower-level menus and forms. Prepare storyboards that show the proposed screens. Also suggest at least six types of data validation rules for data entry screens.

Data validation

• Simple range validation 
• Constraint validation
• Code validation
• Cross-reference validation
• Structured validation
• Data-type validation

4. Design a mail-in source document that members can use to register for fitness classes. Also design a Web-based registration form.

NEW CENTURY HEALTH CLINIC

CASE STUDY ONE

The associates at New Century Health Clinic approved your recommendations for a new

computer system. Your next step is to develop a design for the new system, including output and user interface issues.

Background

To complete the output and user interface design for the new information system at New

Century, you should review the DFDs and object-oriented diagrams you prepared previously, and the rest of the documentation from the systems analysis phase. Perform the following tasks.

1. Dr. Jones has asked you to create a monthly Claim Status Summary report. He wants

you to include the insurance company number, the patient number and name, the

procedure date, the procedure code and description, the fee, the date the claim was

filed, the amount of the claim, the amount of reimbursement, and the amount

remaining unpaid. He wants you to group the data by insurance company number,

with subtotals by company and grand totals for each numeric field. When you design

the report, make sure to include a mock-up report and a report analysis form.

ANSWER

2. Design the daily appointment list and a monthly statement to make it readable and visually attractive. Include a mock-up report and a report analysis form for each report.

ANSWER

3. Determine the data required for a new patient. Design an input source document thatwill be used to capture the data and a data entry screen to input the information.

ANSWER

Clients Name, Weight, Height, Blood Pressure, Relative, Birth Date, Age, Symptoms, is required for the source document.

4. What data validation checks would the clinic need for the new patient data entry screen? Write a brief memo with your recommendations.

ANSWER

The most important is the reasonableness check, to verify the logical meaning of the input. A validity check should be used to identify the validity of information that the user input and to avoid future errors. Sequence check and existence check also should be used so that there were no mandatory fields will be accepted.