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

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

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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 ...

    (Due to the way the orders are stored in the database, orders and products can only have a 1 to 1 relationship) Customer: Customer ID, Title, Surname, First Name, Address, Post Code, Telephone Number, D.O.B, Amount Owed, Amount Paid Rental: Customer ID, Video ID, Date Out, Date returned,Paid Video: Video

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

    DATABASE SCHEME UNF MEMBERS: (MEMBER_ID , TITLE, F_NAME, M_NAME, L_NAME, ADDRESS, COUNTY, POST_CODE CONTACT_#, DATE_JOINING, EXPIRED_DATE) DVDs: (DVD_ID, DVD_TITLE, DIRECTOR, ACTOR, , PRODUCER) 1NF MEMBERS: (MEMBER_ID , TITLE, F_NAME, M_NAME, L_NAME, ADDRESS, COUNTY, POST_CODE CONTACT_#, DATE_JOINING, EXPIRED_DATE) DVDs: (DVD_ID, DVD_TITLE, DIRECTOR, CATEGORY_DESCRIPTION, RATING, PRODUCER)

  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

    Another search enables the user to search for specific patient detail, as this is not a fixed value; (naturally, as people do not have the same name) I assume a query with variable parameters would be adequate and should cover the patient forename and patient surname and the user should

  2. ICT implementation report

    As the box is ticked and un-ticked the cell next to it will change to TRUE or FALSE this enable me to create an IF statement formula that links to this cell in order to give discount or not. This IF statement is designed to give a 15% discount if

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