• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Information Technology for Pims Pumps.

Extracts from this document...

Introduction

Information Technology for Pims Pumps. Project Stage 1 : Analysis Analysis section 1 - Background/to identification of problem Pims Pumps are an industrial pumping company which are involved in the distribution, installation and maintenance of industrial pumping units. The company has a large fleet of vans and many specialised tools and lots of equipment. Currently all of the equipment is logged in and out of the workshop and vans and this information is stored on paper. Analysis section 2 - identification of the prospective user(s) The prospective users are the managers of the business all of whom are computer literate and are already using a computer system for other aspects of the business. The company have a small network of computers installed and all involved are competent in opening and using Microsoft access 2000 Analysis section 3 - identification of user needs and acceptable limitations The system needs to be able to store large amounts of data about the whereabouts of equipment, it must be able to search through the data for any specified criteria, it must be able to be edited, it must be secure and user friendly. Interview Example documents from user Observation The proposed system can only be tested to a certain extent on being able to store large amounts of data Analysis section 4 - realistic appraisal of the feasibility of potential solutions. Analysis section 5 - justification of chosen solution I have chosen to use this system because Analysis section 6 - description of current system & data sources and destinations The current system involves the user logging in and out equipment to vans and back into the warehouse. ...read more.

Middle

There will be a menu form giving the user options and security passwords for management to access and edit existing data or to view existing data. All of the data entry will be validated and the tables will be set to certain data types to try and ensure the user is entering the correct information. There will be four main tables related to bookings, employees, equipment and vehicles. There will also be four forms based upon these tables and then a main menu form for easy navigation of my database system Design section 2 - Description of modular structure of system The system will be based around 4 main tables. These are TblEmployees, which contains information about the employees that work at the company. TblEquipment, which lists equipment, details about it, its current location and a list of who has recently used it. TblVehicles will contain a list of all of the vans that Pims Pumps use and contain a list of all the equipment that is currently in each van. TblBookings will record all the bookings in an out that a piece of equipment makes and records the equipment and employee ID numbers. These tables will all be linked together in an entity relationship diagram. Design section 3 - Definition of data requirements The database will have to store relevant information about the employees using the booking system information about the company's vehicles and equipment information. The fields I will store in my equipment table are as follows: 1. ...read more.

Conclusion

keys TblEmployee's primary key is Employee ID and it contains no foreign keys Design section 13 - Planned measures for security and integrity of data Design section 14 - Planned measures for systems security Design section 15 - Overall test strategy Project stage 3 : Technical solution Project stage 4 : System testing Test section 1- Design of test plan & strategy Test section 2 - Minimal test data Test section 3 - Expected results for typical test data Test section 4 - Erroneous data (Check forms reject invalid data) Test section 5 - Expected results for extreme data Check that data just within range is accepted and stored Check that calculations using extreme data works Test section 6 - Hard copy of representative samples of test runs Project stage 5 : Maintenance Maintenance section 1 - System overview Maintenance section 2 - Summary of features used Maintenance section 3 -Sample of detailed algorithm design using a recognised methodology Maintenance section 4 - Annotated listings of program code, macro code & tailoring Maintenance section 5 - Screenshots (Mainly from design view) Table screenshots Reports screenshots Query screenshots Macro's screenshots Visual basic code Maintenance section 6 - List/description of package items developed Project stage 6 : User manual User manual - Brief introduction User manual - Samples of actual screen displays in situ User manual - Samples of error messages and/or error recovery procedures Project stage 7 : Appraisal Appraisal section 1 - Comparison of project performance against objectives Evaluation of end-user requirements Evaluation of the qualitative criteria Evaluation of the quantitative criteria ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Visual basic

    End If If sp2 = True And X9.Visible = False Then O9.Visible = True sp1 = True sp2 = False Exit Sub End If End Sub Private Sub Label2_Click() ' When you click on the Email to Master sky a message box pops up with master sky's email address MsgBox "Email to MastaSky@T-Online.de", vbOKOnly, "EMail" End Sub Private Sub Timer1_Timer()

  2. Computing Project

    upon returning the DVD which was really difficult to do when he was using a manual system as he had to go through the whole file. This will be done by coming up with a sequence of SQL which will be designed to search through the rentals table and retrieve

  1. Form and Function In Design Technology

    Throughout the early 1960's, there were a number of commercially successful second generation computers used in business, universities, and government from companies such as Burroughs, Control Data, Honeywell, IBM, Sperry-Rand, and others. These second generation computers were also of solid state design, and contained transistors in place of vacuum tubes.

  2. ICT Sample Work Welcome Centre Requirements

    Chris is more of an advanced user, and can do all of the above to a more complex level, as well as use graphics and multi-media packages for design work. 6. What hardware and software do you have at The Welcome Centre?

  1. Smart Card System

    Because of the increasing needs and requirements for security filtering and packet classification, ACLs can expand to the point that searching the ACL adds a significant amount of time and memory when packets are being forwarded. Moreover, the time taken by the router to search the list is not always consistent, adding a variable latency to the packet forwarding.

  2. System I designed in order to produce a promotion package for her newly formed ...

    or locked by another person, you can't edit data in the form. Why did the size of my database increase significantly more than the size of the object I added? The amount of information used to represent an object is often greater than the size of the object itself.

  1. Computing Project

    start of the day he checks his diary to see what students he has and gets all their folders. He updates the student folder by adding 1 to the total lessons and writes what he has taught today, what the student did well and what they were weak at.

  2. Describe the functions of each section within the shops and Head Office, paying particular ...

    returns once a quarter for customs and excise. * Arrange for the amount due to be paid. Human Resource (HR) The functions of the HR Department are; * Staff recruitment and training * Place advertisements for staff * Send out and receive application forms * Organise interviews and provide contracts for successful applicants * Keeping standard personnel records

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