APPLY YOUR KNOWLEDGE 4: Castle Point Antique Auction

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

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.

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.

MEMO

TO: MONICA CREIGHTON
FROM: AHMER ROSE
DATE: APRIL 28, 2018
SUBJECT: REPORTS

Detail reports have exactly that detail.  If the report was showing transactional sales, each sale consists of many items, on a detail report, every item would have its own line with details about that item.

Example: When you are in an auction sale, you'll provide the list of information about the date, time, price, payment method and data about the transaction. 

Exception Reports provide detail on a report only when certain or specific conditions are met.

Example: About your items that were sold or offered(specific price level) whereas you'll focus on a specific information for your marketing analysis and decision making.

Summary reports have a single line representing the entire transaction and present a summary instead of detail.

Example: The overall daily transactions from your shop, about the sold items and etc.

Just beep back if you have questions, thanks.

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

• Data type checks, which test to ensure that a data item fits the required data type, such as numeric or alphabetic.
• Validity checks, which are used for data items that must have certain specified values.
• Range checks, which test data items to verify that they fall between a specified minimum and maximum value.
• Existence checks, which are used for mandatory data items such as Social Security Number.