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

Use of a database to record information on Mercedes-Benz S-Classes bought from a Mercedes-Benz showroom.

Extracts from this document...


Analysis User Requirements I am going to use a database to record information on Mercedes-Benz S-Classes bought from a Mercedes-Benz showroom. The staff and manager in the showroom will use the database. They will get all the latest information on available cars. Data Needed I will need to know all the different model types of Mercedes-Benz S-Class, which will go on our first database. Details on the customers who purchase Mercedes-Benz S-Classes from us will be put in our second database. Customer details will be taken as Mercedes-Benz S-Classes are expensive cars and theft risks cannot be taken. There will be another table for sales details incase anyone chooses to buy more than one car. The fields that will be covered in my database are model, short wheel base price, long wheel price, max power, max torque, Acceleration, max speed, fuel consumption, colour, optional extra's, registration number, surname, first name, address, post code, telephone number, customer ID, account name, card number, sort code, valid from, expires in, monthly instalment. ...read more.


Number Integer Yes Max Speed Number Integer Yes Fuel Consumption (MPG) Number Integer Yes Colour Text 12 Yes Optional Extra's Text 20 Yes Registration number Text 12 Yes Yes X Table 2: Customer Details Surname Text 20 Yes First Name Text 20 Yes Address Text 30 Yes Post Code Text 10 Yes Registration Number Text 12 Yes Telephone Number Number Long Integer Yes Customer ID Auto number Yes Yes Account Name Text 20 No Credit Card Number Number Long Integer No Sort Code Number Integer No Valid From Date/Time No Expires In Date/Time No Monthly Instalment Paid Number Integer No Table 3: Sales ID Sales ID Auto Number Yes Yes Customer ID Auto Number Yes Surname Text 20 Yes First Name Text 20 Yes Date Date/Time Yes My primary keys are registration number in my first table, customer ID in my second table and sales ID in my third. These are my primary keys as they all have individual properties. The relationships I am going to be using are registration number with a one-to-many relation, and customer ID to a one-to-many relation. ...read more.


I inserted all the fields that were needed. Next, I put the fields in the order I wanted them. Next I chose the format, layout, and style I wanted. Then I clicked 'Finished'. My work has been kept safe and accurate as it has been backed up and has passwords protecting it. It also has the attribute of 'Read-Only' when I am not using my database. Here are some screenshots of backups taken. Evaluation My user requirements did not exactly meet my final product as I tried different ways of improving my product requiring me to keep on updating my user requirements. I have made changes to my product to try and make it more user-friendly and efficient to use. I believe I could improve my product if I had more time to do it and better resources. I believe I could make it more presentable and professional so it would be more appealing to a customer. I would also be able to improve the efficiency of my project and make even simpler to use. I would be able to protect my project better by being able to use more powerful protecting programs. Saeed Sattar 10H Candidate No. 0226 Centre No: 52303 GNVQ: Database Project ...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)

    To avoid misleading information, I will talk about information retrieval tools and will explain in depth of what Information science is and how the ideas from information science are being applied in the world. Information management means gathering information and managing information. It basically focuses on information as a resource.

  2. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    It has hardware: TV sets, PCs and game machines. What Sony lacks is a communications tool, and that's where the PSX 2 is to come in. It is one the three Internet gateway strategies, as Sony believes that its future lies not with its TVs and camcorders, but with the fast moving on-line world.

  1. Database Design

    I then had to select which form I would like the command button to open For the Customer Details button, I selected the 'Customer' form. Then after clicking Next it took me to this next window which I clicked on 'Open the form and show all the records.'

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

    will simply store a record of when the purchase was made, how much is was for and what was purchased. The record will be stored in a central table along with the user ID of the user who made the purchase.

  1. An analytical report to discuss the HEG Infoway project, its implementation and the reasons ...

    Brooks (1) attributes the exponential rise in costs to the cost of communication. Changes to software include new features, bug fixes and scaling. The effects of exponential cost of production can be characterized by three properties. First, new projects are successful because the cost curve is flat.

  2. I was hired by Mr Davies to create a website for a newly built ...

    Have the company's logo on the website. * Photo Scan pictures and insert in computer Crop pictures to right size. Insert into html. Have pictures on the website. * Text Hyperlinks to each page. Type in all the pages names.

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

    Bad Handwriting The current system stores all details on paper forms that are arranged in separate files. Due to the different writing styles of the staff and the haste with which employees sometimes write the data on to paper, the data tends to become hard to read.

  2. ICT Security Report

    who use it for fraudulent and theft purposes in order to gain something out of it and in this instance nearly $4 million. Viruses and Trojans A virus is a computer program that is able to copy itself and infect a user's computer without the user's permission.

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