• 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
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49

Video World Data System

Extracts from this document...

Introduction

Video World Data System AS ICT PROJECT BY GRANT WINKLES Dated: January 2001 CONTENTS Page Nos Analysis 1-4 Introduction 1 Investigation Methods 1 Summary of Interview 2 Objectives for New System 3 Constraints 3 Design 5-11 Comparison of Possible Solutions 5 Database Design 5 Data Requirement Definition 6 Design of Input Forms 7 Menu Design 8 Menu Design Explanation 9 Report Design 9 Queries 10 Security 10 Schedule of Activities 11 Test Plan 12-13 Implementation 14-30 System Overview 14 Tables and Relationships 15 Forms 16 Queries 23 Reports 27 Macros 30 Test Results 31-39 Evaluation 40-41 Qualitative 40 Quantitative 41 Test Plan Results 41 Areas for Improvement and Development 41 User Manual 42-47 Analysis Introduction Video World is a video rental shop, located in Ashby's town centre. It is a relatively small shop and has 31 members who live in and around Ashby de la Zouch. The shop is owned and managed by Gary Lane. He set up the business two years ago and has two other staff working in the shop on a part time basis. Gary currently has a filing system that occupies a great deal of space and is very time consuming to analyse. He gives his members cards and has to manually record which video members are hiring. The old paper filing system is very inefficient in notifying when members are overdue with bringing the videos back. This in turn means other customers are unsatisfied when the video they want isn't in stock and so Gary loses out on revenue. Gary Lane possesses greater than average IT skills and is keen to introduce a computer-based system for the rentals of his videos. The system both old and new is needed to: * Keep track of members and their details. * Keep track of the number of videos each member of staff rents out to customers. * Have a listing of all the staff in the shop * Have a list of all the videos in stock * Have a ...read more.

Middle

End user will validate operation and fill in feed back questionnaire Implementation System Overview This Video World rentals system is designed to replace the current paper based system. The system is designed to run on the Video World PC on the basis that all of the staff can access and edit the Database. Input of data into the system is through four purposely-constructed input forms: * Staff Input * Video Input * Customer Input * Rentals Input You can input data at any time and the information that arises from these forms, comes in the form of queries. And so the end user can make use of the information. The queries can be turned into reports for an overall analysis. Tables and Relationships This system is designed so that the mechanics behind all of the forms and reports will not be seen. The end user will only be using forms and reports. Every required input table has been repeated as a form. The requirements of the tables have been discussed in the design section. The relationships between tables is shown in the design section and confirmed in the relationship facility within the Database. A screen shot is shown below: The relationships between the tables are shown. The entities and their attributes used in the table constructed are clearly detailed in the design section. Forms The Menu Structure was constructed as shown in the Design Section. I have decided to leave all of the toolbars and scrollbars in. Main Menu This form was selected as the start-up form (using Tools, start-up). This means it automatically loads when the database is opened. All buttons placed on this form were allocated using wizards. This included the buttons for opening other forms and closing the Database. A macro called Maximise opens the window to a maximum size when the database is opened. Other forms navigated from this Main Menu are: * The Edit Data Menu * Reports Menu * A rentals Menu A screen shot is shown below: The Reports Menu All buttons were placed using wizards. ...read more.

Conclusion

From this form you will be able to rent out the videos to customers. To enter a rental you need to know the Staff ID, the Customer ID and the Video ID. Enter these ID numbers in the relevant attributes. To check if you have the right ID numbers the subforms will show the relevant data. Then enter today's date in the date rented entity. Then enter the date it is to be returned in the date of return entity. Enter the cost of rental in the relevant space, (if you are unsure of how much the video costs look in the video subform and it will tell you). When a video is returned click on the returned button and the record will be deleted. If the date passes the date of return a message box will appear saying that the person owes a video. Click OK on the box and it will dissappear. To go back into the rentals menu click on the back button. Reports From the main menu click on the reports button and you will be taken to the reports menu. From here you can view reports on videos, videos rented, customers, staff and staff's progress. To view a report simply click on the button with the report you would like to see. The Videos report shows all of the videos that you have entered in the video input form. It shows all the videos you own. The videos rented report shows what videos are rented and who by. It also shows when the video was due back and the price of the rental. The customer report shows a list of all the customers that are in the customer form. The staff report shows the members of staff currently employed by your business. The staffs progress shows what videos the staff have rented to people and when they served the customer. To go back to the main menu press the back button. Exiting When you have finished using the database go to the main menu and click on the exit button. Grant Winkles AS ICT Project 47 ...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. Marked by a teacher

    Hardware and Network issues in e-commerce

    5 star(s)

    However, the issue for service providers, is in the implementation of a PKI. In selecting the right one to use the provider must take into account these factors: Scalability - the design of the system must allow the infrastructure to grow with demand End-to-end security - e.g.

  2. Marked by a teacher

    Information Retrieval tools. I have used a database to carry out my searches. ...

    3 star(s)

    You can also check emerald from Metalib that shows the Information about the resource. It also shows the categories that are available. The proximity helps us to find information that is together and Emerald has this function as it allows users to find two data in one.

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

    to file all of them in one folder or a group of folders by position title. All position folders shall then be filed in alphabetical order. If possible, the Recruitment Management Information System (RMIS) or automated recruitment processing system should be utilized to facilitate the evaluation of job applications, the printing of notices of ratings, eligibility lists and certification lists.

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

    Spreadsheets are good for solving problems that have a lot of calculations and numbers. I think spreadsheet would be a problem because searching information does not need spreadsheet, so I think that it would not be very useful for me.

  1. software development

    strategy, which does not need any knowledge of internal design or code etc. As the name "black box" suggests, no knowledge of internal logic or code structure is required. The types of testing under this strategy are totally based/focused on the testing for requirements and functionality of the work product/software application.

  2. Home Office LTD company. Database

    Other functions which are on this sheet is that it includes an auto filter which allows the headings to be sorted into a custom way and also the user can pick one client from it and only there details appear.

  1. ICT Solutions for people with Special Needs.

    I will be concentrating on the users who have limited use of their limbs. There are also variations in aids such as a cane or wheelchair used to reduce the handicapping effect. Even with these wide variations, some characteristics are generally applicable to all disabilities.

  2. Designing a booking system for an Estate Agent.

    Also having a paper based make rooms for human errors and is also hard to organise as some people's handwriting are not easy to read. The diary that is used to keep the information could also be lost or misplaced which would cause hassle to the company as they wouldn't know which clients and properties are booked.

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