• 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. Datbase Project newsagent shop

    After I had inputted all of my customer's information into the created table, I placed the print screen of the page then I used the information to enter data into the form. After putting the customer's details into the form, I added a macro at the bottom of the page

  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. Home Office LTD company. Database

    Above shows how the macro is seen in Visual Basic. Screenshot of the final order form sheet with an example client The final sheet includes all the formulas mentioned in previous paragraphs. In addition, the vlookup function to enable the discount to work correctly.

  2. Designing a booking system for an Estate Agent.

    Whilst talking to Raj I asked whether they have an organisational chart structure and he answered no. All the workers are on the same level and they work independently whilst still keeping in contact with colleagues. The audience are the clients who booked an appointment for property viewings.

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

    The member of staff then has to back track through the rental forms to find the rentals details, which is then signed off with the date returned. The membership card that is in the case is then returned to the member.

  2. Video World Database as ICT project.

    Data Requirement Definition (partial data dictionary) Video Attribute name Comments Data type and length Validation VideoID AutoNumber Unique Primary Key Video Name Text (50) Genre Combo Box- (A list of different genres) Text (50) Certificate Combo Box- U PG 12 15 or 18 Text (50)

  1. ICT Security Report

    They are individuals who generally gain access and exploit computer systems and networks without their owners' knowledge or consent. The attacks can either be malicious or non-malicious. Malicious hackers break into the system either for their own personal gain or to obstruct or destroy documents or information held within that

  2. Consequences for an organisation in implementing IT based changes

    So say if you were going to implement a new operating system around the workplace you would only install it on a couple of computers and let all the staff have a go on them, this will help the staff get used to the new and different operating system.

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