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

Introduction

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.

Middle

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.

Conclusion

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

    The Internet is an important part of our everyday lives however it is not ...

    4 star(s)

    People want to find their information as soon as possible, and so they skim the surface not really taking the time to absorb or think about what they are reading. The youth especially struggle to keep their attention focused long enough to read an article or even a book.

  2. Marked by a teacher

    Information Retrieval tools. I have used a database to carry out my searches. ...

    3 star(s)

    An example would be Google. I strongly believe that Google as a search engine is one of the most effective tools to use as it offers incredible sources of information. The strength of Google is the amount of information they have, which is more than 8 billion URL's.

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

  2. Database Design

    I named it 'Customer Details', then clicked Finish and the button was created. I did the same thing for every button, linking them to their appropriate page. This is how the Main Menu looked when it was finished Queries Once I had finished my forms, I went on to do my Query's.

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

    4.2 Process Interface The following screenshots are prototypes of what the system will look like when implemented. The screens are divided into three sections, each with a separate colour scheme to make it easier for people with vision difficulties to view the page.

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

    Use forms for all data entry 4.3 Reduce the use's options so that they have to use the buttons and supply plain forms Outcome 5: To be able to extract data. 5.1. The total value of proposals sent out this month, sorted into ascending order on the total price of each proposal.

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

    Interview Questions and answers 1. How many personnel are currently in your employ? We have three members of staff. Two work on a full time basis and one works part-time. 2. What details do you hold about your employees? As all employees are family members not much information is kept

  2. ICT Security Report

    On February 7th 2000 a hacker named 'Mafia boy' shut down the Yahoo website for 3 hours. This was the start of a wave of DoS attacks and continued on February 8th when Amazon, Buy.com, EBay and CNN.com were also shut down, and the following day, February 9th E*Trade and ZDNet were also shut down.

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