• 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

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

Extracts from this document...

Introduction

Background and investigation Introduction JenJams is a family run convenience store which also supplies DVDs for rental, located off Wilstead high street. The shop is owned and run by Ashley Bradshaw who is accompanied by his wife Mrs Bradshaw and his son who are part of the shops staff. He set up the business 7 years ago and has stuck with the old system. Mr Bradshaw's wife and son work in the shop on a part time basis. It is a reasonably sized shop that provides entertainment to roughly 300 members who live in and around Wilstead. People who want to become members have to be 18 and over and during the membership process identification has to be shown. Ashley is my client but the users will consist of him and the other members of staff. Description of the Current System The shop is signed up to Choices UK which supply the DVDs'. The shop receives 4 new DVDs on a weekly basis. When the films arrive they are assigned a video number, catalogued and put out on display. The shop also sends back 25 films of their choice, usually on the fact that they aren't popular anymore; they then receive 25 DVDs in return. The shop is entitled to request a certain film from the 25. Ashley currently stores all membership forms in a pink folder. The amount of membership forms is unknown and Mr Bradshaw isn't shore whether all the people within these forms are still members. This means that JenJams may be storing expired data. When a customer decides to become a member the initial procedure involves filling out a membership form, they are then issued with a membership card; when a member wants to hire a DVD they choose the film they want, by choosing the assigned DVD case from the shop floor, all DVD cases on the shop floor are kept empty. ...read more.

Middle

All DVDs are stored under the counter for quick access and they are kept in number order. Their original cases are kept on the shop floor for display. 12. What details do you hold on your DVDs? When new DVDs are introduced they are given a number and there Title, genre, date released and certificate information is held. 13. How do you introduce new DVDs? I have to decide using my own knowledge which DVDs need to be sent back to choice UK. This usually involves me picking out what i think are the least popular DVDs. the new DVDs are then given new numbers and placed in order. 14. What details are recorded when a rental is made, and where is this data stored? When i new rental is made we record the date of rental, price of rental, due date, customer number, members name and contact details along with information on the DVD being rented. 15. Do the videos have unique identification numbers? If they do not, would you like the new system to do this? Yes we do currently have 'DVD Numbers' for each DVD. 16. What firms supply the business with the DVDs? We are signed up to 'Choices UK' who provide all our DVDs. They also take our least popular DVDs. 17. What is the average rental price for a DVD? As we tend to keep the latest and most popular DVDs we have a rental fee that is the same for all the DVDs. this fee is �2.99 per night. 18. What is the lowest rental price, and the highest rental price? All rental fees are the same 19. Do you have an overdue fee system in place for late rentals? An overdue fee of �2.99 is charged for each day the customer is overdue. 20. What type of information would you like to be extracted from the new system? ...read more.

Conclusion

The system must: UR1: enable DVD details to be added/edited/deleted/ displayed onscreen/printed; UR2: enable staff details to be added/edited/deleted/ displayed onscreen/printed; UR3: enable returns details to be added/edited/deleted/displayed onscreen/printed; UR4: enable rental details to be added/edited/deleted/ displayed onscreen/printed; UR5: enable customer details to be added/edited/deleted/ displayed onscreen/printed; UR6: enable the return date of the rental to be calculated automatically; UR7: enable old customer information to be moved to an archive file; UR8: enable old rental details to be moved to an archive file; UR9: enable old staff details to be moved to an archive file; UR10: enable the total price of Video rental to be calculated automatically; UR12: enable the age of a customer to be calculated automatically UR14: enable overdue fees to be calculated automatically, exponential to the number of days overdue; UR15: display/print a list of DVDs on rental; UR16: display/print a list of all DVDs to be returned that day; UR17: display/print a list of all overdue DVDs; UR18: display/print a list of customers' contact details; UR19: enable user to search for a particular customer's details; UR20: enable user to search for DVD details; UR21: enable user to search for a particular rental details, such as the number of dvds rented in a month; UR22: enable the above user requirements UR15-18 to be displayed onscreen or printed; UR23: enable user to create a letter; UR24: allow customer details to be added into a letter; UR25: be user-friendly; UR26: be menu-driven; UR27: Decrease the amount of paperwork needed; UR28: reduce data duplication; UR29: increase the level of security; UR30: comply with the Data Protection Act 1998; UR31: have a user guide for the instruction of users on how to use the system; UR32: hold data of a high level of accuracy by using data validation methods; UR33: be speedier than the previous system; UR34: use a password system for security; UR35: be easy to understand for the user. UR36: be able to back-up data UR37: have a disaster recovery plan management strategy ?? ?? ?? ?? 1 | Page ...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. Standard Operating Procedures (Sop) recruitment policies and procedures.

    After the GG-1 is cleared, the appropriate Personnel Action is processed. NOTE: The above steps apply to both LTA's and TA's. However, please note that an LTA appointment cannot be transacted if a sufficient Eligibility List exists and is current for the position to be filled.

  2. ICT coursework: Designing and implementing a book rental system

    The assistant would ask how long they would like to borrow it and stamp it on the book and also type it up in our files. If the security question is not answered wrong the assistant would not get the card back unless they bring proof so show there self.

  1. Database Design

    I started adding in buttons linked to these forms. I did this by going to the design view of my main menu, then creating a command button on it. When I did this, a window popped up like this I went to Form Operations from the categories section and from there I went to Open Form.

  2. The purpose of this document is to provide a design for an electronic payment ...

    database server. From: www.computeruser.com/resources/dictionary. PHP Widely-used general-purpose scripting language that is especially suited for Web Development and can be embedded into HTML. From: www.php.net. SecPay Ltd A secure, online, real-time payment service provider, supporting all major credit and debit cards with the (major)

  1. I have been asked by a General Sports shop using a manual system to ...

    It is also easier to amend (edit) a record on a Pc. Databases also use fields; here are the ones I will probably include in the database: E-mail address Date joined Gender Mobile number Medical equipment needed Allergies Emergency contact number Photo Paid membership fee Phone number Address Length of membership DoB Deck owned Surname Forename Analysis

  2. Designing a booking system for an Estate Agent.

    This would also save time as they wouldn't need to copy up written details of the client as they could just type these straight away. The tables are more organised which means that the users could just click to select (for example to insert address)

  1. Planning a payroll system for a martial arts school.

    The booking system will inform the senior instructors when their next training session will take place and which members has registered for it. The senior instructors are the main target audience the booking because the output will be directed to them.

  2. ITGS Mod and Open Source Essay - Counter Strike game and Gimp photo editing.

    GIMP is created by Spence Kimball and Peter Mattis. Its development started in 1995 as a project in University of California, Berkeley. Its first version was released in 1996. GIMP works in all known Operating systems such as windows, Linux and Mac OS X. This open source program has simple tools where users just need some finishing touches and not detailed editing in Photoshop.

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