Introducing ICT systems
Introducing ICT systems

This free course is available to start right now. Review the full course description and key learning outcomes and create an account and enrol if you want a free statement of participation.

Free course

Introducing ICT systems

17.4 The database server

The computer block on the right represents the database server, which is dedicated to managing a database and making the data available to other computers in the network. The database server receives data via the network. It stores, retrieves and manipulates data, for example by retrieving your previous points total and adding to it the number of points you have 'earned' on this visit. This data is also sent back via the network to the checkout computer to show you the total number of points you have accumulated.

Clearly, Figure 15 shows a very simplified version of the supermarket's ICT system. For example, a supermarket is likely to have many more checkout terminals, and there will be at least one computer for use by the manager and office staff.

Figure 16 shows a block diagram of a more comprehensive ICT system for a supermarket. This may look complex, but you will see that it can be built up from the smaller systems that we have been considering. As Figure 16 shows, each of the supermarket's branches has a number of checkout terminals and at least one 'back office' computer. These computers are linked via a network to each other and to the supermarket's database server, which will probably be located in the head office.

This type of system will be replicated in each branch throughout the supermarket chain. There may also be regional warehouses with their own networked systems to supply the branches, and there will be a networked system in the head office to assist in the management of the whole supermarket chain. All these networks will be linked together.

Treating a system as being composed of different subsystems has enabled us to deal with a complex ICT system in a supermarket. Our system maps have helped us to deal with complexity by drawing the system boundary so that we can investigate a particular subsystem. In this way, we can 'look into' a specific part of a complex system.

In this section, we started by considering a system with one checkout terminal and looked at the processes involved. We then expanded our view of the system to include one checkout networked to a database server. Lastly, we looked at a number of checkouts and the 'backroom' computers networked to the database server. As you may have gathered, we could go even further and look at all the supermarket branches, warehouses and head office networked together.

Figure 16
Figure 16 A block diagram representing a more comprehensive view of the supermarket ICT system

In the next section we will look at another way of using ICTs for shopping – electronic commerce.

T175_3

Take your learning further

Making the decision to study can be a big step, which is why you'll want a trusted University. The Open University has 50 years’ experience delivering flexible learning and 170,000 students are studying with us right now. Take a look at all Open University courses.

If you are new to university level study, find out more about the types of qualifications we offer, including our entry level Access courses and Certificates.

Not ready for University study then browse over 900 free courses on OpenLearn and sign up to our newsletter to hear about new free courses as they are released.

Every year, thousands of students decide to study with The Open University. With over 120 qualifications, we’ve got the right course for you.

Request an Open University prospectus