• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 4039

Database analysis of 'a video lending library'.

Extracts from this document...


Task 1: Identify the problem Introduction: Today I was given a task from my father's friend. His name is Mr.Hussaini. As he owns a video lending library, he has problems maintaining the cassettes and the customers. He uses a manual method for maintaining the business; he uses paper files in order to record the no. of people renting the cassettes from the shop. He keeps each file for every customer who comes in the shop and rents the cassettes in order to keep a record of it. As now he has a huge no. of files for every single customer, it is very difficult for him to trace a customer file when comes to return a cassette. Mr.Hussaini doesn't have a computer currently. Apart from these, he also got more problems, which are put below. Problem: I asked Mr. Hussaini what problems he has been facing so that I can make my solutions suitable for his problems and this is what he told to me 'I have made the following table showing all the problems I have been facing: 1. Customers are not returning the cassettes on time. 2. Problem maintaining many customers. 3. Problems maintaining the cassettes. 4. Problems in tracking a cassette. 5. Problems in sorting the files in alphabetical order.' Real User: The real user of the system is Mr. Hussaini because he will be the one entering all the information about the customers signing up as a customer in his video library, so he will be the real user in my project. User requirements: I asked Mr.Hussaini, what he is expecting to see and what he wants me to include in my results and he gave me the following list of things he would expect from my results. 1. To give him alternative solutions on the problems he has mentioned above. 2. To select the best solution for his problem. ...read more.


space is required for the default configuration of XP Professional, plus 50Mb for each additional language interface installed (Access 2000 required 200Mb) The basic functions of the database are: * Add new data to a database, such as a new item in an inventory * Edit existing data in the database, such as changing the current location of an item * Delete information, perhaps if an item is sold or discarded * Organize and view the data in different ways * Tables * Forms * Reports * Queries * Macros * Modules * Internet Hardware: 1. A computer 2. The visual display unit: you need at least a monitor of 17,19or21inch to avoid eyestrain and to see your work. 3. A mouse: one of the most important tools for the use of desktop publishing. 4. A key board 5. A ink jet colour printer 6. A scanner 7. A digital camera 8. And many more Data collection: I went to Mr.Hussaini's shop and had a look at the information in the files, which he had recorded earlier to maintain his business. He was maintaining paper files; the files contain details of the customer and the details of the cassette, e.g. the name of the customer and the cassette, the phone no. Of the customer in case of emergency, the rent of the cassettes etc. Hence data is available in rough form in the files and folders. This need to be arranged and sorted, I spent considerable time sorting this out as: ? All customer related papers, files and documents as one pack. ? All cassette related information held in registers, files as one pack. ? All transaction-based information held in papers that contained information about the issue and return, registers as one pack. The data is going to be collected as hand written text and then I am going to enter it into my Database application. ...read more.


The system than displays an uncomplicated menu for the database. This is supported by one further menu, which allows the user to add or edit data into the tables. The customer's names are in the order of the SL. No. and this makes it easier for Mr. Hussaini to carry out his work. Adding customer or cassette records and issue and return information in the database is very easy with the aid of data input forms. It takes only a few seconds to enter a customers or cassettes details. There are three reports. These show a particular table such as customer, video or issue and return. Each report has the same selected 'Industrial' background. The entire original user objectives have been fulfilled very successfully. I have also related all my tables and have made the issue and return sheet as my unique primary key table and the video and customer ID as my unique primary key field. User feedback on solution Mr. Hussaini was given the system to try out and she replied me with the following letter. Final user comment: To Insha Afreen, Student of Year 10 Al Risala School Sub: Letter of appreciation. I am very happy to see the application developed by you. It is conforming to all the requirements I had supplied to you and is more than I had expected. An improvement a can also be made which will involve adding a new one further menu which will allow me to view and print my reports. Anyway I am very pleased and we are now planning to utilize your hard work in our day-to-day activity for running the business. Best of Luck. Regards. Syed Mr.Hussaini Further ideas for improvement: The system could be developed to have a menu, which is preceded by two further menus that would allow Mr. Hussaini to view or print the reports. The customer ID and video ID and could have been replaced with the name of each customer or video name. This would not have been so difficult. ?? ?? ?? ?? 12:30:03 PM ICT DATABASE COURSEWORK 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 GCSE Software 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 GCSE Software essays

  1. Analysis section for database project based on a hotel booking system

    There is the ability to change or update a Van's identity for example if it is involved in an accident and is written off or if a new Van is added to the stock, it updates automatically. These are possible because these command buttons presented in the forms are all

  2. The aim of my project is to make the task of the allocation of ...

    Create areas for input of pricing of seats, different costs for different performances and fixed costs. c. Use the above data to create the formulas which will be used for the calculation. d. Implement drop down menus. e. Record macros.

  1. Selecting the best software for a theatre business.

    whether they are making a "profit" or a "loss" or even "break even" . This will help Bob because he will be able to quickly take a glance at the spreadsheet and know if he is going to have to make changes or not.

  2. Database design for a games shop.

    Analyse Software For me there is only one software that is available for me to produce for MR. Walcott and Ben, which is Microsoft access. The reason I am choosing this software is because after doing some research it is the best software available to me for blockgamester's problem.

  1. What is a computer registry?

    A Computer Registry--that is synonymous with Windows Registry--creates a database of information about all hardware, software, devices and programs installed on the computer. It is a repository of information about the computer's configuration. It tracks any changes made to the settings.

  2. Reviewing different multimedia presentations.

    This is a good feature because it makes the Multimedia Presentation look more professional and a better looking complete product. The final good feature is that there is a contact page so it is easy to contact them if you want them to do work for you because it includes there e-mail and phone number.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    To copy the formula I hovered over the bottom right of the first cell, and waited till a black plus sign appeared. Once it had appeared I grabbed it and pulled it down, high-lighting all the cells I wanted the formula to be present in.

  2. Desktop Publishing - Analysis

    Software Word processing - With this I can manipulate the text easily. For example, I can choose different font sizes in different styles or by underlining the text and making it bold. I can put line spacing in easily and put things in italics and bold to make them stand out.

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