Chapter 4: Contemporary trends in information and communication technologies
57
Example
The customer accounts system of Multinational Bank has a file of customer
account details – a sequence of records, each containing data on individual
customers. Among the fields that occur within each record are:
• name
• customer number
• date of first opening an account
• address
• telephone number
• email address.
The file is used whenever a person is contacted in any way. In practice, these
records will need to be accessed in any order, depending on which customer a
bank employee wishes to contact (called random access). The customer number
field has a special status as the key field, because the customer number allows
the correct record to be uniquely identified and retrieved. Note that the bank
has 25 customers called John Smith! And most of these have more than one
account at the bank. The file is stored on disc, and we can go directly to read
any record if we know where on the disc it is stored. In practice we would
expect some database management software to take care of most of the detail
of storage and retrieval of these records.
Before the creation of database software − and cheap computer power
− organising files was an important technical issue. Today, with database
software in common use, and with cheap computing power and fast storage
devices of vast capacity, we seldom need to think in such technical detail about
how exactly data is stored, accessed and retrieved for any given application.
However, as you will see in undertaking your database assignment, designing
databases is itself a task that needs to be carefully approached (see Chapter 8 of
this subject guide).
Dostları ilə paylaş: