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

Video Rentals Shop Database

Extracts from this document...

Introduction

Video Rentals Shop Database Description of chosen problem For this project I am going to design and make a database to fit the requirements of a local video rentals shop. The video shop I used for research was STRIKE video rentals, and unfortunately for them they are still on a manual system, this is due to the cost of the computer and other requirements like soft and hardware required to set such system. I need to create tables that can be extended and upgraded as the years tick over, with new videos coming into stock and new customers gaining membership. I will be required also to make a table of rentals, for the manager and workers use, so they can check which customers have currently rented which videos. It will also be important to have the customers address so if encase a customer has a video over their allowed rental time, a letter can be sent to their home indicating that their video is overdue and that they will have to pay a small fine which will obviously vary depending on the length of time the particular customers video is overdue. The current system under use is far from faultless. With files all being kept together they can infact be prone to getting misplaced which can cause a delay in the running of the shop. If a video is overdue, it could be incredibly time consuming to write out a letter to every customer who is overdue and, with the files in the filing cabinets being all kept together, it is infact prone to error in that the letter can be sent to the wrong address or the wrong details could be contained in the letter. Taking a stock check would be made worlds easier as instead of having to close the shop for one or two days (loosing a lot of business) ...read more.

Middle

9999 videos as their maximum number of videos in stock, because video shops obviously have a larger number of videos than members. I am going to construct my tables using the fields mentioned previously, input masks included so that information cannot be inputted incorrectly. Once all my tables are completed I am going to connect them using macros to connect my forms and tables together. A diagram into how the forms and tables are to be linked is displayed below: Data collection, capture and input: Because the customer wishing to open a membership with the video shop does not wish to be stood arranging their membership details with the employee behind the counter, their view would be that the less information required for them to give the better, as this is time consuming, we will try to keep the required information required to a minimal for many reasons, one being to save room on the database another simply to keep the data-capture form relatively simple as possible and the final reason is not to ask the customers for unnecessary information to save their and our time. In more detail, the fields, which are going to be used, are as follows: For customers: * Customer's Surname- For identification and to be used when putting customers in to Alphabetical order. * Customer's First name- Merely for identification and for use if there is more than one customer whit a particular name of the same spelling. * Other names- Any other names the customer possesses. * First line of address- The first line of the customers address, (e.g. 25 Hazel drive) * Post code- The postcode of the customers address * Home telephone number- The customers home telephone number. * Mobile telephone number (If owned) - The customers mobile telephone number if he or she possesses one. For videos: * Film title- The title of the particular film. ...read more.

Conclusion

By including input masks it enabled an element of security to the input of new customer information into the database or the input of a new video title and it's information, without minimal errors, the only errors that could infact occur are if a employee copies down a telephone number or postcode incorrectly, and therefore I realised it would be a good idea for the new member to read through the imputed information to ensure there are no errors other than the way just suggested, there is no other real way to get around the problem. I checked the mail merge system, the system which sends letters to members and that appears to be running all okay and the only comment I could make to that particular area is that I would like to make my letter slightly more attractive, by adding company logos and possibly a more attractive colour writing. In the future I would like to do something, which I as yet have not been able to do, and that is to have my system tested by STRIKE video and gain their opinions on it, I realize that they would not use my system as their actual new filing system, but I would appreciate it if an employee could just try my system and I could gain his or her opinions and criticisms. As a final conclusion to the whole project I feel that the new method, which I have developed, is a lot faster and user friendly than the old manual method for many reasons. Those being: * Search engine. * No lost memberships or videos. * No damaged forms or records * Input masks enable there to be fewer errors when inputting information. * Fast stocktakings and alphabetic ordering. * System allows expansion for the future. In my final opinion I feel I have accomplished the final task relatively well, although if my system was to be put into practice in an actual video rentals shop, I feel it would require some modifications. Elliot Hunt GCSE I.T. 1 ...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 ICT in Business 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 ICT in Business essays

  1. Business Studies Coursework - start up video rental and buy shop

    Another short term objective is to have a 33% in turnover in the second half of the year. My long term objective to the business is to expand and grow or to start up a franchise. The long term objective should b about four or five years.

  2. I am opening a new shop in my local area; this shop is going ...

    It is also a good idea to be in a partnership because if I run out of ideas then my partner will surely have plenty. Organisational Chart This is an organisation chart which shows who are the owners and workers in my business.

  1. china town revision notes

    The main types/methods of production are: job; batch; flow; and project. In Jack's restaurant they came to the understanding that there was a need for a variety of production methods needed in order to be efficient in the small kitchen.

  2. At present, the owner (Mr Chohan) has a pizza outlet in West Bromwich. He ...

    > Aim At present, the owner (Mr Chohan) has a pizza outlet in West Bromwich. He is considering opening a second shop in Handsworth. I will now investigate: - "Should Mr Chohan open a second shop in Handsworth?" > Objectives In this research assignment, my objectives are as follows: - > To establish trends in the food take-away market.

  1. This investigation has been taken by me to explore the feasibility of opening a ...

    I have finalized on a suitable location in the high street of Morden, directly opposite the tube station, with many bus stops in the vicinity. Throughout the course of my investigation, I will adopt various methods of Primary and Secondary in my research.

  2. System design for Hollywood Nights Video Rental

    When the customer has made his or her decision on the film in which they would like to rent, they bring it to the cashier; they then give the cashier their membership card that consists of three-digit number. The information of all the customers has been recorded in a logbook.

  1. Will a game shop in the UK be successful?

    People living in a well-developed country have money to spare on leisure and entertainment goods. 2. The gaming industry is huge in a developed country such as the UK. 3. Huge population distributed in a relatively small area, which makes it easier to advertise.

  2. Designing a film poster for the film S.W.A.T.

    This makes the film looks more exciting. But I think the weapons which are holding by the characters should be viewed in a whole scale. It can be just described as the word "cool!fascinating!" This is a poster of the film Time Line, which is a non-IT source that I found in the magazine.

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