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.

SKY-HIGH INTERNET SERVICE

Situation :

Sky-High Internet Services is a leading Internet service 

provider in a metropolitan area. The new customer billing system has caused an increase in complaints. Tammy Jones, the office manager, asked you to investigate the situation. After interviewing data entry operators and observing the online data input process, you are fairly certain that most errors occur when data is entered.

1. Write a brief memo to Tammy explaining the importance of data validation during the input process.

 Ans :

Tammy,

           Data validation is very important during the input process. A validation check improves input quality by testing the data and rejecting any entry that fails to meet specified conditions. Responses should point out that the best defense against incorrect data is to identify and correct errors by using data validation checks before they enter the system .

2. Suggest at least three specific data validation checks that might help reduce input errors.

Ans :

• Sequence check, which are used when the data must be in some predetermined sequence  
• Existence check, which are used for mandatory data items such as Social Security Number
• Data type check , which test to ensure that a data item fits the required data type, such as numeric or alphabet

3. Would a batch input system offer any advantages? Write a brief memo to Tammy stating your views.

Ans : 

Hi Tammy, batch input system is useful and an advantage specially when dealing with a predefined schedule, such as determining the financial status or accounting. Online data entry is an advantage also in handling transactions that needs immediate response, so there should be an analysis of which system will be using in a particular component.

4. Suppose that Sky-High is predicting 25% annual growth, on a current base of 90,000 customers. If the growth pattern holds, how many customers will Sky-High have in three years? If it takes about 12 minutes to enter a new customer into the system, how many additional data entry operators will be needed to handle the growth next year? Assume that an operator works about 2,000 hours per year. Also assume a 30% annual attrition rate for existing customers.

Ans :

Let j1 = 25% of 90,000

Then the number of customer next year would be '90,000+j1', which is 112,500

Let j2 = 25% of 112,500

Then the number of customer next year would be '112,500+j1', which is 140,625

Let j3 = 25% of 140,625

Then the number of customer next year would be '112,500+j1', which is  175,781

The number of customers after 3 years would be 175,781

Terrier News Situation

Terrier News is a monthly newsletter devoted to various breeds of terriers and topics of interest to terrier owners and breeders. Annie West, the editor and publisher, asked you to help her design a system to enter and manage the hundreds of classified ads that Terrier News publishes. Some ads are for dogs wanted; some are for dogs for sale; and some offer products and services.

1. Design a suitable source document for ads that are telephoned or mailed in. 

Ans :

2. Explain user-centered design principles in a brief memo to Annie.

  Ans:

• Think like a user
• Profile the system's user
• Maximize graphical effectiveness
• Use prototyping
• Design a comprehensive interface
• Continue the feedback process

3. Suggest at least four user interface design guidelines that could be used for the new system.

Ans :

• Facilitate the system's design objectives
• Create a design that is easy to learn and remember
• Design a interface to improve user efficiency and productivity
• Write commands, actions, and the system responses that are consistent and predictable

4. Suggest several types of controls that might be used on the switchboard you plan to design. Explain why you chose each control, and create a storyboard that shows the switchboard layout.

   Ans:

NORTH SHORE BOAT SALES

Situation :

North Shore Boat Sales sells new and used boats and operates a Web-based boat brokerage business in Toronto. The company has grown, and North Shore needs a new information system to manage the inventory, the brokerage operation, and information about prospective buyers and sellers. Dan Robeson, the owner, asked you to design samples of computer screens and reports that the new system might produce.

Question & Answer :

1. Design a switchboard that includes the main information management functions that North Shore might require. Create a storyboard with a design layout that allows customers to perform the following functions: Obtain information  about new boats, obtain information about used boats, send an e-mail to North Shore, learn more about the company, or review links to other marine-related sites.

Answer

Story Board

2. Prospective buyers might want to search for boats by type, size, price range, or manufacturer. Develop a screen design that would permit those choices.

Answer

3. Suggest reports that might be useful to North Shore’s management.

Answer

• Providing necessary reports which might help user to have a user to have a clear picture about the company and its performance gained over years .
• Providing the user to obtain the required information he chooses.
• Another web page must be created for sellers who want to sell their boats.

4.  Suggest the general layout for a Web-based source document that prospective sellers could use to describe their boats. The information should include boat type (sail or power), manufacturer, year, length, type of engine, hull color, and asking price.

Answer