• 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

    You failed to enter data in one of the required field!", vbOKOnly, "Student Entry Message:" End If If Range("F2") = "" Then Rows("2:2").Select Selection.Delete Shift:=x1Up MsgBox "The new student has not been added to the system at this time. You failed to enter data in one of the required field!",

  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. Database Analysis and Database Design Project - DVD library for moving images.

    The only different is that I am going to get this information as a preview of a report. The same set up of parameter used on the query are going to be use on the report, and the program will search for the following criteria Like"*"&[enter member id]&"*" like"*"&[enter DVD

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

    If something does happen to the dish, Sarah would need to call professional help as she is in no shape to fix the satellite dish herself. Summary of advantages * Sarah can keep in touch with real life as she doesn't go out often * Sarah's use of her television

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

    This field holds each rental's unique ID number. Customer ID Number Long Integer None - These cant be used in this field This field has been linked to this table by the relationship. This field holds each customer's unique ID number. DVD ID Number Long Integer None - These cant be used in this field This field has been linked to this table by the relationship.

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

  2. GCSE Database Project ICT

    As most of these files are being handled recurrently, the older records are starting to deteriorate severely. Sometimes if a substitute secretary was put in place, some records have illegible writing, which makes it harder to isolate an individual file.

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