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

House Database

Extracts from this document...

Introduction

Design I am going to do 3 databases for which in all will contain information of its purpose, the databases will be joined together through a primary key, which will be unique and identify each, joining them all together. . In one will be information on all the houses the real estate agent "elite" own and in another will be information on all the current customers they are dealing with at the moment allowing space to enter new customers as well, and in the other will be a database of the houses what customers have visited. Below is a list of field names I will use for my first database. Field name Data Types No of Characters Reasons for having the Field Validation method Reference number Number 5 To identify each house by a number N/A House number Text 4 I will be having this field, as it will identify the house and pinpoint it's location. N/A Street Text 25 This is necessary for finding the location of the house N/A Town Text 25 This is vital for some customers are fastidious about where they live. N/A County Text 25 This again is needed for the location of the house. ...read more.

Middle

N/A Date visited Date/time 10 To inform us if needed when they visited the house. N/A Time visited Date/time 5 To inform us of the time if it is needed on an occasion. N/A No, of people Number 2 This is needed to inform the user of the number of people so that the user will have a rough estimate idea of how many people will be needing the house. N/A The database I will set up will be used for a number of purpose and used mainly for queries, which are questions that the user asks of the database. Some examples of queries that will be asked include: > How many visits took place to 5 Aston avenue on may 5th 2000? This problem could be rectified easily by using my database and going to queries, then the user could type in the necessary information example; Like 5 and Like Ashton avenue etc. > What houses has Fred Bradley visited? Again this problem could easily be solved using my database and going to query wizard filling in the necessary information. For the first query above the information entered will look something like this My data will be outputted in a number of ways the information will be mainly all screen based and only needed for extensions onto other documents. ...read more.

Conclusion

A file format is the way in which information is stored in a file so that a program can open and save the file. A file's format is indicated by a three-letter extension after the file name. For example, when you save a new document in Microsoft Word 2000, Word by default stores it in Word 2000 format with a .doc file extension. If you want to convert a document to a different format so that you or someone else can open it in another program or in an earlier version of Word, you can select that file format when you save the document this is the same principle as for access except using the different unique file format of .mdb. All my files will be double backed up onto two master discs and be kept safely with other important files they will be updated regularly making sure to include all necessary information. All data will be kept on each of Elite the real estate's company computers for access by all employee's at any time when required. If a fault does occur in the system the master discs should be bought into availability to re-boot the system. ...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. Organising the database at Costsloadsless.

    o You could lose the piece of paper (very easy to do) and if you do that you have no data. And then you will not no what people are members. o You don't need to rely on staff's memories o If you do scruffy writing the staff might not

  2. Smarts Leisure Park Database Booking System

    It will need: - Windows XP Professional (to allow a network) (vista if 2007) - Pentium R Processors (better on networks) - MS Office 2003 (2007) (allowing Word, Access, Excel, PowerPoint) - Antivirus software e.g. Norton The computer that will be used needs to have very minimum requirements such as the processor and the storage available on the hard disk.

  1. Database Coursework estate agent

    The agents can also take a digital camera to take a photograph of the property and can then be uploaded into the database. For the input into my database I will need to put in several field names such as price, address, number of bedrooms ID number etc.

  2. ICT (double award) - Business systems portfolio.

    The Micros system is the main catering program that Holiday Inn use, this system has many different jobs. When a customer orders some food or beverages, the employee uses a touch screen to enter the order; now the bill can be sent to the Opera system and can be added to the room bill or just a straightforward money exchange.

  1. A New System For an Estate Agent

    needs to employ many extra staff because excessive manual work is required. Analysis This is my interview with the owner of 'Folly's agents' How long have you had your own business for? Along with my brothers I have been running this business for 18 years now.

  2. GCSE Database Project ICT

    laminated the degradation issue would decrease greatly, but changing information would become a lot harder. The secretary should be forced to insert all patient information in block capitals to prevent confusion. The dentist could write the date on a post-it note or just simply tell the patient his/her next appointment date.

  1. The end user of my program is for the people applying for the insurance ...

    everything that will need improvement and understand totally how everything works now before I begin to build the new system: * Where to store the collected details of customer's * Updating member system * How to view the collected customer details The current storage At the present time the customer

  2. An I.T. System for an Estate Agent

    The company also needs to employ many extra staff because excessive manual work is required. The first piece of software I could use is a Word Processor. This is used for typing text, which can be edited rearranged and also printed.

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