• 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. 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. I will design a new video database for the video shop that will also ...

    ID, Video Name, Rental Price, Selling Price, Category Type, Rating, Quantity, Stock Conclusion The main disadvantage I have with creating a new database for the health centre is that I was unable to view their original data storage system due to the private medical information that is stored on it.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    The files could be found more easily. MOVING IMAGES DATABASE DESIGN ENTITY RELATIONSHIP DIAGRAMS - CONCEPTUAL MODEL As we can see on the conceptual model below, there is a M:N relationship, a database cannot be create when there is a M:N relationship. ENTITY RELATIONSHIP DIAGRAM - LOGICAL MODEL On the logical model below, we can see that the M:N relationship is no longer on our diagram.

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

    If after 1 week the member has still not returned the game then the employee/manager writes another letter to the same person. Problems with the current system: Our company operates functional at the moment however there are a lot of problems with our system.

  1. Designing a database to manage stock in a clothes shop.

    PC way- This method would be a lot easier because it wouldn't include as many people as the manual way. This method consists of creating a database using Microsoft Access. While learning I discovered an all new way of using access.The employee has to introduce the date on which the customer issues the order.

  2. I have been employed as an ICT consultant for DVD rentals, a business that ...

    This field holds each DVD's unique ID number. DVD Name Text 50 Characters None - These cant be used in this field This field holds each DVD's name. Category Text 50 Characters Combo Box - List Box for Category This field holds the category for each DVD.

  1. GCSE Database Project ICT

    Multiple Table Search Criteria The secretary needs to do a cross table search to find people who have had a filling and search dates of 3-5 years ago who have had a gold filling the database file will be opened and a multiple search criteria will be started and a report is made with the relevant fields on.

  2. ICT implementation report

    9. Delivery YES, NO buttons and IF statement As shown in step 8 the Buttons are linked to the cell next to them.

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