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.

Question 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:

Question 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:

The layout for this Web-based source document that describes the antiques or products is that it should be well organized. Elders usually fond of antique so in order prevent them from giving unpleasantness, the layout must be well-arranged or well- organize.

Question 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:

Question 4:

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

ANSWER: