• 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

    However, there are disadvantages, such as the price of developing such a system with so many advanced features being used, specialist personnel may be required. An alternative solution is to use a generic spreadsheet application to input, process and output information.

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

    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 Food total should have increased by �2.35 Annotated copy of testing When testing the spreadsheets, the main error

  1. Access Database

    To have a customized When I open up database A switch board did Switch board customized switch board not open up should open up Evaluation of objectives * Must have more than one table (entity) to create relationships I kept more than one table, in order to input more data.

  2. Creating a computer system for a video rental shop

    * Digital scales (for weighing parcels) - so weights have been calculated accurately * Computer mouse - to select different function options. * Screen Touch Screen - to speed up the input of data and other functions within the database system.

  1. task2-report-template 3

    3 DESIGN [TOTAL: 12 MARKS] 3.1 Produce Designs for the Data Structure [3 marks] 3.1.1 Data Structure [1] Field Name Field Type Field Length Model Text String Brand Text String Processor Type Text String Memory Size Number Integer Hard Drive Capacity Number Integer New or old Text 3 Price Currency

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

    To encourage students to read more. 9. To help them find people with similar book interest. PLANNING- Choosing the idea (Topic Planning)- Before choosing this topic I thought of making a database on a book club but after few days an idea struck me why not make a database

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