• 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. Analysis section for database project based on a hotel booking system

    Qualitative performance indicators Must be easy to navigating onto making a booking Must be easy to return to main menu System must not allow editing to prevent mistakes from happening Task

  2. ICT PROJECT PRESENTATION

    My fifth objective was that the database must contain records on Names, Gender, and DOB. This was all achieved (check database) After looking back at my database, I think that I have done a good job, but I believe it could be improved.

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

  2. AQA GCSE ICT Specification B

    It is time consuming, and all processes must be done by hand. These all affect the efficiency of the company, and significantly reduce its profits through human errors and mistakes. Results of discussion with user Output 1: Receipt Information on Output Inputs Required Processing Required Pre-Programmed Data Entered by User

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

  2. What is a computer registry?

    Collapse this tableExpand this table Registry hive Supporting files HKEY_LOCAL_MACHINE\SAM Sam, Sam.log, Sam.sav HKEY_LOCAL_MACHINE\Security Security, Security.log, Security.sav HKEY_LOCAL_MACHINE\Software Software, Software.log, Software.sav HKEY_LOCAL_MACHINE\System System, System.alt, System.log, System.sav HKEY_CURRENT_CONFIG System, System.alt, System.log, System.sav, Ntuser.dat, Ntuser.dat.log HKEY_USERS\DEFAULT Default, Default.log, Default.sav In Windows 98, the registry files are named User.dat and System.dat.

  1. Documentation of a database for a sports centre.

    If you click on the drop down arrow suggested words are shown e.g. "title" - miss, Mrs, Mr, etc. Name of Form frmMainMenu Data Source (Table/query) n/a (Design of new member screen) Form layout/design Extended Report I have chosen fields, data types and primary keys in my table design because

  2. Evaluating a relational database solution

    It was easy to change what the output looked like because I could change the appearance of the information e.g. font size, colour. It was easy to create the different fields because I could choose what information I wanted to insert in them.

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