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

Computing: Database example.

Extracts from this document...

Introduction

Computing: Database example. A computer database is needed for a company to hold its customer details on. The data held will be: * Name of Company * Address (line 1) * Address (line 2) * Town * Post Code * Telephone Number * Contact name within Company * Date of last salesman visit * Amount owing at this time * Value or total amount of orders last year * Discount applied (if any - 5, 10 or 20%) The company has 2000 customers of this type. Data Types Field Type Reason Name of Company Text This data will be text as it is the name of a company. Address Line 1 Text This data will be text as it is the first line of an address. ...read more.

Middle

Integer This value will be either 5, or 10 or 20 and these vales are integer. Therefore only a integer field is required. Data Sizes Field Length Size (bytes) Reason Name of Company 20 21 bytes (1 byte for each character + 1 housekeeping byte) This length seems a reasonable length for the name of a company. Address Line 1 30 31 bytes (1 byte for each character + 1 housekeeping byte) This length seems a reasonable length for the first line of an address. Address Line 2 30 31 bytes (1 byte for each character + 1 housekeeping byte) This length seems a reasonable length for the second line of an address. Town 20 21 bytes (1 byte for each character + 1 housekeeping byte) ...read more.

Conclusion

Value or total amount of orders last year -922337203685477.5808 <-> +922337203685477.5807 8 bytes (7 Mantissa + 1 Exponent) This range is reasonable for this field because monetary values can get very large in businesses. Discount applied (if any - 5, 10 or 20%) -127 <-> +128 1 byte The maximum value of this field will be 20 therefore the range of just one byte is required. Total Size Field Size (bytes) Name of Company 21 Address (line 1) 31 Address (line 2) 31 Town 21 Post Code 9 Telephone Number 19 Contact name within Company 31 Date of last salesman visit 2 Amount owing at this time 8 Value or total amount of orders last year 8 Discount applied (if any - 5, 10 or 20%) 1 Record Total 182 2000 Records 364,000 Plus 10% Safety Allowance 36,400 Final TOTAL 400,400 = 400.4KB Matt Webb 12B Computing AS Level ...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 Computer Science 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 Computer Science essays

  1. 140 Computing A-Level Revision Questions

    Explain the difference between a serial and a sequential file. For what use is a serial file organisation commonly used? 80. Describe the data structure known as a linked list and say how it may be implemented in programming. Suggest uses for this structure.

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    Table names: Customers: The customer's table will have the following fields: * Customer ID (this will be an auto number) * Contact first name (text form) * Contact last name (text form) * House number (numerical) * Street name (text form)

  1. AQA Computing CPT3 June 08 Peter's Petrol Pumps

    NEW PRICE PER LITRE This dialog will be shown when the user wishes to change the price per litre. It will allow the user to enter the new price in pence, which will then put onto the pump LCD and onto the console display.

  2. Basic Database Building

    Total Facilities - This is used for showing the total uses in general for all users of the sports facilities All the reports can be seen in the screen shots below; Data Dictionary Ricki Lambert 16 May 2008 Table: Facilities Page: 1 Properties DateCreated: 09/05/2008 10:10:02 DefaultView: Datasheet GUID: {guid

  1. AQA Computing CPT3

    Resource: http://en.wikipedia.org/wiki/ActionScript (29/04/08) Designing Phase This section will consist of the designing phase, this will include making a definition of data storage requirements (a data dictionary), a user interface design for console and petrol pumps, algorithms for the operation of the pump, console, the simulation of the seven segment LCD display, and production of daily totals.

  2. Spare Parts Database Project

    Self: How do you store data when someone comes? Mr. Wong; Well, while issuing the product, the reference number and the price are noted in the book. 11. Self: What happens when an account or an important document is lost?

  1. A2Z Travel UK Ltd A2Z Travel Uk Ltd Company Structure ...

    * Asan Fazal (Assistant Mechanic) - deals with daily maintenance of the coaches on a daily basis. * Sandeep Uppal (Health & Safety Manager) - Sandeep Uppal deals with health and safety issues within the company, and also liability issues whilst its coaches are in use by A2z Travel Uk Ltd * Julia Wilson (Health & Safety Co-ordinator)

  2. Setting up a database for a shop selling P.C.'s.

    Consequently electricity is used and the business has an increase in income. - Can support information in a very organised fashion e.g. in a table and can be easily read off preventing a mix up of data e.g. the component size and price.

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