ITPEC FE Morning October 2022 Question 29

File-based Data Retrieval — determine what report can be produced from given file structures.

Four files are used to monitor received orders monthly:

• •Customer file — customer code, name, person-in-charge code, orders for previous 3 months
• •Product file — product code, name, orders for previous 3 months
• •Person-in-charge file — person-in-charge code, name
• •Current month's received orders — customer code, product code, amount of orders

What can be retrieved (4 months total):
- Customer file stores order history per customer for 3 previous months
- Each customer has exactly one person-in-charge (from remarks)
- Current month's orders link to customer → then to person-in-charge via customer file
- Result: customer-wise received orders by person in charge for all 4 months

Why not others:
- (a) Customer-wise by product — customer file stores totals per customer, not broken down by product for previous 3 months
- (c) Person-in-charge-wise by product — no link between person-in-charge and product in historical data
- (d) Product-wise by customer — product file stores totals per product, not broken down by customer for previous 3 months

Key rule: When historical files store aggregated totals, you can only break down by dimensions that have a 1:1 mapping (like customer → person-in-charge), not by dimensions requiring detail records.

AI-generated — may contain errors