Question 27 (7 points) Answer both of the following two sub-questions. a) Minnie Ltd has just realised that it has a problem with sales data as its sales order system records sales to customers that subsequently fail a credit check. i What decisions made during the revenue cycle would be affected by this data problem and how could it be corrected? ii How would this data problem affect the performance of the revenue cycle? As a guide, write about one half-page in the text box provided. Question 28 (13 points) b. Happy Feet Ltd is a large retailer of women's footwear. The organisation runs a file system. Figure 7 is an extract of its sales file. i Discuss the limitations of this file in terms of file vs database structures. ii Explain how a database would overcome these limitations. As a guide, write about one half-page in the textbox provided. Customer name Customer address Shoe model Shoe amount Date Customer phone Salesperson 03 1234 5678 TUM Britney Micawber V24717 $29.90 20-Jul-15 Michelle Burford 2 Apple Street Melbourne, VIC 6 Organic Street Melbourne, VIC 8 Grapefruit Street, Melbourne, VIC 0398764321 CBD DF3966 $79.50 30-Jul-15 Phillipa Musick 03 5678 3456 MTL WE9447 $50.30 4-Aug-15 Devine Smith 3 Echo Street, Melbourne, VIC 03 23761048 JFK XC8187 $45.50 6-Oct-15 Question 27 (7 points) Answer both of the following two sub-questions. a) Minnie Ltd has just realised that it has a problem with sales data as its sales order system records sales to customers that subsequently fail a credit check. i What decisions made during the revenue cycle would be affected by this data problem and how could it be corrected? ii How would this data problem affect the performance of the revenue cycle? Question 28 (13 points) b. Happy Feet Ltd is a large retailer of women's footwear. The organisation runs a file system. Figure 7 is an extract of its sales file. i Discuss the limitations of this file in terms of file vs database structures. ii Explain how a database would overcome these limitations. As a guide, write about one half-page in the textbox provided. Date Shoe amount $29.90 20-Jul-15 $79.50 30-Jul-15 Customer_name Customer_address Customer phone Salesperson Shoe_model Britney Micawber 2 Apple Street, 03 1234 5678 TLM V24717 Molbourne, VIC Michelle Burford 6 Organic Street, 03 98764321 CBD DF3066 Melbourne, VIC Phillipa Musick B Grapefruit Street 03 56783456 MTL WE9447 Melbourne, VIC Devine Smith 3 Echo Street, 03 23761048 JFK XC8187 Melbourne, VIC $50.30 4-Aug-15 $45.50 6-Oct-15 b. Happy Feet Ltd is a large retailer of women's footwear. The organisation runs a file system. Figure 7 is an extract of its sales file. i Discuss the limitations of this file in terms of file vs database structures. ii Explain how a database would overcome these limitations. As a guide, write about one half-page in the textbox provided. Date $29.90 20-Jul-15 Customer name Customer address Customer phone Salesperson Shoo_model Shoe_amount Britney Micawber 2 Apple Street 03 12345678 TLM V74717 Melbourne, VIC Michelle Burford 6 Organic Street, 03 9876 4321 CBD DF3966 $79.50 Melbourne, VIC Philipa Musick 8 Grapefruit Street, 03 56783456 MTL WE9447 $50.30 Melbourne, VIC 30-Jul-15 4-Aug-15 Devine Smith 03 2376 1048 JFK XC8187 $45.50 6-Oct-15 3 Echo Street, Melbourne, VIC Question 27 (7 points) Answer both of the following two sub-questions. a) Minnie Ltd has just realised that it has a problem with sales data as its sales order system records sales to customers that subsequently fail a credit check. i What decisions made during the revenue cycle would be affected by this data problem and how could it be corrected? ii How would this data problem affect the performance of the revenue cycle? As a guide, write about one half-page in the text box provided. Question 28 (13 points) b. Happy Feet Ltd is a large retailer of women's footwear. The organisation runs a file system. Figure 7 is an extract of its sales file. i Discuss the limitations of this file in terms of file vs database structures. ii Explain how a database would overcome these limitations. As a guide, write about one half-page in the textbox provided. Customer name Customer address Shoe model Shoe amount Date Customer phone Salesperson 03 1234 5678 TUM Britney Micawber V24717 $29.90 20-Jul-15 Michelle Burford 2 Apple Street Melbourne, VIC 6 Organic Street Melbourne, VIC 8 Grapefruit Street, Melbourne, VIC 0398764321 CBD DF3966 $79.50 30-Jul-15 Phillipa Musick 03 5678 3456 MTL WE9447 $50.30 4-Aug-15 Devine Smith 3 Echo Street, Melbourne, VIC 03 23761048 JFK XC8187 $45.50 6-Oct-15 Question 27 (7 points) Answer both of the following two sub-questions. a) Minnie Ltd has just realised that it has a problem with sales data as its sales order system records sales to customers that subsequently fail a credit check. i What decisions made during the revenue cycle would be affected by this data problem and how could it be corrected? ii How would this data problem affect the performance of the revenue cycle? Question 28 (13 points) b. Happy Feet Ltd is a large retailer of women's footwear. The organisation runs a file system. Figure 7 is an extract of its sales file. i Discuss the limitations of this file in terms of file vs database structures. ii Explain how a database would overcome these limitations. As a guide, write about one half-page in the textbox provided. Date Shoe amount $29.90 20-Jul-15 $79.50 30-Jul-15 Customer_name Customer_address Customer phone Salesperson Shoe_model Britney Micawber 2 Apple Street, 03 1234 5678 TLM V24717 Molbourne, VIC Michelle Burford 6 Organic Street, 03 98764321 CBD DF3066 Melbourne, VIC Phillipa Musick B Grapefruit Street 03 56783456 MTL WE9447 Melbourne, VIC Devine Smith 3 Echo Street, 03 23761048 JFK XC8187 Melbourne, VIC $50.30 4-Aug-15 $45.50 6-Oct-15 b. Happy Feet Ltd is a large retailer of women's footwear. The organisation runs a file system. Figure 7 is an extract of its sales file. i Discuss the limitations of this file in terms of file vs database structures. ii Explain how a database would overcome these limitations. As a guide, write about one half-page in the textbox provided. Date $29.90 20-Jul-15 Customer name Customer address Customer phone Salesperson Shoo_model Shoe_amount Britney Micawber 2 Apple Street 03 12345678 TLM V74717 Melbourne, VIC Michelle Burford 6 Organic Street, 03 9876 4321 CBD DF3966 $79.50 Melbourne, VIC Philipa Musick 8 Grapefruit Street, 03 56783456 MTL WE9447 $50.30 Melbourne, VIC 30-Jul-15 4-Aug-15 Devine Smith 03 2376 1048 JFK XC8187 $45.50 6-Oct-15 3 Echo Street, Melbourne, VIC