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

Database Project

Extracts from this document...

Introduction

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

Middle

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.

Conclusion

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. ICT PROJECT

    She is an average user, which means she does not understand most of the advanced features. Such as Vlookup, IF Statement, Macros, etc. Project Constraints Ms Gammon uses school standard PC that I will be using to calculate percentages and grades for the new system.

  2. GCSE Calculator Project

    Perform the basic arithmetic functions (of add, multiply, subtract and divide). 2. The font size should be big for people with peer eye sight. 3. The difference between the foreground and background colour should make it easy for the user to read.

  1. Designing a Car Mechanic's Database

    Autonumber Primary Key Surname Text Field Length: 25 Forename Text Field Length: 15 Telephone Number Long Integer Address Text Field Length: 50 Town Text Field Length: 30 Postcode Text Field Length: 7 Car Make Text Field Length: 35 Car Model Text Field Length: 50 Previous Problems Text Field Length: 40

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

    RENTED YES MESSAGE COMES UP EXISTING LOANS FIND RECORD YES MESSAGE BOX COMES UP EXISTING LOANS MAIN MENU YES FROM TO WORKED RUN QUERY MEMBER QUERY YES MESSAGE BOXES FOR QUERY PARAMETER COMES UP. RUN QUERY DVD QUERY YES MESSAGE BOXES FOR QUERY PARAMETER COMES UP.

  1. Computer project Alevels

    The first thing that appears that appears when you open the system is the Login form which requires the password and the username. These two key information is given below. Password : Medicare The password is not sensitive to any capital and simple letters used in the wrong place.

  2. GCSE Database Project ICT

    After each session, the dentist writes in the top left corner what date the patient should return, as the patient visits more times the corner looks very scruffy. Another problem the secretary faces is when appointment renewals have to be made.

  1. GCSE Excel Project ICT

    In addition, a questionnaire-style form could be given to the customers, of which only one would be made (and photocopied), then they fill in the order and give it to him where he can total the price and charge accordingly.

  2. ICT - making a database of used cars.

    Overall, a database will help the business be more organized, have easy access to information and be more productive. Queries Another helpful tool that Access database has is the query tool. With this tool, you can search for anything in the database easily without spending a lot of time searching through records.

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