Video Superstore

Case Study (3)

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.

Ans: 

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

Ans :

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

Ans:

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

The Three data validation that might up help reduce input errors

Ans :

Personal Trainer, INC.

Case Study (2)

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.

Ans :

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.

Ans:

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.

Ans :

Six types of data validation includes

• Sequence Check
• Range Check
• Data Type Check
• Validation Check
• Existence Check
• Batch Controls

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

Ans : 

New Century Health Clinic 

Case Study 1:

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

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.

Ans : 

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.

Ans :

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

Ans :

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

Ans :

Castle Point Antique Auction

Situation:

Castle Point Antique Auction operates a successful Web site that offers an auction forum for buyers and sellers of fine antiques. Monica Creighton, the owner, asked you to help her design some new documents and reports.

1. Suggest the general layout for a Web-based source document that prospective bidders would submit. The information should include user ID, password, name, address, telephone, e-mail address, item number, bid offered, and method of payment (money order, check, American Express, MasterCard,or Visa).

Ans :

2. Suggest the general layout for a Web-based source document that prospective sellers could use to describe their antiques. The information should include the user ID, password, item, dimensions, origin, condition, and asking price.

Ans : 

3. Write a brief memo to Monica explaining the difference between detail reports, exception reports, and summary reports. Suggest at least one example of each type of report that she might want to consider.

Ans : 

          To           : Monica

          From      : Mercolita , Jade T.

          Date       : 04/05/18

          Subject   : Difference of Detailed, Exception and Summary Reports

        Detail report – in this kind of report, it considers every line as a data, or describe as detailed line. For example, data of a bidder, together with their username, name, etc.

        Exception reports – the book describes the exception report that displays records that satisfies the condition specified. For example, you want to display the highest bid with the bidder that ranges from a specified amount.

        Summary reports – this report displays the total figures, in relation to the system, this report may contain the total number of bidder in an item, total item that is sold, etc.

4. Suggest several types of data validation checks that could be used when input data is entered.

Ans :

         Sequence check, to determine whether the input is a valid input from a predetermined sequence.

 

            Existence check, for the password and usernames.

 

        Data Type check, to avoid errors that may occur when handling numerical values specially floating point values. 

         Reasonable check, you cannot enter a bid that is lower than the previous bid. And last, validity check to make sure that the bidder bids to an item that is existing.