• 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

    of the DVD such as title, genre etc into a table called the 'films table' using a keyboard. This system will also be able to come up with a list of all the loans which have been overdue so that the shop clerk can target those people for a fine

  1. Form and Function In Design Technology

    As a result, computers became ever smaller as more components were squeezed onto the chip. Another third-generation dlevelopment included the use of an operating system that allowed machines to run many different programs at once with a central program that monitored and coordinated the computer's memory.

  2. ICT Sample Work Welcome Centre Requirements

    Hand written documents are not very professional. 4. What do you want the ICT solution to do? Tony would like the new solution to provide easy to use data entry forms for entering details about each conference. He would like a quotation to be produced immediately based upon the booking information that is entered.

  1. Smart Card System

    The goals of protection are: * Prevent mischievous, intentional violation of an access restriction by a user. * Ensure that each program component active in a system uses system resources consistently with the stated policies for the uses of these resources.

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

    5 Under Permissions select the permissions you want to assign, or clear the permissions you want to remove for the group or user, and then click Apply. Repeat steps 4 and 5 to assign or remove permissions for additional objects for the current user or group.

  1. Computing Project

    time of an availability NextLessonBooked Char, Date/time, Variable D.S Stewart Tuesday 29/01/08 09:00 Name of student and the day, date and time of their next lesson SUMMARY OF EXISTING SYSTEM Currently the instructor receives booking either by telephone or at the end of the lesson.

  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