• 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

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

    3 star(s)

    Functionality Emerald has many functions, which helps users to locate and narrow down the search making it easier for them to find what they are looking for. The functions allow us to break down information and to keep the information simple.

  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. I was hired by Mr Davies to create a website for a newly built ...

    * End-use testing - getting the end user to test the system for a day. Done by the end user to detect any errors/problems and to establish whether the system meets the user requirements Testing plan Test Number What to test How to test it Expected Outcome 1 Test switchboard

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

    working environment being observed is as close to a naturalistic situation as possible. Things that I hope to observe include: * The work load on the employees * If there are any unnecessary delays between the performance of various processes * The methods of working * The nature of the

  1. ICT Security Report

    clips, using your precious network resources and impacting network performance for your legitimate users. There a many security measures that could be taken in order to try and obtain a safer and secure wireless network. This can either be done be introducing a LAN segmentation, it is used by many

  2. Database Design

    The primary key that I made on the Order table is the Order ID because it is unique with every order. Supplier with Product: Here the relationship between Supplier and Product is one-to-many. This is because one supplier can supply more than one product to a customer.

  1. In the U.K there has been a major push for the introduction of national ...

    Once the biometric identifier is taken up by the biometric system the signal is translated into a "feature vector". The "feature vector" contains essential characteristics as to the uniqueness of the biometric pattern and is used to match against future patterns or identities that are checked against the systems.

  2. Home Office LTD company. Database

    Along with the code, there is a description of the product, the price and the quantity remaining. The sheet allows the user to keep track of what products the company sell, as all of the products available would be listed.

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