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

The estate agency Halletts is an experienced business in Thatcham and have not yet benefited from a computerised system. They are now looking for an efficient database system for all the houses for all the houses they have for sale.

Extracts from this document...


Database Coursework Identify The estate agency Halletts is an experienced business in Thatcham and have not yet benefited from a computerised system. They are now looking for an efficient database system for all the houses for all the houses they have for sale. Estate agency though is not really that simple. To run the business successfully with a computer you need a minimum of three database systems, but ideally you need four. You need one system for the houses you currently have for sale. You need one for all the houses you have sold. You need another one for all the houses that have been taken off the market or put up for sale with another estate agency (these are called 'take offs'. You also (if you find it necessary) have a system for all the people on your mailing list. All this is too complicated for the project that I am doing, so I have decided to use one system for houses the agency have for sale and once they are sold, ideally they should be transferred onto another database but because I do not have another one, I will just take it off the system. The current system works by employees going to the houses for sale and taking down all the details of that particular house and writing it down on a particular form. ...read more.


The Data included in the system will be as follows. Data Type Characters Example House ID Counter Unlimited 01 **House Price Numeric Unlimited �250 000.00 Location Text Unlimited Cold Ash Vendor Last name Text Max 30 Smith Vendor first Name Text Max 15 John Vendor Tel number Numeric Max 15 01635 567483 Date put up for Sale Numeric Max 8 16/01/99 Property type Text No. Of rooms Numeric Max 2 14 *No. Of Bedrooms Numeric Max 2 05 *Number of bedrooms is put in so that the potential Buyer can tell the estate agent how many bedrooms he wants to have in his house. This information can then be entered into the search. **House Price is put in so that The potential Buyer can tell the estate agent the maximum price he wants to pay and this information can then be entered into the database search aswell. A suitable house can then be found In my system, collecting the data is collected and processed in the following way: 1. Employees go to the house for sale with a laptop and enter all the information into a form with the field names specified above. 2. The employee then returns to their headquarters in Newbury where the laptop is linked up to their network and then the loaded from the laptop onto their proper system. ...read more.


Have I met all the objectives set? Objective 1: To provide a quick and easy way to enter data about houses into the system, using tables and forms. * I have achieved this by setting up forms Objective 2: To use validation checks to make sure all data entered is valid, and limit errors * I have also created successful validation checks, such as number fields, and limiting the number of characters in each field. Objective 3: To present data in an organized way. * I have achieved this as well by using structured tables, forms, and a switchboard. Objective 4: To create a way of accessing data quickly and easily, using certain criteria. * I have achieved this by setting up queries using macros, and have also put this into the switchboard. This means houses can be found according to certain criteria, like price range. As you can see, I have met all the original objectives set by me and my end user. My end user suggested that one possible change could be to create reports. This would mean that hard copies can be printed off. He said that instead of having a separate system for brochures, we can use these reports as brochures. I then explained that we will need much more information on houses to be able to create that, like description, directions and size, if we wanted it to look like one of their current brochures. ...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 ICT in Business 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 ICT in Business essays

  1. Marked by a teacher

    Unit 4 Business Studies

    4 star(s)

    loyalty of the customers to the business; once a business has established itself to the customers the business should keep on coming into the business. 2) New profile of customers can be introduced to the business which I am making the website for.

  2. Business Aims and Objectives.

    This helps businesses to monitor and meet their financial aims and objectives. The finance function is very important for the staff because wages and salaries are paid from this department. All employees have a legal right to be paid and to receive an itemised pay statement.


    That means that the impulse cannot be transmitted directly. Rather, the impulse is transmitted by the release of chemicals called chemical transmitters (or neurotransmitters). When an impulse arrives at the end bulb, the end bulb membrane becomes more permeable to calcium. Calcium diffuses into the end bulb & activates enzymes that cause the synaptic vesicles to move toward the synaptic cleft.

  2. There are many ways in which business can be organized

    A common example is where the shareholders may wish to see a policy of profit maximisation, which may not be the wish of directors who see long-term growth as a more important strategy to pursue. Legal Liability and legal status Most large companies are limited by share and must include limited or plc as appropriate in their name.

  1. The business I am going to set up is a snooker club,

    and stock wastage, therefore I will use a method of stock rotation. This process includes using the old stock first so it doesn't perish, if new stock is used before the old stock then eventually the old stock might deteriorate.

  2. Implementation of ATMS at SBI. Banks in India are looking at deploying biometric ATMs ...

    The hood of the ATM accordingly opens either at the front or at the rear. � Free Standing or Through-the-Wall: Free standing (Lobby type) ATMs can be placed in the lobby of branches or in any enclosed area. Through-the-Wall ATMs are fixed to a wall.

  1. The Entourage System: A Feasibility Study

    System Download Speed This requirement is very important as all of those who have used the internet before know that slow download can be very frustrating. As such, the download speed will be critical in determining the system's success and all the databases used by the system should be designed to perform efficiently and retrieve data as quickly as possible.

  2. Management information system (MIS).

    Sales forecast are expressed in volume, value and profit. Marketing research 1] Marketing research: The objective is to gather, record and analyze all facts about problem relating to the transfer and sales of goods and services from producer to consumer which includes market research, price research and etc it involves the use of secondary data [e.g.

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