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

Design a database to be used by a second hand car dealer to keep electronic records of the cars he has in stock.

Extracts from this document...


Task: Design a database to be used by a second hand car dealer to keep electronic records of the cars he has in stock. Analysis The Analysis Section is worth 9 marks. It is broken down into three sections, with each section worth 3 marks. Identify a Problem What is meant by a problem? It is very important that you understand what is meant by a problem - the project hinges on a good understanding of the problem and the solution. There are 3 marks for this part. A problem is a task that cannot currently be done, or a task that takes a long time and is difficult to do. For example, searching for cars that fit a certain requirement, such any car costing less than �3000 or all cars with electronic windows and central locking, can be done using paper-based card index files. However, it is awkward and very time consuming (particularly if you have hundreds of cars) so it is a problem and can be solved using a computer (in this instance by having a database of cars). The problem does not have to be complex - it can be very simple. The identification of the problem has four parts * Problem: * Why is it a problem: * Solution: * Software used: Problem: This is a simple statement of the problem. ...read more.


Inputs are most likely to be pieces of information. For example, with a second hand car dealership, the inputs will be all the information about a car. Outputs These are what comes out of the system - it could be letters, reports, graphs, etc. The outputs will be specific information. For example, in the second hand car dealership, one of the outputs will be information for customers about specific vehicles they are interested in. Processing This is what happens - actions within the system. For example, searching to find a vehicle costing less than �5000 would be - go to the filing cabinet find the all the record cards. Start with the first record and go through each record individually finding all those that cost less than �5000. Take them out of the records, photocopy the details and then put them back in their correct order in the filing cabinet The processing is searching and sorting System Specification For the final marks in this section you need to look at system specifications. A systems specification is a list of hardware and software that you will use to solve the problem. You do not need to mention specific details (such as software names) - general types of software is all that is required. ...read more.


Although the two are separated below, at the bottom of this section there is an indication of how you can put the two together. Describe their Testing/Results Together It is possible to put the two testing sections together and to look at the as a single task. Use the Test Plan in the VDrive as a guide and complete at least 8 tests of your data. This should include a sort, 5 searches and 2 validation rules tests. Evaluation This is the final section. There are 3 marks for the evaluation. At the beginning of the project you set a problem. This is the point where you go back and see what you have done to solve the problem. You need to list the problem and the user requirements (what you need to do to solve the problem) and against each one write a description of whether you have completed it or not and give some evidence (screenshots) to show that you have done it. In the design section, you designed the data structure and user interface. You need to compare what you designed with what you created and write a paragraph saying if you achieved what you designed. Some screenshots may help. In addition for the final marks you describe what your system could not do and what you could do to put it right. Total marks available 31. V:\ICT\KS4\Coursework\2 Data handling\Project 2.doc Project Work: OCR ICT GCSE Page: 2 V:\ICT\KS4\Coursework\2 Data handling\Project 2.doc ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    They also have basis features such as changing the colour and font of text, inserting word art and clip art, making tables, inserting shapes and having a spelling and grammar checker. A mail merge is useful for writing letters or invitations to people.

  2. Hardware & Software Requirements for Database

    The performance affect the way my data base works because then I would know how much memory my database will use and need. I can compress my database to be able to hold more data information according to the needs of hospital hard drives but I need to make sure


    The user will be able to add new student using a user form and also be able to edit or delete student details if the student move from her class using a data form. The macro to add new students will open up a user form to allow easy input of data.

  2. GCSE Excel Project ICT

    'Customer' View Sheet 5 Black and White Formula View There are not any formulae on this page, so there will be no reason to show it. 'Customer' View Sheet 7 Black and White Formula View 'Customer' View Printout Report Evidence that each test in the test plan was carried out

  1. Database Design Guideline

    a computer system in accordance with predefined rules'' I will be using a validation rules in my database for my doctors and patients table, I will create a validation rule under the field of ward. My validation rule is in colours ("Red" Or "Blue" Or "Orange" Or "Green").

  2. ICT Coursework (MarcoS)

    type of the project chosen is displayed 56 Formula in cell F7 in the Order sheet The No of bedrooms of the project chosen is displayed 57 Formula in cell F7 in the Order sheet The No of floor of the project chosen is displayed 58 Formula in the cell

  1. Database design.

    The user and application program interface to a relational database is the structured query language. SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports. In addition to being relatively easy to create and access, a relational database has the important advantage of being easy to extend.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    (50% surcharge of the original price, it could either be daily or as the total without counting how many days the DVD was late) BOLD = POSSIBLE ENTITIES ADVANTAGES OF COMPUTER BASED SYSTEM There are many advantages of using a computerized system for Moving Images they are: The files can

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