• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design An ICT System

Extracts from this document...


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. ...read more.


To make customer service more efficient, members of staff will need to be able to check on their monitor for details about specific CDs to answer customer queries. 6. Type of software To build the ICT system in Lings Music, various different types of software will be needed. They will need data handling software e.g. Microsoft Access Database to produce a database to keep their CD information and stock numbers on, so that the manager can use it to know when stocks are running low, and so that members of staff can access it quickly to know whether or not a specific CD is in stock. They will need word processing software e.g. Microsoft Word to enable the manager to produce order forms which can then be sent to suppliers when their stock is low and they need to reorder. To send these order forms to the suppliers, Lings Music will need an internet browser e.g. Microsoft Internet Explorer. The manager will then need to have communication/email software e.g. Outlook Express which will then allow for him to communicate with suppliers and send order forms via email. ...read more.


be entered into fields that require currency, such as the price of the CD and that numbers can be entered into fields that require numerical data, such as the number of CDs in stock. The manager will then need to check for abnormal data. He will need to make sure that the correct information goes into the correct fields in his database and that text isn't entered into a numerical field or that a currency isn't entered into a field requiring text. Finally, he will need to test the extremes of data. The manager will need to check that his database accepts all extremes of data - figures entered between 0-15. He will also need to make sure that the data entered isn't vastly incorrect on either end of that scale, for example, when CD prices should all be less than �15, a price is entered in as �30. To ensure this doesn't occur, he could set a validation rule so that an error box shows if data is entered incorrectly. Once the manager has carried out all these tests on his database, it should be working properly and efficiently, ready to be used within Lings Music. ?? ?? ?? ?? Danielle Sharpe ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Management & Manipulation of Information essays

  1. Home Office LTD company. Database

    Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("B14").Select Sheets("Order form").Select Range("B5").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("C14").Select Sheets("Order form").Select Range("B6").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("D14").Select Sheets("Order form").Select Range("B7").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("E14").Select Sheets("Order form").Select Range("B8").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("F14").Select Sheets("Order form").Select Range("B9").Select Application.CutCopyMode = False

  2. Designing a booking system for an Estate Agent.

    This might be difficult as several clients might book for a same time of property viewings but also with different negotiators. Another obvious problem is that there will always be room for human errors especially with hand writings as some will be difficult to read.

  1. Background and investigation for designing a database for a DVD rental shop.

    There are no measures to monitor how many times a movie has been rented unless Mr. Bradshaw decides to go through the rental forms which is unpractical. Concluding Remarks Mr Bradshaw the end user is used to his position and is suffering from a paper based management system that is inefficient.

  2. A report on the impact of ICT

    There are also many negative effects of the internet such as viruses, security and privacy. The internet can be a very dangerous place however with new antivirus software and firewalls I have not personally been majorly affected by any of these problems.

  1. Uses of ICT in Varndean

    How do they help? They all help the sales in Varndean because without all of the hardware, they wouldn't have a computer. Without a computer, they wouldn't be able to send out information to potential buyers so that the buyers can see what you have in stock.

  2. Video World Database as ICT project.

    He is also quite good at using Excel. His keyboard skills are standard. He has used Publisher for the making of cards but never on a professional basis. Design Comparison of Possible Solutions A number of possible solutions could

  1. ICT Security Report

    * Spoofing Internal Communications - An attack from outside of the network can usually be identified as such. If an attacker can connect with your WLAN, they can spoof communications that appear to come from internal domains. Users are much more likely to trust and act on spoofed internal communications.

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    In initial stage there were small problems in the implementation, which is common in most of the CRM initiatives. Eventually all of these problems were efficiently solved. Yet due to the company's internal viral complainers, these minor problems became major problems and even the system killers.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work