• 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

    I aslo put the same effect 'Blur' on the big 'Special Offers' writing right at the top of the avdertising banner. Now I have to add the text that explanins what the offer actually is. The offer has to be: 'Fly 10 times on any SRL Route and receive a

  1. a level ict project

    Minimal training is required to maintain and operate the system, since easy to follow wizards are supplied, which provide instructions on how to make tables, field names and their types, etc. Plus, the querying function is an essential tool when searching the database using filters, criteria can be inputted and the database will immediately provide relevant results.

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

    made Input a sale transaction Sale �16.99 Sale total should have increased by �16.99 Sale total should have increased by �16.99 Late Total Test that the late total is increased when a late is made Input a late transaction late �1.50 Late total should have increased by �1.50 Late total

  1. Access Database

    a field called Stock of Videos There was not the field, which I wanted 10. Age group of videos There should be a field called Age group of videos in video form There was the field, which I wanted Testing Table 11.

  2. Creating a computer system for a video rental shop

    you are viewing; here you can also add things to the formula. * You can create look-up tables. * You can create graphs using the Chart Wizard tool. * In Excel you can also copy the cell of a formula from cell you cell.

  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