Designing An ICT System

Lings Music PLC records all the CDs they have in stock by using a

database. This allows for the manager to quickly notice if they're

stock number is running low or if they have sold out of any CDs, so

they can be reordered. Members of staff can access the database

through their till so they can check whether a specific CD is in stock

without having to look through the shelves for customers. This saves a

lot of time and is good customer service.

The data the database will store includes:

* CD Title

* Artist Name

* CD Price

* Number in Stock

* Stock ID

* Supplier Name

* Supplier Number

1. User Requirements

The manager of Lings Music wants to use the CD database to check what

cds are in stock. He will want to easily and quickly notice when stock

numbers are running low so he knows when to reorder certain cds to

ensure he always has cds in stock to sell to his customers. He wants

to access this CD database so he can look up on any details regarding

a specific CD, whether that is its price or whether or not it's in

stock. This is more efficient when it comes to customer queries and

therefore better customer service.

2. Sources of Information

The information that is to be entered into the CD database will come

from their manual stock checklists that the staff would have used

previously, before setting up this database. The manager can also get

his input information from recent delivery notes they've received upon

deliveries. These give all the details about CDs that have been

delivered to Lings Music, which the manager will need in setting up

his CD database.

3. Input Required

When a stock check is carried out within the shop, the staff will have

to input all the details regarding the CDs they have in stock into