• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15

What the business does and how it works to just give the examiner a rough idea. I will then have to design and produce a database for the business to use in their day to day work

Extracts from this document...


GCSE I.C.T Coursework Table of Contents TABLE OF CONTENTS 1 INTRODUCTION 2 OUTLINE OF THE BUSINESS THAT I WILL BE BASING MY PROJECT ON. 2 QUESTIONNAIRE 4 SPECIFICATION 6 INPUT: 6 OUTPUT: 6 PROCESSING: 6 DESIGN FOR MY GCSE PROJECT 8 VALIDATION AND VERIFICATION 9 TABLES OF DATA 11 CUSTOMERS 11 STAFF 11 JOBS 12 HARDWARE 14 INPUT DEVICES 14 OUTPUT DEVICES 14 PROCESSING 15 SOFTWARE 15 Introduction For my GCSE I.C.T coursework I have been asked to approach a business and find out about them. Once this has been done I have to outline what the business does and how it works to just give the examiner a rough idea. I will then have to design and produce a database for the business to use in their day to day work. Once finished the completed piece will have to be tested and commented on, comparing it to how I planned it to be in my design. There are many different things that I will have to think about when designing and producing my database. These are: > Will the project be easy to read and understand, enabling the examiner to mark it correctly. > What type of data will be stored in the database and how much of it there will be? > Whether different users should have access to all of the data or if they do should they be able to edit it. > Will my database be user friendly or will people have to be trained to be able to use it. > Will the database comply with the specifications set before the designing stage of the project. > How smoothly will the database run and is there a high chance of something going wrong. Outline of the Business that I will be basing my Project on. The company that I have chosen to do for my I.C.T GCSE coursework is called 'Philip Dadds Architect and Associates'. ...read more.


they doing enough work, how can you make them work harder, do you need to keep them on or are they not needed. Processing: The processing that the business would have to do is that they would have to sort and search. The kind of sorting that they would have to do is: * Category of job: jobs could be put into categories of size, location, cost, type (renovation, development or new build). * Client's jobs: what jobs are with which clients, what is there biggest or latest job. * Uses of sorting: it would make certain jobs easier to find, do not have to scroll through large lists to find a job. Design for my GCSE Project The program that I used to draw my design is called Chartist and is made by Novagraph. This program was particularly good for the job because it enabled you to put boxes in a blank screen whereever you wanted and to join them together with arrows. Validation and Verification When an electronic form is filled you will always have to do validation checks to try and make sure that the person has filled in truthful data or that they have not made a mistake when entering the data. The seven different types of validation checks are: 1. Range Check: this check is where data is checked to see if it falls between a certain set of limitations e.g. when you ask someone to fill in their age you set the range to be between 0 and 130 years old. If it is out of these limitations then the person is likely to have been lying. 2. Presence Check: this check is where things are checked to actually be filled in. For example if you ask someone to fill in their surname, you want to check that they have actually put an answer down and not just left it blank. ...read more.


The printer will also hopefully be able to print out invoices straight from the database. The type of printer that I hope to be used with the database is a colour laser printer. I want this because even though I want the pages to be in colour so that they please the customer more, I also want the printer to be fast so that the business is not held up by it. It will be useful to have a printer that is quite fast when reports are being printed out because they may consist of quite a few pages. The speakers could possibly be used to let people know if they have made a mistake or when the database starts up a sound could appear, just as when 'Microsoft Widows' opens and a short tune is played. Processing The computer that the program has to run on will need to be able to process the reports that the database entails. It will need to have sufficient 'ram' to store the amount of data contained in the database. The computer will also need quite a fast processor so that the data can be retrieved and saved quickly. A fast processor will also enable the reports to done quickly. The computer doesn't actually have to have a fast processor, but it will mean that if there is a slow processor in the computer then the reports and data retrieval will be slower. All in all the speed of the processor is just for a matter of convenience. Software To run and use the database you will need certain pieces of software. The main piece of software that will be needed will be Microsoft Access (at least the 1997 version). This is the program in which I am building my database and will be needed to run it. Another piece of software that will be needed to use this database will be is a printing program. This is not necessarily needed to run the database but will come in handy when a report is wanted to be printed out. Joe Luther 11 He Ict ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Marked by a teacher

    Information Retrieval tools. I have used a database to carry out my searches. ...

    3 star(s)

    One of the most outstanding tool of Emerald is to use the Boolean because it allows information to be looked at in different parts for example you can limit a search by clicking on the drop down list which provides a list of certain things which you can select to help you narrow down and broaden the information.

  2. ICT coursework: Designing and implementing a book rental system

    * At least 24Mb RAM * At least 161Mb of space * CD ROM drive Mr Dawson knows and told me that they could spend �999 on the new hardware and software. For Mr Dawson I would need to buy office 2000 Professional package, which has Access 97, which is �395.

  1. 20 years of the P. C. : Has software been held back by hardware ...

    This was new three dimensional computer game, with huge buyer appeal, it required an 80486 CPU as well as the latest graphics card at the time. Throughout the 90's software has become faster and faster at absorbing the latest CPU's facilities or graphics card's facilities.

  2. Home Office LTD company. Database

    This screenshot above shows how using a macro will not allow the user to enter a new client on to the database. One way of resolving this issue is that the user can type the data in the spreadsheet under the column headings and under the other customers.

  1. Designing a booking system for an Estate Agent.

    From the background and investigation their computers are networked and linked together by a central server. This means that this will stop data duplication. The database will be set up and stored in the central server and will each be individually configured in each work station.

  2. Background and investigation for designing a database for a DVD rental shop.

    be using the proposed system as much as his parents, the new system will be more tailored for Mr and Mrs Bradshaw's level of abilities. Jason obtains larger knowledge on using an ICT based system as he is currently a student and has to deal with computers on a daily basis.

  1. Uses of ICT in Varndean

    They also need the personal details of their customers such as their name, address and billing details so they know where to send the software. What hardware is used? The hardware that is used in finance at Varndean is a 17" flat panel monitor, a mouse, a keyboard and a

  2. Video World Database as ICT project.

    Because all the data is kept in files you must continuously check if people are not bringing data back. Obviously this can be very time consuming and errors are likely to be made, resulting in lost videos, lost assets and revenue.

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