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

Creating a computer based system for a video rental store.

Extracts from this document...


INTRODUCTION BACKGROUND The organisation, which I am going to be doing, is a video/DVD and games shop. The name of the shop is Starlight Rentals. The organisation is quite a big organisation and this shop has about approximately 100-150 transactions a day. This organisation has a lot of members because if you want to rent a movie you have to be a member. STATEMENT OF THE PROBLEM Starlight rentals deal with up to 100-150 customers everyday and for all the videos/DVD and games, which have been rented all written down on pad of paper. The problem is that because this is written down this is very difficult for owner because every time a movie is returned then the owner has to then look through the all his papers to find the name of the person who has returned the movie and then tick his name off. E.G. NAME MEMBERSHIP NUMBER MOVIE/GAME RENTED DATE RENTED DATE RETURNED PAID YES/NO Shahied Patel Sp03245 Training Day 25.09.03 26.09.2003 Yaseen Gigani Yg03546 Mean Machine 25.09.2003 27.09.2003 David Johnson Dj03465 Cradle To The Grave 25.09.2003 26.09.2003 Muhammad Sheikh Ms06245 Scary Movie 26.09.2003 28.09.2003 Mustufa Adam Ma02354 Scarface 27.09.2003 28.09.2003 The problem with this is that it is very time consuming and very hard looking for the person's name. Also another problem is that all over due rentals are difficult to find out about because you have to look through all the records and because of this you may miss some people out. ...read more.


* The system should be user friendly * In the layout of the database their should consistency * The data should be accurate * The database should be fast. CONSTRAINTS The hardware, which is available, is a computer, which is quite fast and very good. This available at home as well so it is better. A tower, monitor, printer is all available The software, which is available, is Microsoft XP, which includes Microsoft Access, which is what the database will be created on. The person who will be using this system does not have to be an expert on using computers but will need intermediate IT skills to use the database. The reason being that training may also be needed to use the software because this is database, which will be made especially, made for the business itself. The workers which are going to be using the database do not have any experience of using the new system so they will need training. Because training will be needed then it might cost the business some more money and this training may take up to 6 months and this is really necessary. DESIGN COMPARISON OF ALTERNATIVE SOLUTION This project I am doing at the moment is creating a database on Microsoft Access. Another alternative than rather using MS Access could be to use Microsoft Excel which is a spreadsheet package. The reason I feel that MS Access is better for creating this database is because of many reasons One reason which I feel that MS Access is better and more efficient is that ...read more.


In levels of access the workers should have ID and password and in that they can only see certain whereas the manager can see everything. OUTPUT The use if forms to a business is very important because at the end of day the manager of the shop may want to check the sale for the day so on a report he will be able to see it. It is also important that workers cannot amend the data or check the database for any information and also that the workers have a level of access so they can only see certain things. MENU DESIGNS SECURITY Security for database and for a business s very important because you do not want your workers to see all the details of customers or suppliers. for security there should be level of access where the manger can access everything and the customer can only access certain things. Another reason why it is important because you do not want workers to see your sales for the day or to see how much money you make. TEST PLAN TESTING Testing is important because you have to check whether your database works or not or whether it does everything you want it do. One very important reason why testing is important is because if you give your database is being used and there is a fault with it then it will be difficult for the workers to sort it out so you have to make sure that everything works. ?? ?? ?? ?? Shahied Patel AS ICT - Analysis ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Designing a booking system for an Estate Agent.

    This is because they would have to write contact information; address, telephone number etc. and details on which properties the clients are looking to view. If they had a computer system this would be easier as the details would already be stored in the system.

  2. ICT coursework: Designing and implementing a book rental system

    Another way of solving the problem is by using computers, which would be easier to store information and a quicker way of finding a member rather than looking around the box, which takes long. This program is very important to Book Zone and is the best way.

  1. Database Design

    An error message will appear. An error message appeared. 2 Test Main Menu options. Click the Exit button. Closes form. Closed the form. 3 Add new customer in Customer Details form. Add new customer by clicking the 'Add' button and filling in the details. Will allow me to fill out all the details.

  2. The purpose of this document is to provide a design for an electronic payment ...

    be added from the database to the shopping basket which keeps a running total of the price. User details are then transferred from the database to the card details form where the user fills out the card details, these details are valid and the payment is finished.

  1. I have been asked by a General Sports shop using a manual system to ...

    System Specification Hardware Total Type Description Supplier Cost Quantity VAT Cost Computer Elite Business Plus Mesh �992.88 1 �173.75 �1,166.63 Printer MINOLTA DESKLASER Magi colour �999.99 1 �175.00 �1,174.99 Monitor 15" TFT Proview �249.00 1 43.575 �292.58 CD-RW 16x10x40 Buslink �119.99 1 �21.00 �140.99 Mouse Inter mouse Packard bell �14.99

  2. Planning a payroll system for a martial arts school.

    * The program should use a menu system with three options of: o Entering and processing an employee's details. o The pay slips details with the ability to print. o Exiting the system. * The operator need not be computer literate so it should be easy to enter with suitable validation procedures and be as simple as possible.

  1. I was hired by Mr Davies to create a website for a newly built ...

    This is done when the component is created and will be documented in the implementation * System testing - the testing of the full system from beginning to end. This is done using the test plan below and will be done and documented once the whole system in complete.

  2. Background and investigation for designing a database for a DVD rental shop.

    they then have to chase up which member rented the DVD from the rental form, which takes up a lot of time. On returning a DVD, the member hands the rented film in and the member of staff that accepts it will place the DVD back into its original case.

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