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.