• 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. Peer reviewed

    How to use a database

    3 star(s)

    Or you want to find a Mr. Smith but don't know fully who he is. To make a query click on query in the main menu and then select create query in design view.


    The field I entered in was the ID instead of the surname one. After I corrected this the result came out correct. Five and Six Form to show all the patients with - Gender, DOB, and Surname, Othernames and title and ID.


    Premier pro isn't compatible with AMD systems which is a shame as most AMD systems are a lot cheaper than the Dual Xeons. Ulead Video Studio CPU= 3GHz Intel Pentium 4 HDD Space = 1Gb Graphics card = GeForce 8800 ultra Monitor resolution = 1280*1024 RAM = 1Gb Ulead video

  2. My database is on a video rental shop.

    I wanted my database to show the owner of the shop which video had been taken out and by whom. I succeeded in doing this but later on realised that I could have made many changes, which would have improved my work a lot more.

  1. What is a computer registry?

    configure the system for one or more users, applications and hardware devices. The Registry contains information that Windows continually references during operation, such as profiles for each user, the applications installed on the computer and the types of documents that each can create, property sheet settings for folders and application

  2. AQA GCSE ICT Specification B

    The user must be able to print every output from the output viewing page. This simplifies the process of creating and shipping an order. 7. Each page must display the company's logo This adds to the professional look, and helps customers recognise information.

  1. Youth Club Database Solution

    Field, so nothing will appear in the 'Owe' Field. The totals columns also contains some formulas, most of which are simple Sum formulas: =SUM(#4:#79) This formula simply adds up all the values in the range #4 to #79, the

  2. User Manual

    Click 'ok' to try again. If the error box still appears, and you are sure you entered the right password, contact the database designer to have the password re-set. If the password is correct, another box will appear on screen.

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