• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Hire Shop - creating a database.

Extracts from this document...

Introduction

Hire Shop Article I. Description of task. I'm going to make my shop a musical hire shop. I'll base the project on a local shop that hires out musical instruments, PA systems, lights and amplification systems. The database will be for the owner of the musical hire shop. It will tell him what has been hired out, who has hired it and it will also identify if someone has still got hired out equipment although there time has ran out. At the moment the shop does use a computer which stores the information about what is hired out and who has got it. It's stored as a list, not as a database. I think a database is a lot easier to use and information is easy to access. It will help run the shop more efficiently and information will be shown quicker and easier. Analysis I interviewed the owner of Faversham's local musical hire shop to find out what the shop does and how everything is stored on its computers. I asked if he would benefit from a new database system designed specially for his shop. He told me that a database system would be a lot faster and easier for him to gain efficient information about the customers and what they have hired from the shop. For the full conversation please see appendix A. I e-mailed a questionnaire to the shop, which mainly included what the users of the system want from the database. It showed that the users want an easily accessible system that isn't too hard to operate. ...read more.

Middle

20 The shop will need to keep record of what has been hired out Specifications Times new roman Text 70 This information will be needed as customers might ask for a specific specification. Condition Times new roman Text 50 Customers will have to pay for any damages they do to the equipment Hired from/until Times new roman Date 6 The shop will need to know when their equipment was hired out and when it is due back Price Times new roman Numeric 7 This will be needed simply to remind the shop owner how much the equipment will cost to hire out. I have designed the layout of the two databases on power point and put them in the appendix C and D. These lay outs also show a brief idea of what the data capture form will look like. The colour scheme I have decided on is blue with pictures of products that the shop hires out. There will be links on the page to turn to the other part of the database and to go back to the person displayed on the screen and a button to turn to the next person on the database. Hardware resources The hardware needed for my system to work would be: - Mouse - A mouse is essential, as the operator will need it to click on what boxes they want to fill in and to choose options on the screen. Keyboard - The operator will have to use the keyboard to type in the customers' information and the necessary information about each piece of equipment. ...read more.

Conclusion

* The database has 50 records all together. There are 27 records of people who have or is hiring out the shops equipment and 23 records of equipment hired out by the shop. Appendix (J) * The database is very easy to operate as once the information is stored in the database all that is need is a name or a item from the shop etc. to access all the other information about the equipment or the person hiring it out. * The information is very easy to access as once you have found the information (above) then all the information that is needed is displayed as an output on the screen of the computer. * The owner of the shop wanted the database to look good, and wanted the shop logo on the top of the page a long with other art work relating to the shop. Unfortunately the shop owner didn't give me a sample of their logo so I added more artistic pictures relating to what the shop sells * By accessing the data about the date the equipment is due back you can see weather the equipment has been returned or not. If a person is hasn't returned the equipment then the computer operator can print off the page and use the personal details about the person who has hired the equipment to get in touch with them. * All the fields which I stated earlier are included in the database so that all the information needed to get information is displayed on the screen. * The database could be improved by having a newer version of lotus approach and a newer system as the current system is quite slow. ?? ?? ?? ?? Communicating and Handling Information Projects for GCSE Information Technology. Benn Harlow 11G. ...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. For this task I needed to type. I needed to type because then I ...

    The final method is to click on the X in the right corner and click on yes and then enter the destination of where your saving the work to. To save your work on a disk you could first click on the disk picture in the top left hand side

  2. Planning a spreadsheet database for a gun shop.

    Layout is according to the design plan and everything is in its right position. 5 If Calculations are right Test the calculation by observing if the answer is right. Answer should be right. Answer right. Task 5 Evaluation In this task I will talk about how I solved the problem

  1. Documentation of a database for a sports centre.

    are needed. When a company desires a database they need to provide the business needs for the database developers and also the system requirements. The organisation that is creating the database needs to know what kind of data/information is going to be stored in the database and this can only

  2. Designing a leaflet to advertise an electronics shop.

    * Using the test plan run the tests * Print the newsletter and send it to the user * Receive user feedback Implementation User feedback: Dear Haseeb Ali I have seen your initial design and would like to thank you for a very good piece of work you have just

  1. Database design for a games shop.

    the downside is that he will have to buy many cabinets and at least 10,000 folders. This will cost a lot of money, but MR. Walcott has already got a laptop so that will be no extra cost. Also this is a very tiring and complicated way for MR.

  2. What is a computer registry?

    A registry hive is a group of keys, subkeys, and values in the registry that has a set of supporting files that contain backups of its data. The supporting files for all hives except HKEY_CURRENT_USER are in the %SystemRoot%\System32\Config folder on Windows NT 4.0, Windows 2000, Windows XP, Windows Server 2003, and Windows Vista.

  1. bookings database

    This is easy to see and you can click the command button. It is separated from other details and fields. When you click this command button, it immediately saves the data. There are no improvements I would make. Task 2-Find a Guest Performance criteria-quantitative Quantitative performance indicators Have I done it?

  2. Powerpoint review project

    These will navigate back and forward between the slides. I will add these by going to Slideshow > Action buttons where I can then reshape it, choose the fill and position it to how I want. These will be placed in the bottom corners of the slides for navigation use.

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