• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 3109

Simpson &Co. estate agents - designing a computer based system

Extracts from this document...

Introduction

ANALYSIS Background info. Simpson &Co. estate agents are located in Brent. They have made a publicity deal with Flancrust Enterprises, another newly formed Business. Simpson and Co. Are known for their good service to the public and want to start branches all over Brent, however they do not have a system enabling them to record ever changing details of large numbers of customers. Identify the Problem Estate Agents have to sell the right houses to the right customer. They need to know what type of house the customer wants and the features it must have. Estate Agents need to price every house and have a record of all the prices. They must be able to change the prices as they go up and down all the time. Estate agents also need to have a record of the customer's details and the type of house he/she requires. That way the estate agent can call the customer if a house with all the required features becomes available Currently Simpson & Co. is using a manual System for recording these details. They record all the customer details in one book and the details of the houses in another. The disadvantages of this system are: * There is only one copy of each book so a lot of problems will arise if it is misplaced. * Since everything is written by hand, the text could be illegible. * Once written the content of the books cannot be easily varied. * When details change, the database would be invalid * Handwriting all the details can be time consuming. * The files and books take space to store * It is difficult to find a particular piece of information without looking through all the files. * It is difficult to make copies of the files for both the estate agents and each customer. * It is difficult to have a wide range of advertising methods Using a computer would solve many of the problems above because: * A computer can store a lot of information. ...read more.

Middle

From estate agents) * What data do you keep about the customers and houses * How they are finding their current system * How they alter information * How they collect in formation * How they use data * How they advertise * How they involve customers * Do they have to restrict data Different methods could have been used to collect this information. Letters could have been written to each of the two different users. The letters could have either been formal or casual, containing a polite introduction and questions similar to the ones from the questionnaire. (Because the information required is exactly the same either way.) The letters would be mailed and the users would have to send a letter replying with their answers. An estate agent and a customer could have been interviewed. I could have actually met with them and asked them the questions and received their first answers directly. The advantages of the questionnaire * The people whom they were sent to do not have to make the effort to write a whole letter * The questions will be clear so that people can under stand it * Since gaps have been left for the answers, all of the questions are likely to have been answered * Filling in the questionnaire is the least time consuming method The disadvantages: * The questionnaire may accidentally get classed as junk mail * The users may forget to post it Advantages of a letter * It is very personalised, is unlikely to be classed as junk mail. * It can be very polite when asking for information The Disadvantages * Not all the questions may be answered * It is time consuming to write * The users may forget to post it * The questions might not seem very clear. The advantages of interviews * You can explain any questions to the people you'll be interviewing * You will get their responses to all the questions * It is easy for the ...read more.

Conclusion

* We will describe to the customer what the hardware is that we will use. * We will design two different forms and choose the more efficient one and state why it was chosen * The key features of the solution will be discussed including the advantages and the disadvantages * We will design a form mail merge letter. * We will write a test plan with a test and the expected results Implementation * We will enter data in to a database, which will be created. Any modifications will be noted down * The test plan made earlier will be carried out. * The results will be explained with screen prints as proof of testing. * Several queries will be used to find the records * We do a mail merge using the system * We will produce a report * We will write a user guide about the key features, hardware, software required and how to use the system as well as trouble shooting * The user guide will be given to someone to test the system a questionnaire will be given to him or her. * The field design will be explained and the changes made due to testing will also be discussed * The main feature of the software used to make input and output formats will be described. We will justify the changes to the formats due to testing Evaluation * The design brief will be copied and pasted. We will check that the system meets all the requirements and the needs of the users. * We will describe the methods of testing used and the results of the testing and the comments of the person who tested it. * We will explain the changes we made to the system due to the testing * We will describe the limitations and suggest any possible improvements * We will discuss the used software and how easy it was to use. 1 Amodini Palipane 8B.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. System requirements analysis

    Intel Celeron D 351 Processor, 32MHz, 533MHz FSB, Genuine MS Windows XP Home Edition, 256MB DDR RAM, 80GB Hard Disk Drive, CD Rom Drive, Integrated Graphics, 6 USB Connections, 1 PCI Slot, 15" TFT Monitor and it is �150. I think a 14.1" XGA ( 1024x768)

  2. Creating a computer system for a video rental shop

    need to first of all think about the possible use of different types of hardware: - * Keyboard - used mainly to enter in data about the customer, parcel and the parcels destination. * Visual Display Unit - A user-friendly way to display the database system.

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    When the green card has been placed back into the game the employee/manager puts that game on a trolley with games to be put back. Every hour the games are placed back on the shelves. The overdue loans for the games are worked at the end of the day by the employee/manager.

  2. Smarts Leisure Park Database Booking System

    To do this is will use a query and print the information gained as a form for internal use. Data Flow Diagrams DFD 1 In DFD 1, the Customer gives their data to the receptionist, who keyes them in to the database.

  1. Creating a computer system.

    To check that it actually works and achieves the objectives set out in the analysis. I will also need to explain any changes I have to be made. This will also involve creating a user guide, system flow chart, etc.

  2. Computing Project – Designing a Ticketing System for a Cinema.

    The data stores Screen + film, Date + Time, Ticket Price, and Seats taken are where Data is retrieved from. These data stores have had data entered into them before any ticket request has been undertaken, with the exception of date + time where this is more like a clock.

  1. Benefits of using my IT system in the Travel Agents.

    your screen could freeze and due to this you can lose all of your previous work. An extra advantage is that you can present your work in a more professional manner. An additional disadvantage of using a computer is that it runs through electricity and the bad thing about using

  2. I will be analysing the problems defined by the management in the old system ...

    These are some of the features it offers: * Automatic removal of many viruses without interruption. * Script Blocking detects script-based threats, even before new virus definitions are created for them. * Scans and cleans outgoing email messages to prevent sending infected files from the PC.

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