• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  • Level: GCSE
  • Subject: ICT
  • Word count: 1548

Implementation of my database for Emma's DVD rental shop.

Extracts from this document...


Implementation Emma's DVD rental shop in Birmingham. It started in 2008. It started in Birmingham by Emma's Pegg. When I later then realised that there was a gap in the market in the area. Originally I rented out films and computer games but the popularity of DVD'S increased rapidly in the years I decided to start my own business as a DVD renter. At the moment I work in the business shop myself and employ four assistants so that the shop can be open from 9am until 10pm everyday. I do not have a computer system setup at the moment and rely on that the paper based things to keep records of DVD'S and the people who have borrowed them. I have to be careful that DVD'S are rented out in good condition, so that they will be returned I can see if the member has scratched or marked them in anyway. Emma's and her assistants are often asked, if they have a particular film in stock. Sometimes members don't know what they want, they might ask for a general type such as action thriller. ...read more.


8. Make it easy to back up the data. Alternative solutions These are more than one way to approach this problem. 1. Stay with the paper based solution Advantages: - There will be no need to invest in computer hardware and software. - There will be no need for any extra expensive training. - The system exists already so there will be no 'down time' during changeover. Disadvantages - As the business grows, the problems of data access will grow. - Mistakes will continue to be made damaging the effectiveness of the business. - Not future prove. 2. Store member and DVD details in the spreadsheet file. Advantages - This requires very little effort to set up. - Details can be backed up, answering one of their concerns. - It is easy to re-order data and make chart summaries if required. Disadvantages - It is not possible to connect the data about DVDs, members and loans in a meaningful way. - Some data will be stored in more than one place, such as the details of DVDs in stock and on loan. This will lead to mistakes and inconsistencies. ...read more.


Then the colour is changed You can have whatever colour you want. How you create a form is you click on one of these like DVDs 1. Then this comes up, but how you get that is you go in create a form in wizard, and set it up And that is what comes up when you click on create a form using wizard. And you just do it according to your choice. Then the next step is you name the form with a suitable name that is appropriate for the purpose. Test Plan Test No Test Data used Expected Result Actual results 1 Range Check on Membership Id Number (>3000 and <5000) 2999 Sorry You need to use an Id Number between 3001 and 4999 2 Type Check on Price band 4 Sorry Price band must be Letter (A-E) 3 Extreme Check on Stock ID (>10 and <1000) 999 OK 4 Loan date must be TODAY 4th May 2008 Sorry the loan date must be Today's date 5 Number of Action Films Genre = Action 12 films 6 Number of 12A films Rating=12A 15 films 7 Numbers of comedy films in price band E Genre=Comedy Price band=E 4 films ?? ?? ?? ?? ...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. Video Rental Shop I.T. System

    Well, it'll help me, as there won't be as much customer complaints about the speed of the service. Also at the moment I'm on a tight budget as I have so many staff. So hopefully I can get rid of a few as the system as you say will speed up things around here.

  2. Spreadsheet Project - computer system for a video hire shop.

    Validation error message Validation error message Allow input Valid Transaction 1 Test that only one of the transaction types can be input Inputting valid and invalid words Rental Elephant Food mushroom Allows input Does not allow input Allows input Does not allow input Valid Transaction 2 Test that a membership

  1. Creating a computer system for a video rental shop

    This is the casing that holds all the components, and is the case that all peripherals connect to, such as the monitor, keyboard, mouse, and speakers. The weakness point it can not take as many hardware as the bigger version ATX Motherboard.

  2. Moviezone video rental system.

    Computers are ideal for storing large amounts of data and searching through it quickly. There are two ways that a computer could be used to do this. The first is to have a program specially written to do everything MovieZone Video Rental wants.

  1. Smarts Leisure Park Database Booking System

    to help new users * Must produce a report that shows all customer details * Must be able to produce a report that shows a customer's bookings * All reports must look professional * The system must be secure * Must produce a cancellation report and query to show the

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    When the green card has been placed back into the game the employee/manager puts that game on a trolley with games to be put back. Every hour the games are placed back on the shelves. The overdue loans for the games are worked at the end of the day by the employee/manager.

  1. Creating a computer system for a mobile phone shop.

    Make entering new data easy, and also editing data that has already been entered. It needs to be easy to enter data so that it can be entered quickly, and with as few mistakes as possible. If the system was complicated then it would be hard to enter the data efficiently.

  2. Choice of Software for a game and video rental shop

    Access 2000 has much more powerful features than PinPoint for customising a system, such as macros and movie-screens, which can be used to make it more user-friendly. Mr Anderson does not have Access 2000 on their computer but they do have �750 to spend on software and hardware.

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