INTERNET APPLICATION (IA) -MAINTAIN INTERNET DATA
- From the IA main menu, the IA user selects the Purchase Item option.
- The Purchase Item option opens a screen which allows the user to pay their internet shopping bill after performing an inquiry of the items selected for purchase. The Pay Bill option updates the Customer logical file to store the date of last purchase. The Inventory logical file is updated to determine when stock is depleted. The Inventory logical file contains the following information: product id, units of measure, count of product on hand, count of product on order, count of product on back-order, and reorder point.
- The Product logical file is maintained by the PARTS application. Product contains product id, description, expected life of product, category, manufacturer, SKU, and weight.
- Upon the customer's first purchase, the Customer Information screen captures the following information about the customer and stores it on the Customer logical file which includes: customer number, name, street address, state/province/region, country, postal code, payment type, gender, and future email offer flag.
- The Purchase History logical file (PHF) is used to contain the history of customer purchases. The PHF contains a demographics section which contains the following: customer number, gender, product category, product id, and purchase frequency. The other part of the PHF contains information pertaining to the cost of purchases: customer number, purchase date, quantity, purchase cost, expected life of product. An additional part of the PHF contains information about email offers sent to the customer. This part of the PHF contains information: date of email, product id, sale price, sale end date, and offer end date.
- The purchase cost is stored in the PHF in US Dollars after conversion from the customer's local currency using the Currency logical file. The Currency logical file contains the following information: country currency converting from, country currency converting to, conversion rate, date and time of conversion rate.
Determine the complexity of the data functions:
Determine the complexity of the following function:
