• 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 Database as ICT project.

Extracts from this document...

Introduction

Video World Database AS ICT PROJECT BY ASHAN ARSLAN Dated: April 2003 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 Oakwood's town centre. It is a relatively small shop and has 31 members who live in and around Oakwood. 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 list of all the ...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. Ashan Arslan Video World Database Project 1 ...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.

    RECORD KEEPING AND MAINTENANCE To facilitate the recruitment process and to ensure that proper recruitment procedures are followed, it is important to follow a well established filing and record keeping system. When filing job announcements, job applications, eligibility lists, notice of ratings, and certification lists, it would be helpful

  2. Designing a booking system for an Estate Agent.

    Everybody in this company uses computers as it is required. Everyone must have basic knowledge on how to use software to store and produce information. We mainly use Microsoft excel to work out calculations, present graphs and to enter figures.

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

    Mr Dawson is allowed to spend �999 on a new computer Resource Requirements Access 2002 will be used to set-up and run the new system for Book Zone. To install and use this software a computer with the following minimum specification is needed: * A Pentium 75 MHz processor8''' * Windows 95 or later one.

  2. Database Design

    The primary key for the Product entity is the Product ID, and Supplier ID for the Supplier entity. This is because they are unique to their entities. All these tables are linked by at least one field or attribute. The entity relationship diagram shows us how the entities are linked together.

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

    in hue to help those users who are partially sighted differentiate between different areas. As mentioned in section 1.1 of this document certain software aspects of the existing system will be removed (see section 1.5). Both the Messaging and the Games modules will be deleted, these modules fulfilled their original

  2. I have been asked by a General Sports shop using a manual system to ...

    My third search assumes the manager wants to search for people whose favourite sport is Football and who sport Manchester United. Sorting Simple sorts A simple sort is when you sort records on one category e.g. weight or forename. 1.

  1. Evalution of my database

    by finding out how to place the validations into my database and make them work properly. I also came across some problems which were when I wanted to import my data , I was losing some of my data I eventually resolved this by finding out that my data was corrupted I solved this by renewing my data.

  2. ITGS Mod and Open Source Essay - Counter Strike game and Gimp photo editing.

    Processor 128 MB of RAM 32 MB graphics card Internet connection (for online) Keyboard and Mouse As you can see the system requirements is not high and almost all computers with windows can play this game. Since the first version counter strike does not have satisfying graphics, they improved by

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