• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49

Video World Database as ICT project.

Extracts from this document...


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.


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.


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. Marked by a teacher

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

    3 star(s)

    The type of material that comes up depends on what you search for. If I were to search for NHS, the material that comes up will be about health and care.

  2. Datbase Project newsagent shop

    It will consist entry fields, data capture forms, tables, macros and queries. In order to avoid losing my work, I will backup them every few minutes. They will be stored in floppy disks and hard disks. I will backup to access and make a copy of my work a template.

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

    After the GG-1 is cleared, the appropriate Personnel Action is processed. NOTE: The above steps apply to both LTA's and TA's. However, please note that an LTA appointment cannot be transacted if a sufficient Eligibility List exists and is current for the position to be filled.

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

  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. The Effect of ICT on Business: Manufacturing

    It is estimated that each robot replaces between five and ten workers. Consequences The consequences to companies and businesses who have restricted or no access ICT would find it increasingly difficult to meet the needs of the customers. This is because the businesses who do have access to ICT mainly

  1. Home Office LTD company. Database

    Another way is for the user to use vlookup, but a problem with this is that it only works for one entry and when you want another entered, it did not work. It just changed the previous clients' information that was entered using vlookup.

  2. Designing a booking system for an Estate Agent.

    1.5 Evidence of the use of relevant investigation techniques. I will be using an interview technique to find out more information about the client and the existing system they use. I will be using this technique as it is the most effective technique to find out the specifics that the client wants and to identify the current problems that they are having with their current system.

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