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

Introduction

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.

Middle

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.

Conclusion

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. ICT PROJECT

    are the input box, which will enable the user to enter assignment and the marks obtained by the Pupils. There will be a validation on the boxes so that when the user enters wrong data the systems rejects the information.

  1. Creating a computer system for a video rental shop

    it ensures that the value of the primary key can never be a null value.. The integrity rule requires that insert, update, and delete operations maintain the uniqueness and existence of all primary keys. * Referential integrity. Foreign keys are used in relational databases to implement relationships between the records in different tables.

  2. GCSE Excel Project ICT

    furthermore, is size and furthermost the price column. As the object, type changes so does the titles that it encompasses. (E.g. The Hard Disk Drive title reflects the following 3 titles making them HDD Make, size and price. The Cells marked: D4 D7 D10 D13 Are of particular interest because

  1. Database Analysis and Database Design Project - DVD library for moving images.

    The set up the parameter all I did was write this following criteria on the criteria option on the query: Like"*"&[enter member id]&"*" like"*"&[enter DVD id]&"*" like"*"&[enter actor name]&"*" Like"*"&[enter DVD title]&"*" This is the interface that the user will be able to see after the parameter for the query has been entered.

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

    Sarah can purchase lots of different channels regarding lots of different matters. While this may seem to be a costly venture, Sky contains relatively cheap prices and a lot of channels are even only a cheap one-time payment! Sarah owns a Sky digital-card that came with the digital-box and she can purchase and store channels onto this card.

  1. I have been employed as an ICT consultant for DVD rentals, a business that ...

    Date Returned Date/Time General Date e.g. 01/01/2000 None - These cant be used in this field This field holds the date of when each DVD was returned. Overdue Yes/No Yes/No Lookup - Check Box This field holds the check boxes and are ticked when a DVD is overdue.

  2. Implementation of my database for Emma's DVD rental shop.

    This is taking far too long and diverts staff from serving customers. 3. When a new customer registers as a member, it takes too long to fill in a record card for the customer. 4. When a member changes personal details, the record card has to be alerted and some of these are getting very messy.

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