• 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...

Introduction

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.

Middle

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.

Conclusion

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's also much easier to cater to a whole classroom. Everyone can see what's going on, everyone can partake in the activities such as quizzes, filling in the blanks etc. The whole class is forced to get involved, rather than in taking notes where whoever wants to gets involved.

  1. ICT PROJECT

    The list box is where the user selects the student details. It contains student roll number, surname, first name, gender and form. The properties that attach to the list box The properties from the list box I change the ColumnCount to 4, to give the columns, for the roll number, surname, first name, gender and form.

  2. Creating a computer system for a video rental shop

    This is shown below. The user will have very easy access to the data entry forms, which requires the user to simply click on the appropriate button using a computer mouse, which will take them to the required form. This will not require users to have knowledge about opening and closing forms in a raw database.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    Date Of Issue BOOK RETUNED Book Form: This form includes all the relevant detail of book in the library. Book ID Title ISBN # Publisher Name Authors Name Purchase Price Edition # Subject Stock Level Date of Purchase Pages Shelf Number RETURN FORM Book ID (Drop down menu)

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

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

    The set up the parameter all I did was write this following criteria on the criteria option on the query: Like"*"&[enter member id]&"*" like"*"&[enter DVD id]&"*" like"*"&[enter actor name]&"*" Like"*"&[enter DVD title]&"*" This is the interface that the user will be able to see after the parameter for the query has been entered.

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

    The program will consist of two parts 1) for the librarians, and 2) for teachers + students. For both parts the program will be as simple as possible, to avoid any confusion. I want to make this program the ideal solution, and the most user-friendly interface.

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