The organisation runs a file system. The following is an extract of its sales file.

(a) Discuss the limitations of this file.

(b) Explain how a databas2 would overcome these limitations.

(c) Illustrate your explanation by developing a database design.

Transcribed Image Text:

Customer name Britney Considine Michelle Lee Customer address 2 Apple Street, Melbourne, VIC Customer phone 03 1234 5678 Salesperson TLM Shoe model Shoe amount Date VZ4717 $29.90 20-Jul-08 6 Organic Street, Melbourne, VIC 03 9876 4321 CBD DF3966 $79.50 30-Jul-08 Phillipa Collier 8 Grapefruit Street, 03 5678 3456 MTL WE9447 $50.30 4-Aug-08 Melbourne, VIC Devine Smith 3 Echo Street, 03 2376 1048 JFK XC8187 $45.50 6-Oct-08 Melbourne, VIC