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

A New System For an Estate Agent

Extracts from this document...


Description of problem The aim for this course work is to design a new system for an estate agent called Folly's agents. The database will be designed to hold information about the properties such as number of bedrooms, garden size, price etc. Currently the company is using a filing cabinet to keep the current data, this takes up a lot of space and it is hard for the workers to access or amend the information. I will need to design a solution for this problem, my system has to be fast and easy to use, the information should be clear and easy to change. I will need to find out how the workers are currently using their system and I will need to see if the new one will be easier and faster. Investigation I arranged to meet the owner of Folly's agents, so that I could find out how they keep their files and records at this present moment. I want to see how they change, search or add any information. I want to know what they need for their system. Feasibility study Advantages � Computers are very accurate. � Computers can work continuously 24 hours a day. � Less paperwork involved, it is all stored and easily accessible from the computer. � Low risk of data being erased as it can be stored on various backups. � Not a lot of energy is needed to get data, this saves time and is efficient. � Data can easily be presented in tables, graphs etc. � Changes and corrections can be performed at the touch of a button. � Validation check minimises the chance of any errors. Disadvantages � The hardware and software can be very expensive. � Employees will need to be trained regarding usage of the computer. � If the computer crashes or there is a power cut, access to data in the computer is lost. ...read more.


Graphics - This package can be used to design illustrations, drawings and logos , and it is also used to modify pictures, photographs or animations. In this package there is a wide range of colours, shapes and lines. This type of package is used to create cartoon animations, produce computer games, design logos and creates pictures. The drawing can be printed out or a collection of these can make a movie. Database - This is a collection of data organised for storage in a computer memory and designed for easy access by authorised users. The data may be in the form of text, numbers, or encoded graphics. Originally devoted largely to the sciences, these automated databases now embrace a comprehensive array of subject fields. The cost of these searches, whether covered by the library or the patron, is often offset by the great efficiency of the searches, especially in contrast to earlier methods of manual searching through multiple printed sources. This work also represents a partnership of the for-profit private sector with the public library community. In effect, it is another form of library networking. Relational Databases in computer science are types of databases or database management systems that store information in tables-rows and columns of data-and conducts searches by using data in specified columns of one table to find additional data in another table. In a relational database, the rows of a table represent records (collections of information about separate items) and the columns represent fields (particular attributes of a record). In conducting searches, a relational database matches information from a field in one table with information in a corresponding field of another table to produce a third table that combines requested data from both tables. In my research I discovered that using a database was the ideal application for my system because it enables me to store data easily, to create forms and records, its more efficient, cost effective, saves space and is time effective. ...read more.


Evaluation of Solution When I first investigated this project I decided that I should evaluate the system by comparing it to the following points: � If it works properly � Whether it is organised or not � It must be able to save data � It had to be accurate � Must be faster than the previous method � The system has to be easy to use. � The system has to be easy to search. The testing shows that the system works correctly, as I tried with several different things and it always gave me the correct answers. My system took around half a minute to add a new entry and the same task took quite a few minutes to add a new entry with the old manual system, and the records in the manual system can easily be misplaced. However, my system does not find customers if their names have been typed incorrectly. Even though I expected this to happen it did not cause any confusion or problems. Therefore I find that spell checkers very efficient which find close suggestions to the one typed out. The Estate agent is booming now, all the workers have easy tasks, the owners are saving money and the customers get what the want efficiently and quickly. The owner was delighted, as this was what his business needed, the staff do not have to go through a lot of file and record to find some information. Due to the above explanations I think that my system is user friendly and easy to use, this is what the company required and has been provided. The people who are going to use the system are happy and have been trained to use the system and are building the system with all the data about the properties they are agents for. It has become easier for them to amend any data, this will mean that the information in the database will be up to date and the customers will have all the latest information. ...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. Peer reviewed

    Designing a database for Type a Flight Travel Agent.

    3 star(s)

    use it because WordPad does not have as many functions as Microsoft Word does. I will do this task by computer using Microsoft Word because it has a lot of functions to make creating letters easy and more professional. Writing reports at the end (User Guides)

  2. Different types of technology How I use ICT at home and at school

    It can also do everything that a projector can usually do. It can put on a video for the whole class, display one thing to a whole class or go through slideshows and such. It's much more advanced than the typical whiteboard and board pen combination.


    Gender and form are entered using a combo-box. This prevents variations in the data entered as the user can only select from a set list. The combo box for form Obtains the data from the named range form in the lookup sheet.

  2. Creating a computer system for a video rental shop

    The screen print below shows one such list box which brings up possible suggestions for peoples name titles. However if there was a duke the user simply has to type in the title and the system will accept it. This is shown below.

  1. Introduction to information skills and system. An information system is a system that accepts ...

    Information technology - application software may be available e.g. existing accounting softwares. If not then programme has to be written and meets the exact needs of new system. Technical specification - new hardware support need or not. User documentation - user manual for new system. Must be user friendly. Implementing This is the stage of applying the new system.

  2. Database Analysis and Database Design Project - DVD library for moving images.


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

    Next I surveyed my friends to find out what all information does they need when they want information for a particular book. Software planning- When we were first told about this project, there were various software?s from which we could choose.

  2. Computer Studies Past paper definitions

    Handshaking any two from: exchange of signals/protocols to establish communication/readiness (to send and receive) between two devices/computers examples: printer and computer, modem and computer[2] (d) Simulation any two from: studying the behaviour of a system by using a model/represents real life/mathematical representation results can be predicted examples: flight simulator, hazardous applications, training[2] (e)

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