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

Database analysis of 'a video lending library'.

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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. Database design for a games shop.

    Furthermore MR. Walcott has already got a laptop with Microsoft access installed in it so he does not have to spend any money on buying a software. Also they are advanced in ICT so using and maintaining this software should not be a problem.

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

  1. What is a computer registry?

    MORE INFORMATION Description of the registryThe Microsoft Computer Dictionary, Fifth Edition, def... Description of the registry The Microsoft Computer Dictionary, Fifth Edition, defines the registry as: A central hierarchical database used in Microsoft Windows 98, Windows CE, Windows NT, and Windows 2000 used to store information that is necessary to

  2. Reviewing different multimedia presentations.

    in the whole Multimedia Presentation which makes it very dull and non interesting. This is a not so good feature because it makes the Multimedia Presentation dull and none interesting which makes people not look at there Multimedia Presentation for long so they wont get people contacting them about there product.

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

    This took me a few attempts to get right, as one little mistake upset the whole formula, but in the end I had worked out the correct formula to use: I then put this formula into the "Logical_test" in the argument box and pressed ok.

  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.

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

    Finally, I will have to design a new Logo for Luxury Hotel to boost the image of the Hotel and to give it a professional feel. This logo will be used on all letterheads to members. I will use paint/fireworks (Choose only one software you are already familiar with pls.)

  2. bookings database

    Ideas for improvement would be to add the 'Make a booking' command button so after seeing the details, you can make a booking. Also, there should also be the 'Modify Guest details' command button so after checking whether the details are missing from one form, you can modify this. 3.

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