• 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. A Relational Database system to assist the stock control operation of Rai's Newsagents.

    * User-test the system with Mr Khan. * Report on user feedback from both Mr Khan. * Produce a final version of the relational database system. 10 Outcome/Product Evaluation Approach The result of my project will be to create and implement a relational database to help the stock control of the entire shop.

  2. Home Office LTD company. Database

    Also in row 15, it shows the customer which comes from the order form. Product Information sheet The purpose of this sheet is that it provides the user with the information of the products. It includes a unique 4-digit code that the user specified in the user's needs.

  1. ICT Solutions for people with Special Needs.

    local library, help to take advantage of educational facilities (including transport), adaptations or special equipment needs in the home or workplace to help with convenience or for safety, holidays, meals and telephone (and special equipment to use it if needed). Any provision of resources is dependent upon assessment of need.

  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. A report on the impact of ICT

    This isn't necessarily such a good thing, it opens up the possibility of plagiarism and some people argue that by manually looking in a textbook you learn more. However the internet at home is not always bad, when used in the correct way.

  2. Uses of ICT in Varndean

    They are all used to help you purchase discs and other objects that you need to sell the software, and to keep in touch with clients by using e-mail. They also need to use a hardware firewall and router for Internet connection, because lots of the suppliers have online tracking

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