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

Database Coursework estate agent

Extracts from this document...

Introduction

Background The Smiths' estate agents are not a technologically advanced company which own a shop on Weston high street. They only sell houses in the local area. They have their agents to fill in forms on the properties they see along with a picture of the property. This is then given a unique number and filled in a cabinet. The details are then copied up and put on a card in the shop window Identifying the problem The problem with their system is that it takes a long time to find the correct file. As the business is expanding it is becoming increasingly harder to find files and some have even been mislaid. This method is also taking up space as each file is put in a large filing cabinet which takes up a lot of space. They have asked me to make a database on which all of the houses can be stored. The advantages of using computers It is better to use a computer based system because it takes up less space than a paper based system. It is also easier to find files as you can automatically search by price, ID, location and others. It also takes up practically no space as all files are stored on the hard drive so there is no need for filing cabinets. ...read more.

Middle

I could back the file up on a C.D. because a floppy disk has too small a storage space, but I will use a portal system through the internet to keep it secure and to access it elsewhere. A portal would also be useful if the company expanded as different stores could be instantly told about sales and the data would not have to be stored on every PC. Data Flow diagrams This is my first idea of what the table will look like and what technical information will be needed. It will also be shown to the estate agents for their views on it. Field Name Data Type Other information Property ID Autonumber (Key field) House number/Street name Text Field size 15 Area Text Field size 15 House type Pull down menu Row source: (Detached, Semi-Detached, Terrace, End Terrace, Apartment, Bungalow, Mansion, Maisonette) Town Text Default value: Weston-super-Mare No. of bedrooms Number Double figures Price Currency 2 decimal place Description Memo Picture OLE object Market date Date/Time Input mask --/--/---- I will have the screen as a calm neutral colour for the user and include the Smiths Estate Agent logo. All of the information will be together so that there is no need to scroll down. ...read more.

Conclusion

It also allows them to print of the forms so that they can be displayed in the window I achieved my second objective. The computer system is a lot faster and less space consuming than the old system. It is also better for customers as they can search for groups of similar properties together to compare them. I achieved my third objective. The forms look professional and include the company logo. They are well enough made so that they are able to be on show for the customers. User Feedback "This project meets its criteria. It opens new positions for marketing. I would like to extend this project so that customers can access the information in the office but also at home via the internet." The database has been made to suit its task but I think that in the future it could be improved upon to suit their needs even better such as extending the database to a website as suggested in the user feedback. This would make it easier for people with children, for instance, as they cannot spend time viewing houses. Despite this I think that the database was made as good as the extent of my current knowledge and professionally enough to be used in day to day retail use. ?? ?? ?? ?? Nabeel Nawaz Page 1 08/05/2007 ...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)

    I will do this task by computer using Microsoft Paint because it is easy to erase errors and it is much easier and much simpler to draw on the computer when you have the specific drawing program. Create a database + Queries + Forms and final Switchboard I can do

  2. ICT PROJECT

    Enter F To see how validation system handles correct data To make sure that it accepts correct data 11. Enter cat To see how validation system reacts to erroneous data Data should not be accepted. User will be told to enter correct data Data entry form Test and data used Purpose for test Expected result Results after testing 12.

  1. System requirements analysis

    It includes, the Microsoft Works word processor, spreadsheet, and the works database. Since it is cheaper, it would be more affordable for Howard Health Centre. The disadvantage of using this alternative software is that if the Practice encounters a problem, they would have to take it back to the shop and ask them to resolve the problem.

  2. I will design a new video database for the video shop that will also ...

    Searches are confined to your FrontPage web or subweb. If you need a broader search, you can still use the IU Search Service in your FrontPage web. * Discussion groups: FrontPage provides a simple discussion group feature. Discussion groups can be created as part of an existing web or as a separate subweb.

  1. Ict coursework full

    each product page of the site. The copyright information will be black, in size 8 Arial. Home page #3: The logo will be in a green font colour, in size 30 Arial. The slogan will be in a black font colour, size 16 Arial. The text navigation will be black, in size 10 Arial.

  2. GCSE ICT Coursework Booklet

    work and if they don't have a computer at home they would not be able to catch up easily, so they may feel pressured to get a computer for themselves. * The new computer system could affect people's moods negatively because they would be on the computer all day and may become depressed.

  1. Creating a computer system for a video rental shop

    attributes values are atomic, therefore it is normalised to the 1NF To check for the 2 NF. We found that every non-key attribute is functionally dependent on the unique identifier (Transaction number and Video ID). To check for the 3NF, It shows that all non-key attributes are mutually independent.

  2. Creating a logo, template letter and a website for a travel agent.

    I will do this task by interviewing the manager of the travel agency because asking the manager will be the easiest way. Also the manger will give you all the answers correctly and what ever question you need to know, the manger will give you the answer.

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