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

    The greatest benefit from automating the recruitment process is the ability to generate management reports that will assist in providing useful information on the status of all recruitment efforts. The management reports along with a well maintained filing system will ensure that proper recruitment procedures are followed and will assist

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

    As the system is paper based and stored in files, so there are issues with back up and security. 4. Client Requirements The new system has these key features: * Allow employees details to be entered (employee number, surname, forename, grade, national insurance number and date of birth)

  2. ICT Solutions for people with Special Needs.

    of the business, and to employing a workforce that recognises the diversity of their colleagues, and their potential colleagues. It should be ensured that: - * All job applicants and colleagues are treated fairly and without unlawful discrimination on the grounds of colour, race, nationality, gender, sexual orientation, age, religion,

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

    The member should give the card to the assistant so that the number could be taken. The member is asked to confirm date of birth and there pin code for security reasons, they would also have to sign a form for them taking a book out.

  2. Introduction to Information Systems in Business

    PD has been called the Scandinavian approach. The approach stems from the underlying nature of Scandinavian culture. "An essential feature in Scandinavia is, above all, what appears to outsiders as a far reaching and widely supported fundamental concern with the building and development of a society in which each individual may live in dignity and in conditions conducive to personal development.....an egalitarian society."

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

    When a customer wishes to purchase an image they will input their details into the data capture. Once the user clicks 'submit details' they are forwarded to the SecPay system and their software will deal with the validation of the details and process the payment.

  2. The application to be researched is a small company called RS EQUIPMENT. The company ...

    I was told that every month the company is receiving 5% more orders than the previous month. The obvious implication of this is that expansion seems to be next on the agenda for the company director. I also observed and noted that each employee had full concentration on their particular section of the IT department.

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