• 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
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  • Level: GCSE
  • Subject: ICT
  • Word count: 3309

Database project

Extracts from this document...

Introduction

Database Project Project Proposal I propose to create a database for my user, the Manager of a plane rental company to help his plane renting system; this rental system will solve all his problems that he currently has with a paper based system. The new system will be quicker, more accurate and use less storage space then the old system. The many problems my user has with the current system includes that it is time consuming, as you cannot search by any table. For example if you are looking for everyone who rented something out in April you will have to look for it as everything may be stored under first name of the customer. There are other problems such as the records can easily be lost or misplaced as it is on a piece of paper. Also all the pieces of paper added up needs a lot of storage space and eventually my user will have to get rid of many of the records. I will finish this unit between 19 April and 21 July 2006. To do this work I will need a workstation and a printer so my user can see my progress. The software I require is a database for obvious reasons and a word processor to type up my report. I will analyse the situation then implement my solution and test that it works. After this I can evaluate my process and go through the mistakes I have made and how I have overcome them. Analysis * My user is Mr. Abedin the Managing Director of the company. * The company is called I Believe I Can Fly. * It charters planes to private and business customers. * Minimum hire time is 3 days. * Maximum hire time is 35 days. * The standard hire time is 15 days. The problems with users current system, which is paper based are: * Time consumption when searching for a specific item. ...read more.

Middle

The search criteria will be: Date Rented = [please enter a search criteria} 4. 4 reports, one based simply on tbl Customer, the other 3 based on 3 queries. 5. A front-end menu (switch board) to display BOTH the forms and the reports at the click of a button. Outputs These will be my four outputs: 1. Current Customers list (based on tbl Customers data) 2. Withdrawn planes list (based on the query for current rentals) 3. Overdrawn planes list (based on the query for overdrawn books) 4. A day's rental list (based on the query to find a particular day's rentals) Implementation and Testing Switchboard I created a switchboard to make access to inputting and outputting systems easier and more user friendly. I did this so that the user is prevented from using programs they do not need. A switchboard is easier to use, as the user just has to click his chosen option. I tested my switchboard by checking all seven buttons. Here is one of the buttons I tested the 'Open Product's Form'. As expected the product's form came up. Startup and Hiding Access I set my system so that the Front End Menu will load automatically when the user opens the file. I also completely hid Access and the object menu so that the user will only see the Front End Menu I have created for him. The advantages of this is that the user will not have direct access to the storage and processing programs, which if messed up will make the whole database useless. Now when the user opens the file, all they will see is the Front End Menu: To do this I went to Tools: Startup and set the options as follows: Combo box testing: Data Type testing Validation testing: Relationships I have related my three tables to form a relational database When I was setting up the relationship I chose to enforce referential integrity for both relationships. ...read more.

Conclusion

6. A list of all planes that are currently rented out and who by. 7. A list of all the planes that are overdue and who by. 8. A list of all rentals for a particular day. System Improvements I have made many system improvements and the foremost is adding more range check validation, which means that in the male or female field you have only male or female to choose from. Also I have made sure that in number fields you cannot write in currency. To improve systems further I have sincerely tested all aspects of the database twice just to be sure that there was no problem anywhere. For the database to be more useful business wise I have added a mailing label system to it, this way all customers can be made aware of the company's promotional offers. Also I have added calculated fields to the forms so the user can see exactly how much he will make by renting that product out. This is done by calculating the daily price of every plane then multiplying it by the amount of days rented out for. Also for legal reasons the user cannot rent out the same product twice so I have set up against double renting. This is done by finding an unmatched query then going into the planes' table, current rentals query, plane ID and then to query In. then you must go into the rentals form, design view then change data to query in. this way the rental system can only rent available stock. Possible Alternate Method I could have used a spreadsheet instead of a database but this system would not be much better then the paper based one. This is because the spreadsheet cannot perform the essential task of building a relationship. Thus leaving just many tables of records instead of a fast, easy to use and professional working system of the database. Saving and Backup I saved my work on the user area in the school network. I also baked up my work by saving it on the USB drive. Farhat Hasan Page 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 ICT Systems and Application 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 ICT Systems and Application essays

  1. ICT PROJECT PROPOSAL

    the customers' details- name, address, Tel no, date of birth, sex, etc * Instructor name and Tel no.

  2. GCSE Calculator Project

    Is the calculator big enough? Is this calculator better than the Microsoft calculator? Can any improvements be done? Please state below Evaluation User Feedback & Possible Improvements After reading the Silver Surfer's response to my questionnaire I have made a summary in bullet points shown below.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    * It must be able to calculate the additions and expenditure of the library budget * There should be formulas in the system that can be used by the librarian for working out budget calculations. Specification: * It will be a spreadsheet on Microsoft Excel 97 * It will deal

  2. OCR Nationals Unit 21 - Task 8

    FREE flight and luxury hotel accommodation at the brand new Access 8 Holiday Resort.' I didn't like how long the whole text was, as the specific audience may not find it interesting to just read a long sentence. So I shortened it into: 'Fly 10 times on any SRL Route and get a FREE HOLIDAY.'

  1. Creating a computer system for a video rental shop

    This means the system must be very powerful and very detailed. However it is more complicated for a non-expert to use. High Level Language Such as Pascal I have decided not to use a high level language, as I do not have the necessary knowledge to produce a system written in a high level language such as Pascal.

  2. task2-report-template 3

    Text String Processor Type Text String Memory Size Number Integer Hard Drive Capacity Number Integer New or old Character 1 Price Currency Auto Colour Text String Gender Character 1 First name Text 15 Surname Text 15 Address Text String Postcode Text String Telephone number Number Integer Order date Date 6

  1. Spreadsheet Project - computer system for a video hire shop.

    Input a late transaction late �1.50 Late total should have increased by �1.50 Food Total Test that the food total is increased when a food is made Input a food transaction Food �2.35 Food total should have increased by �2.35 Test data identified After I had created the spreadsheets, I

  2. Computer study project outline - library and book club database.

    tell a good book?s review we get excited and try to find the book in the library or try to search that book in a book store. With Search a Book the student can check whether the book is in the library or not if not then the person can see where they can buy the book.

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