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

The company that would like to modify their business organisation is called Tempest Records, and specialises in buying and selling new and old compact discs (or cds) to the public. Setting up a new system.

Extracts from this document...


Description of the Problem The Company The company that would like to modify their business organisation is called Tempest Records, and specialises in buying and selling new and old compact discs (or cds) to the public. They buy the merchandise from a stockist that supplies many companies, and then they sell them through mail order to their customers. They buy an entire range of cds from rock to ska to punk, and people can buy them on compact disc. People have to sign up and join the organization so that they are then able to purchase the cds. The membership scheme that the company has to offer stores the details of the customer i.e. address, names and all the other relevant details that the business might need. The Current System The system works by the staff of the company placing the information of a particular customer in a filing cabinet when it is first received at the office. The data collection form is placed in different music magazines each month/week in order to advertise the company, and let people sign up. ...read more.


the address for each one - this is a problem because only some people are interested in particular genres of music, and when the company writes to people, they write the same thing to everyone, and therefore some people receive information about music that they are not interested in. The fact that the system is a manual system is a problem because - - The data of the members can be easily lost - when a file is being taken out the filing cabinet another file could accidentally be taken with it and then lost - this isn't good because when that customer wants to buy a cd they can't because the company doesn't have them in their system. They can join again, which is a hassle because they have to learn a new membership number, and it doesn't look good for the company - The files are stored by membership number ad if a customer forgets their membership number, it takes a long time to find them because the way the files are stored - Mistakes can be made - ...read more.


I have decided to set up a database on the computer that contains all the details about the customer so that they can be sent a mail merge letter (produced on the computer) every month to tell them about the offers for that month - the letter will be different for the different kinds of music that people prefer. I am going to create a table in the database containing all the information about the individual customers. I will mail merge this information into a letter that will be sent out every month to each member to make it appear personal to each of them. This new database will also allow new members to be added, old members to be deleted and member's information to be edited very easily. The company will benefit from a membership scheme on a database as each time a customer orders from the company they can be found on the database quickly and efficiently. They will look more professional and efficient to new customers. I will also create an order form, so that the company can tell what customer has brought what cd and when. Emma Smith Problem ICT Coursework ...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 ICT in Business 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 ICT in Business essays

  1. Analysis of The Cadbury company.

    Democratic management: This is when all members of staff work together as a team. They listen to each other's inputs of ideas and suggestions. Then as a team they reach a decision. This management style is good for Cadbury because it motivates workers; with having power and decision making and

  2. Analysis of The Cadbury company.

    It is well known for its pioneering work in the 19th Century, providing housing, education, welfare and recreational facilities for the local community. Cadbury's has grown as a business and now offers a wide variety of jobs at all levels from senior management position to apprenticeship opportunities for graduates.

  1. Nowadays Information System (IS) has become a vital component of successful organisation particularly for ...

    for customer to configure route, price and submit orders electronically to Cisco. Besides, majority of the orders entered on CCO are sent directly to the suppliers and it is shipped directly to the customers once the product has been manufactured and produced.

  2. This coursework that I intend on completing will be based around setting up a ...

    Below are the results of the question: What music do you regularly purchase? From the information shown by this question, many people preferred Pop, Rock, Punk and Dance. The people asked in the questionnaire were many people aged between 15-40 years old.

  1. In this coursework I need to produce a detailed business report on one medium-sized ...

    to carry out practical research with customers into new and existing products. Each centre is staffed by two consumer service officers who are qualified home economists. Their most important role is to conduct consumer acceptability tests and sensory analysis. Over a four-day period, six to eight products will be tested.

  2. As a member of a team of computer personnel's contracted by Lewin Sports Shoes ...

    The type of information I will find out will be based on as followed: * Information about the company procedures - how certain tasks are they going to carry out. * Measurements such as the size of the new system and how wide it will encompass the different areas of the business.


    has more priority due to all company information stored on the hard drive or in the back ups and the needs of communication. The functions of the warehouse are mostly to sort out the stock in chronological order to sort them in order of code so that in future it can be easily be located.

  2. Investigating the current system at a new car company.

    I find this very similar to the interview but it is also different in some ways. As it is in a group more reliable results can be taken but there may be some dishonesty in group answers. I find this a very useful method of investigation but I prefer the interview method.

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