• 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. 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. Home Office LTD company. Database

    Both the total cells have been named so that they can be used in the yearly review sheet, so that the totals automatically go to the yearly review sheet. The user gathers the information for each day by going to the customer database and filtering the order date.

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

    Currently task such as selected what dvds to send back isn't a reliable process as i use my own knowledge to choose dvds. I would like the system to automatically pick out the 25 least popular dvds in stock. I would also like to be able to print and display information on members, dvds and rentals.

  2. Video World Database as ICT project.

    He is very keen to have a solution implemented, which makes use of the applications within Microsoft Office. His initial ideas were centred on the use of Excel and Word, with which he is very familiar, although he is willing to learn how to use Microsoft Access.

  1. ICT Security Report

    DoS attacks are a registered computer crime that violates the Internet proper use policy as indicated by the Internet Architecture Board (IAB). They are said to have two general forms: * Force the victim computer(s) to reset or consume its resources such that it can no longer provide its intended service.

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    Goldenberg (2002) illustrates a scenario of the process change. A consumer goods company started with a CRM initiative. Creation and automation of the key-account management process is most the critical part of initiative. Instead of creating a proper key account management process using existing software, the company decided to choose CRM software vendors who incorporated a key-account management process.

  1. Beanie Project.

    records, and also takes a lot of time to sort out when there are changes to be made i.e. editing, adding, and deleting information on files: they would be done via a conventional typewriter or by hand, therefore causing a renewal of the record as apposed to simply a quick change in a computerised system field.

  2. ICT Solutions for people with Special Needs.

    Equal Opportunities policies (as mentioned above) - Conclusions Visually impaired Users I have decided to include Visually impaired users under the definition of disability, and therefore will be affected by the following legislation: Anti-discrimination laws which extend to the net UK legislation may help tackle discrimination against people with disabilities by web site designers.

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