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

Proposed system

Extracts from this document...

Introduction

Proposed system When looking at the current system many problems have emerged and it is now clear a new more efficient system is required. With the proposed system I aiming to eliminate a lot of paperwork and have most paper based forms available on the proposed database. Expired or incorrect data is a key issue in the current system. I aim to correct this by making the process of finding and deleting unwanted data an extremely quick task, quires will be in place to find customers that have been inactive for a long period and then mr Bradshaw will have the choice of contacting this customer and amending the data thus making the overall data in the system more efficient and up to date. Searching all your customers currently is a near impossible task as wafting through vast amounts of customer forms is impractical; these forms are also unorganised and have customers that don't exist anymore. For these reasons employees try to avoid this task. This task can easily be implemented into the proposed solution with the use of a combo box. This method allows users to generate a drop down list that only shows customers names and address, hiding all the other unwanted data. A query can also bring up a specific customer by entering the customer number or name which will instantly pick out that customer from the current customer list. ...read more.

Middle

Every month Mr. Bradshaw participates in a task of choosing 25 DVDs to return back to choice uk in exchange for another 25 DVDs. This procedure usually involves Mr. Bradshaw having to recall on his own knowledge of whether a DVD is popular or not. This is not a reliable method of deciding what DVDs should be returned. In the solution i will implement a query which stores the number of times a DVD has been rented. This information can be accessed for that current month generating the 25 least rented DVDs. This data can then be used to select what DVDs should be sent back, making the task of selecting the right DVDs for exchange more efficient, reliable and quick. Mr Bradshaw's current method for keeping track of rentals involves constantly referring back to the rental list and monitoring the due dates. This task is very repetitive and has become stressful. Customers tend to vary the number of days they want to rent a DVD out, this means due dates can be difficult to locate on the rental form. The solution eliminates the stressfulness of the task because a query will be designed that will produce a list of rentals that are due on the current day or any another specific date. The rentals that return from the query will have information of the DVD and which member rented it out. ...read more.

Conclusion

JenJams doesn't have access to the internet, so tasks such as e-mail are not possible. In a case where the manager is unable to personally be at the shop but requires information, it can be printed and sent to him. With the case of overdue DVDs there needs to be protocols in place to notify customers that are overdue. The database will allow employees to print letters notifying a customer that they are overdue and the DVD in their possession must be returned immediately. I have generated a list of features i will include into the proposed system which derive from further analyse of the current system. The database must be able to; * Add and edit DVD details in the system * Add and edit Member details * Add and edit Rentals details * Search through database for specific DVD and its details * Search through database to find details on members * Search through database to find details on rentals * Archive records of a member when they have left * See how many times a DVD has been rented during a certain time period * Keep track of rentals and due dates * Calculate rental and overdue prices automatically * Generate and print reports for overdue DVDs * Generate and print reports of members and their details * Generate and print reports of current and past rentals * Generate and print a letter to send to customers that are overdue on DVD returns ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    The system will then have to be installed after it's been thoroughly tested. This will include preparing the users for using the system, ensuring that the hardware is capable of running the software and converting the data from the old system into the new one.

  2. The aim of this task is to produce a report for the managing director ...

    be located in the main area that the internet will be used. Where the Hotel could use Wi-Fi? The Wi-Fi connection should be placed throughout the Hotel so that it can be used anywhere within the Hotel. Doing this would probably mean having several access points to the internet connection.

  1. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    This is a problem as when some order sheets and receipt are thrown out they cannot be referred back to and this leaves the company in a bad position. * At the moment the staff at the company has to add up all the weekly orders using a calculator and this takes a very long time.

  2. User Guide to my minibus hire database.

    you will then need to click the "file" tab on the top toolbar: From here you then select the print option: On this screen select the "print" option and an interface like this should appear: On this interface, simply choose the number of copies you want to print and then click "OK" and your report will be printed.

  1. Applied ICT - How Comet Stores could use ICT and a CCTV system.

    The lens used determines how far and how wide of an angle the camera can see. If the system is wired12, the camera then sends the signals through a cable to the monitor, and or the recording device. If it is a wireless system, then the camera simply broadcasts the signal straight to the monitor itself.

  2. Feasibility Report

    system, this will result in company not losing revenue, due to business who order one off deliveries. o The owner of the company will not have to drive between sites when passing information, instead the information can be sent through email or be seen on screen on the WAN Web.

  1. ICT Spreadsheet System

    The customer's details will be entered in by keyboard (for example - First Name, Surname, Address etc). When this process is complete the system will save the information. There will be a similar sort of process for entering stock information of new or current stock.

  2. User Guide. This system is for Regs Second Hand Cars. This user guide will ...

    When this button is clicked it will take you to the 'Agreement' sheet. When this button is clicked it will bring up the 'Help' message box. This has useful information if you need help. Here is the message box that will show: When this button is clicked it will bring up the 'About' message box.

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