• 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

    0110 0011 ii) 1001 1001 iii) 1100 0111 68. Convert these binary numbers to hexadecimal i) 1000 0110 ii) 1001 1100 iii) 1111 1110 0111 0000 69. Explain, with examples how numbers are represented in twos complement. 70. Explain normalisation of floating point numbers and why it is used. 71. A computer uses a 12-bit word.

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

    The only thing I could do is try my hardest to fix each problem as it arises but keeping on top of all of them would prove hard. Perfective maintenance: This type of system maintenance is also ongoing there are many things with in the project which could be done just the little bit better.

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

    STRUCTURE CHART PSEUDOCODE ALGORITHMS PUMP OPERATION Event: Clicking Remove / Replace Nozzle Button If Button says Remove then Button says Replace On Console Zero Dispensed Button is enabled If Button says Replace then Button says Remove Button Squeeze is disabled On Console Pump is marked out of use Petrol Dispensed,

  2. Basic Database Building

    False IMEMode: 0 IMESentenceMode: 3 OrdinalPosition: 3 Required: False SourceField: Last time visited SourceTable: Facilities Currently using Yes/No 1 AllowZeroLength: False Attributes: Fixed Size CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: 106 Format: Yes/No OrdinalPosition: 4 Required: False SourceField: Currently using SourceTable: Facilities Relationships FacilitiesFacilityUses Facilities

  1. AQA Computing CPT3

    Data Dictionary A data dictionary is a collection of descriptions of the data objects, or items in a system for a data model. Below I have identified the data types required for my petrol pump Name Type Validation Example Notes amountOfFuel Number 0 - 99.99 52.34 This will store the

  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