Design An ICT System

Authors Avatar

Danielle Sharpe

Task E: Design 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.

Join now!

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 their database. This would include inputting the CD title; artist name; CD price, number in stock; supplier name and the supplier number. These details need to be entered when the database is first set up.

If a CD is sold in Lings Music then the database needs to be altered. The number in stock needs to be reduced for each CD sold, so the database remains up-to-date.

...

This is a preview of the whole essay