• 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. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    They generally will combine the visual aspects of a static prototype with a certain degree of interactive functionality. This might mean navigation, or the use of real web controls, or even mock data processing. As a platform for demonstrating a system, these are the richest, most useful types of prototype, although the slowest to create.

  2. 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()

  1. Computing Project

    Modular structure of system (Top Down Design) Membership Form - The member ship form will be used by the user to register new members with the shop. The data entered will be stored in the 'Members Table' It will also allow the user/clerk to edit or update the data of the members if necessary.

  2. I have been given the task to design a database for a company called ...

    Delivery Date This form will not actually be used to directly enter in information on orders as the order information will be entered in by the user on to an order form which due to the relational links between the tables will transfer the necessary information on to order table.

  1. Video Club Database Project

    New data will be added to the database at a convenient time, possibly at the end of the week. The procedure that the user will fellow is described in the design section. 2. TABLES AND RELATIONSHIPS Tables and relationships were set up as specified in the design section.

  2. Different ways of data capture

    Other banks update the balance straight away (pseudo real time processing). Others transaction e.g's include: * Buying an item in a store * Taking out a library book * Applying for a driving license Master files and transaction files A master file is a collection of records holding information about an entity such as a person or good.

  1. Spare Parts Database Project

    ITEM DETAIL Attribute name Data type and length Validation Item code Text (4) Unique primary key Make Text (50) Model Text (50) Price Numeric (7) Quantity Text (3) CUSTOMER DETAIL Attribute Name Data type and length Validation Customer Code Text (4)

  2. Computing Project

    him statistics easily, draw reports and he is able to see progress easily. I will be producing a prototype that will have limited data but the instructor can try it out and see if this is what he wants. REALISTIC APPRAISAL OF THE FEASIBILITY OF POTENTIAL SOLUTIONS There are many

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