Introducing ICT systems
Introducing ICT systems

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

Free course

Introducing ICT systems

16.6 Pricing and stock control

A supermarket has a large database of information about its goods, such as the name, price, size and quantity held in stock.

If the price of a particular item changes, the relevant data in the supermarket's database can be easily updated. When the bar code for an item is scanned, the checkout computer searches the database for the item and retrieves the new price. Because the checkout computers are networked, they all use the same data on the database server, so it is not necessary to change prices on individual checkout computers.

Once goods have been sold in a branch, the database is updated. If, for example, you buy a box of your favourite breakfast cereal, the entry in the database for that particular item is decreased by one. When stock levels are getting low, the supermarket can quickly restock its shelves and reorder goods where necessary. The database can then be updated with the new stock levels.

Data about your purchases, and other people's, can be stored in the database and manipulated so that the supermarket knows what sort of goods people buy in that particular branch. The supermarket's management team can use this information in making decisions about which products to stock.

Skip Your course resources

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, we offer two introductory routes to our qualifications. You could either choose to start with an Access module, or a module which allows you to count your previous learning towards an Open University qualification. Read our guide on Where to take your learning next for more information.

Not ready for formal University study? Then browse over 1000 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 prospectus371