• 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. Designing a booking system for an Estate Agent.

    Here is the interview transcript that I carried out interviewing Raj. At the end of the interview I should get a clear perspective why the current system is not reliable and to be able to understand the clients requirements to be able to create a suitable solution. Interview Transcript 1.

  2. Standard Operating Procedures (Sop) recruitment policies and procedures.

    However, should the appointing authority decide to fill only one of the two vacancies, he shall restrict his selection from the first five eligible only. Consult DOPM for certifications from the different types of eligibility lists The Certification List is highly confidential and its contents can only be released to

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

  2. A Relational Database system to assist the stock control operation of Rai's Newsagents.

    9 Deliverables: * Report of interview conducted with Mr Khan owner regarding implementation of database. * Specify the design, of the relational database system including the features that are going to be implemented. * Produce a working prototype of the database system to show to Mr Khan.

  1. Home Office LTD company. Database

    formatted so only dates can be in those cells and K is formatted for currency, as it is the amount paid. This screenshot shows the sheet working with the auto filter, the links that click on to an email message already with clients email address and the macro button that directs the user back to the main menu.

  2. ICT Solutions for people with Special Needs.

    * Employers are able to recognise their responsibility in showing respect to their employees and contribute positively to an environment where everyone has the same chance to develop and progress within an organisation * The equality and diversity policy should be constantly monitored to ensure that it is working effectively.

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

    Identifying the users I was asked by Winston Newton to produce a payroll system which is effective and has high data storage capacity in order to manage with high demands and linked directly to the booking system which also should be upgraded.

  2. A report on the impact of ICT

    Effects of Availability of Electronic Information in the Household Having the internet at home is now common thing. More than 60 per cent of UK households now have access to the Internet from home. Instead of reading textbooks and newspapers , or asking their parents, children now look things up on the internet to help them with their homework.

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