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

ICT in business - database solutions.

Extracts from this document...


Jess Kimber Database Project December/Jan 06/07 Databases - 'Identify' a) Background Information Calvin Carrot owns and works in a DVD rental shop in Hastings called "DVDs-2-Go" and there are currently four staff members who work in the shop on a regular basis. At the present time, all Customer details are stored on individual cards kept in a filing cabinet in the DVD store. The problem with keeping customer details on individual cards is that using filing cabinets take up a large majority of space within the shop and retrieving customer details can take a lot of time and the cards can easily be lost. Also, if the shop has over 500 members then this will use up a lot of paper for all the customer details which would be a waste and if a customer's details need to be updated e.g. ...read more.


Advantages * ICT skills are not necessary so the workers will not need to learn how to use the Database system which can sometimes be complicated to use. * The business would not need to pay for computer equipment which can be expensive. * Information is reliable and will be there as long as if has not been shredded by an employee. * Data would not be lost if there ever was a power cut during open hours. Disadvantages * At some point data will need to be updated and this could be messy and mistakes are easily made. * The data will take up a lot of a lot of space in the filing cabinets and multiple cabinets will be needed so this would take up a lot of space within the shop. ...read more.


DVD Genre, DVD Rating, Loan Transactions, Customer by surname etc. * A standard letter will need to be sent to many people informing them of their overdue DVD(s). Some details such as their name will vary but the rest is the same. Word processors let you set up fields for variable data and these fields are filled in my merging with a data source. * Data can easily be added, deleted or amended to ensure the data on file is up to date. * You can not only store information, but sort it as well. For instance, get information for a certain state or person only. Disadvantages * If there is a power cut during open hours, data may be lost and unrecoverable. Spreadsheets could be an alternative to using a database as in Excel a filter can be used to sort data more quickly. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Advantages and disadvantages of using ICT for a business.

    affect the company, employees and the customers and I am going to write how they affect them in the table below. Effects on Travel Agency Effects on Employees Effects on Customers 1. It will affect the travel agency because it will make them efficient.

  2. GCSE Excel Project ICT

    'New Sheet': In addition, arrange them into this order: Sheet6 Select Range C4:J6, D7:K9 and C15:L17 and merge them using the cell merge function: Change the font into Calibri, Size 36 and centre align (horizontal) and enter the relevant text and it will look like this: Then a button must

  1. Video Rental Shop I.T. System

    Concept keyboard- this is just an alternative, but it's not a good one. As these type of keyboards are mainly only used in restaurants etc as they only have to input simple things. Mouse- the movement of the mouse is mirrored on the monitor as it moves.

  2. a level ict project

    The main output of the system is paper based documents once initial use of the file has passed they will be placed in filing cabinets. The garage has been operational for an extended time period; as a result a lot of space has been taken up with filling archives, thus

  1. Creating a computer system for a video rental shop

    Genre Combo Box- (A list of different genres) Text (50) Certificate Combo Box- U PG 12 15 or 18 Text (50) Price (3 Nights) Combo box- �2.00, �2.50 or �3.00 Currency Staff Attribute name Comments Data type and length Validation Staff ID AutoNumber Unique Primary Key Surname Text(50)

  2. The impact of ICT on a person with special/particular needs

    Sarah's TV is mounted on a wall. As Sarah sits in a wheelchair, she might have trouble finding a good position as the postures she can make are quite limited. Instead of having to move herself around, she can instead use a remote to move the angle, direction or exact area her TV is in using the wall mounted feature.

  1. Smarts Leisure Park Database Booking System

    The text will exist for every ingle report that the manager produces. I did this by doing the following: To add the date I had to enter a formula to show it: In a text box I entered: I need to edit the date to show a simple and understandable date.

  2. Different types of technology How I use ICT at home and at school

    The ease to call people names and insult them through MSN makes it all the more tempting. While some people can just press the 'block' button, others just can't understand the word 'ignore'. People can annoy, insult, and harass through MSN.

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