• 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. ICT PROJECT

    Data Flow Diagram (level O) Data Flow Diagram (level 1) Objectives of the new system The new system will perform the following tasks: * It should be able to identify students with poor performance by using a visual alert. * Ability to edit incorrect mark, so whenever Ms Gammon make

  1. Creating a computer system for a video rental shop

    First Name Text(15) Surname Text(15) Address Text(50) Town Combo box Text(50) postcode Text(10) DOB Date/Time Rentals Attribute name Comments Data type and length Validation Customer ID Automatically incremented Long Integer Unique Primary Key Staff ID Automatically incremented Long Integer Unique Primary Key Video ID Automatically incremented Long Integer Unique Primary

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

    Filtering, sorting, querying, and form creation are fairly simple tasks, especially when using the many toolbars and wizards provided with Microsoft Access. * The Microsoft Access one file system provides a simple way to make backups. Instead of backing up several to hundreds of data files, only one single file needs to be backed up.

  1. GCSE Calculator Project

    Questionnaire on Calculator Please could you answer this questionnaire where 1 being the worst and 5 being the best. Question 1 2 3 4 5 Easy use? Clear text? Clear symbols? How often do you use the computer? Is the calculator big enough?

  2. Computer project Alevels

    This helps to check whether each patient's allergies and other records about the medical history. Therefore doctors are able to treat the patients according their records resisting any damages or injuries towards the patient. * Item Checking Query Field Table [ITEM_ID] Table - Specification of Item [ITEM DESCRIPTION] Table -

  1. OCR Nationals Unit 21 - Task 8

    I used the text tool to add the text onto the advertising banner. - Text Tool As I planned in Task 7, I will make each word appear one at a time after another. So for me to do it on Flash I have to create many Key Frames with each one having a new word added to it.

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

    Planning of my Method- Project Planning- First I made a clear idea about my database by writing what am I going to include in my database and what all problems I am going to solve. First I researched the problem by going to the library and by asking questions to the book lovers.

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