Report Processing
Input:
Output:
Assumption:
All inputs are syntactically correct.
Errors:
valid dates district exists
Process description:
Query product sales history database for all newspaper and magazine products sold in the district with district number given and between the beginning and end date.
Input:
Output:
Assumption:
All inputs are syntactically correct.
Errors:
invalid beginning and end dates newspaper_product or magazine_product doesn't exist.
Process description:
Query product sales history Query sales history database for the productID over the defined reporting period (beg. and end date) and print report. for all newspaper and magazine products