Household
Process Name: Add New Household Customer (1.2.2.3)
Input:
Output:
Assumptions:
All inputs are syntactically correct.
Errors:
- invalid Input
- variables of types int or float exceeding maximum (or minimum) range
- input(s) of incorrect format
Process Description:
User enters in all the pieces of data (except account_number)specified
under "Input"
This record.
Input:
Output:
Assumption:
none
Errors:
Customer does not exist with the given customerID
Process description:
Gets all customer information and displays it.
Input:
Output:
Assumption:
none
Errors:
none
Process description:
Delete the household Customer Record from the database;
Input:
Output:
Assumption:
account number refers to a customer
Errors:
none
Process description:
Print out the complete Household Customer Record, which includes all the attributes of the Household Customer, and all the information of newspaper subscription and magazine subscription for that customer.
Process Name: Display & Query Newspaper Subscription(1.2.2.2.4.3.1)
Input:
Account Number
Agreement Number
Output:
Assumptions:
Account Number refers to a houshold customer
Errors:
Newspaper Subscription record does not exist
Process Description:
search the existing datastore if the specified Newspaper Subscription record exists it is displayed.
Process Name: Add Newspaper Subscription(1.2.2.2.4.2)
Input:
Account Number
Product ID
D1to4 Quantity
D5Quantity
D6Quantity
D7Quantity
Stop Date
Start Date
Output:
Assumptions:
Account Number refers to a houshold customer.
All input systactically correct.
Errors:
Newspaper Subscription for with the same productID already exists.
Process Description:
Add a household newspaper subscription to the data store if one doesn't already exist for for this customer and product.
Input:
Newspaper Subscription record
Output:
Assumptions:
Input is syntactically correct
Errors:
Newspaper Subscription record does not exist
Process Description:
search the existing datastore if the specified Newspaper Subscription record exists, if( this Newspaper Subscription record exists), modify the data for this record by retrieving the data from the user (Note: Data inputted by the user must all be valid) else, return an error message endif
Input:
Output:
Assumptions:
Input is syntactically correct
Errors:
Newspaper Subscription record does not exist
Process Description:
search the existing datastore if the specified Newspaper Subscription record exists, if( this Newspaper Subscription record exists), delete the above record from the datastore, else return an error message endif
Process Name: Display & Query Magzine Subscription(1.2.2.2.5.3.1)
Input:
Account Number
Agreement Number
Output:
Assumptions:
Account Number refers to a houshold customer
Errors:
Household Magazine Subscription record does not exist
Process Description:
search the existing datastore if the specified Magazine Subscription record exists it is displayed.
Process Name: Add Magzine Subscription(1.2.2.2.5.2)
Input:
Account Number
Agreement Number
ProductID
Delivery Quantity
Output:
A Household Magazine Subscription record is added
Assumptions:
Account Number refers to a houshold customer
Errors:
A Household Magazine Subscription record for the given productID already exists.
Process Description:
search the existing datastore if a Magzine Subscription record exists for the productID then give and error, otherwise add a Household Magzine Subscription.
Input:
Output:
Assumptions:
Input is syntactically correct
Errors:
Magazine Subscription record does not exist
Process Description: - search the existing datastore if the specified Magazine Subscription record exists, if( this Magazine Subscription record exists), modify the data for this record by retrieving the data from the user (Note: Data inputted by the user must all be valid) else, return an error message endif
Input:
Output:
Assumptions:
Input is syntactically correct
Errors:
Magazine Subscription record does not exist
Process Description:
Input:
Output:
Assumption:
account number refers to a customer
Errors:
none
Process description:
Add a complaint to the Customer Complaint datastore, filling in the date and automatically.
Input:
Output:
Assumption:
date and account number refer to an specific complaint
Errors:
none
Process description:
Displays the complaint referred to by the account number and date.
Input:
Output:
Assumption:
All inputs are syntactically correct.
Errors:
none
Process description:
If any attribute of the Household Customer Record has been changed, update the record. (Note: account number can not be changed)