• 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. 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. a level ict project

    Various validation techniques can be implemented, for example range checks, which prompt the user when data that is extraordinary or significantly low data is realised. This will drastically minimise the amount of errors made human users. Moreover, depending on how the spreadsheet file is developed an accommodating user interface, consisting

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

    message that the system produced was when I had made mistakes with the formula: One other error that appeared was when I incorrectly spelt the name of a worksheet that I was trying to link to another worksheet.

  1. Access Database

    With more tables, there could be more forms. More different subjects, and so the database can be made. The main reason was so I can create relationships. The reason for the relationships are so I can relate or link the tables with each other.

  2. Creating a computer system for a video rental shop

    Access: Access also has its advantages and disadvantages, which need to weigh up against Excel's advantages and disadvantages to come up with the right choice of software. Access' advantages include: - * Access can perform advanced queries. * Access can make forms to insert data.

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

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

    Whereas Search A book will also allow students and teachers to add their books so that they share their favorite books or some important books. If you see, whenever we want some good books to read or good book for reference we ask our friends or teachers and when they

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