• 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. Designing a booking system for an Estate Agent.

    This means that this could get lost and the employees would forget which appointment they would have and with which client. To solve this problem I will be creating a visit booking system for the company. The solution will be matched to the client's requirements that I garnered from carrying out an interview with my contact Raj Tevari.

  2. Database Design

    Supplier: (supplier ID, supplier name, supplier address, city, postcode, phone number) Entity Relationship Diagram There are 3 types of relationships between two entities. They are: * One-to-one * One-to-many * Many-to-many Each entity will have attributes associated with it. An attribute is a characteristic, for example the Customer entity will

  1. The purpose of this document is to provide a design for an electronic payment ...

    Shopping Basket, User Payment PAY03 - R04 The system must check for owner authorisation prior to selling photos. Feedback Payment PAY03 - R05 The database should have fields designating the cost of each photo and a table for users to store their selection being purchased.

  2. I have been asked by a General Sports shop using a manual system to ...

    Cd-rewriter Printing options The shop will need a printer so it can print the database so they can find people address's etc. The printing of the database is an important factor so the shop will need some printing options. For example: 1.

  1. Planning a payroll system for a martial arts school.

    Takes a long time to calculate the payroll system and there are errors that occur within the payroll which delay employees wages. * How does the current system work? By manually calculating the details on a form that the employees fill in and is then signed by their manager.

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

    It is also not immediately obvious when a date is overdue because there is so much writing on the forms and so you cannot always single out an overdue DVD. Stock levels As JenJams receives new DVDs on a regular basis it is difficult to know the number of DVDs within the shop without counting each one by one.

  1. 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.

  2. Using the Internet to research UFOs.

    I began a new search on the Internet. I was now on the hunt for chat rooms and bulletin boards. I was thirsting to know more about these communities. I wasn?t quite sure if I was going to hold back and just observe conversations taking place or if I was going to be an actual participant in these conversations.

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