• 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. Database Design

    Employee: (employee ID, employee name, address, city, postcode, employee telephone number, hire date, date of birth) Orders: (order ID, unit price, order date, required date) Product: (product ID, product name, product description, stock) Shipper: (shipper ID, shipper name, shipped date, shipped via, ship address, city, postcode, country, shipper telephone number)

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

    Payment, Shopping Basket Payment PAY03 - R02 Users must be able to enter card details such as card number, expiry date, security code (CVS) Payment Payment PAY03 - R03 Users must be able to view the photos selected and the total cost of the photos being purchased.

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

    My third search assumes the manager wants to search for people whose favourite sport is Football and who sport Manchester United. Sorting Simple sorts A simple sort is when you sort records on one category e.g. weight or forename. 1.

  2. Designing a booking system for an Estate Agent.

    So everybody is involved with the system. The organisation communicates internally and externally through the use of email. They have sufficient ICT skills to work Microsoft programmes such as Word, Publisher and PowerPoint. They also have a basic knowledge of how to use Microsoft access but further explanation would still be needed to explain on how the system would work.

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

    As the system is paper based and stored in files, so there are issues with back up and security. 4. Client Requirements The new system has these key features: * Allow employees details to be entered (employee number, surname, forename, grade, national insurance number and date of birth)

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

    Bradshaw will be able to delete members, DVDs and rentals. Amy Bradshaw has the same level of ICT skills as her husband. Mrs Bradshaw also spends long hours in the shop and her abilities will affect the overall design of the proposed system.

  1. A report on the impact of ICT

    With a new mobile phone I can do most of this on my phone through 3G internet which means I can talk to my friends and go online to see videos or event details where ever I can get connection.

  2. Using the Internet to research UFOs.

    When looking at characteristics of these abductions, skeptics have a logical explanation ("NOVA Online/Kidnapped By UFO?s?"). John Mack, a believer mentioned earlier in the paper, has talked to many people who have claimed to have had an extraterrestrial experience. Many have said that they have woken up one morning with

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