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

    Wait for 10 appeal period 7. Generate the Certification list 8. Review and specify who will be on the list 9. Print the Certification List and Interview Notices BASIC KEY COMMANDS F1+R = REPRIEVE F1+S = STORE or SAVE F1+D = DETAIL or VIEW or GENERATE F1+P = PRINT F1+A = ACCEPT F1+E = EXIT DETAIL PROCESS 1.

  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

    a step further and advocates that a working model is worth a thousand pictures); * a very high level of user involvement in the development process to aid in communications and to encourage feelings of commitment and ownership; * the empowerment of highly skilled, multi-disciplinary teams consisting of users, analysts and technical specialists.

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

    A change in prices requires amending and updating stock values. Since the current process is to manually take account of this, the shop owner will have to go through this repetitive process and it will take a very long to complete this process.

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

    Implementing using this approach will allow more accurate time estimates and suitable allocation of tasks and makes the whole process easier to intellectually manage. The IEEE has a recommended practice for Software Design Descriptions (SDD) and this will be used as a guide when developing the software system.

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