Castle Point Antique Auction-Apply your Knowledge

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

Answer:

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. 

Answer:

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. 

Answer:
MEMORANDUM
To: The Owner

From: Roxanne E. Bagtong

Date: April 27, 2018

Subject: Difference between detail reports, exception reports, and summary reports

Dear Monica Creighton,

Good Day!

I would like to give you my opinion about the difference between the different reports.

A detail report produces one or more lines of output for each record processed. Each line of output printed is called a detail line. For example, detail report of employee hours for a chain of retail stores. Notice that one detail line prints for each employee. All the fields in the record do not have to be printed, nor do the fields have to be printed in the sequence in which they appear in the record. An employee paycheck that has multiple output lines for a single record is another example of a detail report.

An exception report displays only those records that meet a specific condition or conditions. Exception reports are useful when the user wants information only on records that might require action, but does not need to know the details. For example, a credit manager might use an exception report to identify only those customers with past due accounts, or a customer service manager might want a report on all packages that were not delivered within a specified time period. Upper-level managers often want to see total figures and do no need supporting details. For example, a credit manager might use an exception report to identify only those customers with past due accounts, or a customer service manager might want a report on all packages that were not delivered within a specified time period. It includes information only for those employees who worked overtime, instead of listing information for all employees.

A sales manager, for example, might want to know total sales for each sales representative, but not want a detail report listing every sale made by them. In that case, a summary report is appropriate.

Roxanne E. Bagtong

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

Answer:

The types of validation that could be used during entering of data are the following:

• A sequence check is used when the data must be in some predetermined sequence.
• An existence check is used for mandatory data items. For example, if an employee user to save the record until he or she enters a suitable value in the Social Security number field.
• A data type check tests to ensure that a data item fits the required data type.
• A range check tests data items to verify that they fall between a specified minimum and maximum value.
• A reasonableness check identifies values that are questionable, but not necessarily wrong.
• A validity check is used for data items that must have certain values.
• A combination check is performed on two or more fields to ensure that they are consistent or reasonable when considered together. Even though all the fields involved in a combination check might pass their individual validation checks, the combination of the field values might be inconsistent or unreasonable.
• Batch controls are totals used to verify batch input. Batch controls might check data items such as record counts and numeric field totals.