• 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
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  • Level: GCSE
  • Subject: ICT
  • Word count: 2063

Database Project

Extracts from this document...


. INTRO PLAN I have decided to create these customer questions in order to be aware of what my database must tell me. My database must be created so it can take these questions and give answers. 1) Do you have a Diesel Nissan Primera for under �5000? 2) Do you have a new Citroen X Sara Picasso for under �20000? 3) Do you have a Mercedes Benz, under the price of �15000? 4) Do you have a White Smart Car for under �10000? 5) Do you have a brand new Toyota Avensis under �10000? 6) How much will you sell a Toyota for? 7) Do you have a Ferrari for under �25000? 8) Do you have a brand new Renault Scenic for up to �10000? A local car dealer and his assistant confirmed these questions that I have produced. I wrote several questions which he discussed through with me explaining questions he is regularly asked, according to that I made appropriate questions. To produce a data capture sheet I had to search for a list of confirmed field lists. The following were searched, before being confirmed: 1) Make 2) Model 3) Colour 4) Top Speed 5) Age 6) Doors 7) Ranking 8) Mileage 9) Petrol/Diesel 10) Prices 11) Registration Make Model Colour Body Type Number of owners Fuel Price After having confirmed the above by a local car dealer I produced my final attributes: Make Model Number of owners Colour Body Type Fuel Price Audi A6 0 Metallic Gold Saloon Diesel �13999 ...read more.


Here is a page from the auto trader magazine: This is a view of how I used the data efficiently in my database: Overall my research was evenly done between I.T and non-I.T sources. Attributes Data Type Size Format Validation rule Validation Text Make Text 10 Model Text 7 Colour Text 5 Is not null Must be filled in Number of owners Numbers 1 >0 AND <5 Body Type Text Fuel Text 6 Price Numbers 5 Currency Positive Price Cant enter negative price I choose text for the data type for the model of a car because it covers both numbers and text, which are required in ,many of the cars E.g. BMW 3Series As the validation for a car price I used computer language to ensure negative or any invalid data isn't accepted. I also ensured all the field sizes were big enough, and at the same time not too big. The reason for this user guide is to show step by step development of my database. I will describe certain things I did and give evidence by using print screens. 1) To start with I went into the Microsoft access package and opened a blank database, and then I named the database and gave it a file location. 2) Following this a screen appeared which gave me the following options: * Tables * Queries * Reports * Forms From these I choose to make a table. 3) Now I had to fill the table in with the appropriate headings and data. 4) ...read more.


Query Design- Query Results- 2) Customer Question-Do you have a Smart Car in White for under �10000? Query Design- Query Results- By making queries I can be search for data and also add data easily. To do my project I had to select a software, which would be most useful for me and my task. The software I choose was Microsoft Access because it consisted of the features I needed. Microsoft Access was useful to me because in order to create a database I needed something that could store/handle large amounts of data. Using Access I could also answer queries and within seconds show results. This is a search facility, which isn't available on other softwares such as Excel. Overall it also has a very user-friendly look. Comparison: I will make a comparison between Access and Excel for my given task. Access was more suitable for me because I could create a table and give it validation rules and checks. I would not be able to create validations on Excel. Access has also an additional feature than excel because it is able to locate specific queries in the data table. This is useful for update of data, which can be difficult in Excel. Overall I have come to realise that Access is more suitable for data handling and excel is more suitable for data modelling. For the project I was doing I needed to have appropriate attributes to show the data. I was able to select certain attributes, by their necessities. Following is a list of attributes some of which I have included and some not. ...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. GCSE Excel Project ICT

    Choice of output method justified The output method I have the preposition to use is the printed method, as it the most effective system as it prevents confusion between sold products, it also safeguards against errors as the customer takes the copy to Alex, which he then rings up to

  2. a level ict project

    Plus passwords can be put in place to restrict unauthorised access to sensitive areas. The system can be easily backed up using storage devices such as compact disks and flash memory sticks. Both storage mediums provide quick and effectual data transfer.

  1. Access Database

    And I achieved the objective. * To show the stock of the videos in the library I made the field name of stock of videos in the library, at first the field was missing but then I added the field name and achieved the objective.

  2. ICT - making a database of used cars.

    Have you got any cars that are diesel? 3. Which four door cars do you have? 4. Which cars do you have that are below �5,000? 5. Which cars do you have that have done less than 7,000 miles? 6. Can you show me a list of black cars?

  1. Financial Model to help organise the year eleven prom

    of tickets or the "raw data" sheet to add or view the decorations, catering, music. After I had done this I decided to make the whole program automatic, so on the user input screen I added the choice of returning to the welcome screen or to moving on to the "Raw Data" screen.

  2. GCSE Calculator Project

    Inputs These are the digits, e.g.123. There are also operations e.g. +, - etc. I can fit in enough numbers to hold 1-9. There are all in the form of button clicks. First of all, the user will type in the numbers that they will use to do the calculations and also pick a function, e.g.

  1. GCSE Book DataBase Project

    It takes so long to find some ones file if your filing cabinet is not filed properly. Paper documents take up a lot of room up. You have no back up. You can't share the records because you only have one copy.

  2. Organising the database at Costsloadsless.

    Writing the system on paper This system would be on paper in a folder this would hold all information from DVD/ video information to the customer information. The video/ DVD information would all be set up in the front of the folder all organised from love DVD's to action set

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