• 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
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 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...

Introduction

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.

Middle

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.

Conclusion

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)

    It basically focuses on information as a resource. Information management and knowledge management is being applied around the world due to the amount of information that is available around us. Search Engines A search engine is a program that searches documents for specified keywords and returns a list of the documents where the keywords were found.

  2. Designing a booking system for an Estate Agent.

    Problems such as do such as double booking, lost of information, unorganised timetable system will be considered and addressed when creating the proposed system. However, although the new proposed system is designed to be better and to eliminate the existing problems that the current system have, it will still have constraints internally and externally within the organisation.

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

  2. Database Design

    not Shipped date Number The date the item was despatched to the customer 00/00/0000;0;_ Product Table: Attribute name Data type Size Validation rule Description Product ID Number 3 Cannot exceed 3 characters ID number of the product Product name Text 30 Cannot exceed 30 characters Name of the product Product

  1. The purpose of this document is to provide a design for an electronic payment ...

    As the card processing is dealt with outside the scope of this project, references will only be made to the SecPay system and no details of that systems design will be included in this document. Image delivery will also not be covered within the scope of this document.

  2. I have been asked by a General Sports shop using a manual system to ...

    1 �2.62 �17.61 Software Database Access Microsoft �125.00 1 �21.88 �146.88 Operating system Xp office edition Microsoft �259.99 1 �45.50 �305.49 Virus remover Virus Scan McAfee �24.99 1 �4.37 �29.36 Additional Costs Mouse Mat Microsoft �3.50 1 �0.61 �4.11 Total System Cost = �3,278.64 In this table there is everything you will need to get the database up and running.

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

    to provide an ICT based solution and he will be providing me with all the information I require to design and make the proposed system. Users Ashley Bradshaw devotes most of his time to the running of the shop and this deems him the main user.

  2. Evalution of my database

    I knew what flow diagrams were and how to use them to show information also I already knew how to create a table of data through the software called Microsoft access. I had some basic skills on how security works and the different types of threats there is and how

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