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

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

    3 star(s)

    It basically focuses on information as a resource. Information management and knowledge management is being applied around the world due to the amount of information that is available around us. Search Engines A search engine is a program that searches documents for specified keywords and returns a list of the documents where the keywords were found.

  2. Designing a booking system for an Estate Agent.

    Also by carrying out an observation I will be able to analyse user skills and which types of hardware and software the company uses. This way I will be able to know who needs explaining on how the system is going to work and take note of user skills before creating a complex system.

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

    The above client requirements are going to be the foundation of the new system and what I must focus on throughout the design and implementation. The system will be implemented to enable Ninja Freestyle Martial Arts Academy to organise class booking more efficiently, deal with cancelation or any kind of

  2. I was hired by Mr Davies to create a website for a newly built ...

    Outcome 7: to be able to extract data in the form of reports 7.1. the total value of proposals sent out during the month, sorted into ascending order on the total price of each proposal. The total of all proposals should be included.

  1. Background and investigation for designing a database for a DVD rental shop.

    The old paper filing system is very inefficient in notifying when members are overdue with bringing the DVDs back, staff have to search through the records which is extremely time consuming, when a person is found to still be in possession of a DVD and past the due date, a

  2. A report on the impact of ICT

    Effects of Availability of Electronic Information in the Household Having the internet at home is now common thing. More than 60 per cent of UK households now have access to the Internet from home. Instead of reading textbooks and newspapers , or asking their parents, children now look things up on the internet to help them with their homework.

  1. Evalution of my database

    I had to revise the skill of creating a database as I didn?t know much about databases when I started the unit but I eventually got the hang of it and was able to complete my work. I had trouble with entering the validations but I quickly resolved this issue

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

    Some features included in GIMP are cropping, changing image formats, editing and other features where you can download. GIMP is developed by volunteers since it is free software where they do not find profit. New features for GIMP are developed in a different source code, where then it can be merged with the main source code.

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