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

Estimating the size of a database

Extracts from this document...

Introduction

Estimating the size of a database A computer database is needed by a company to hold customer details on. The data held will be: > Name of company > Address (Line 1) > Address (Line 2) > Town > Postcode > Telephone number > Contact name within the 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 customer records of this type. Data types Name of company This data will be characters. It must be of data type text as it is the name of a company. ...read more.

Middle

Contact name within the company This data will be characters. It must be of data type text as it is a name. Date of last salesman visit This data will be of data type date as it will be a date of the last visit from a salesman. Amount owing at this time This data will be of data type currency as money is held as currency, which is a real value. Value or total amount of orders last year This data will be of data type currency as money is held as currency, which is a real value. Discount applied (if any = 5,10 or 20%) This data will be either 5,10 or 20 and these values are integer. ...read more.

Conclusion

0 Data sizes Field Length of field Size of field Reason Name of company 25 26 bytes Address (Line 1) 25 26 bytes Address (Line 2) 25 26 bytes Town 20 21 bytes Postcode 8 9 bytes Telephone number 16 17 bytes Contact name within the company 25 26 bytes Date of last salesman visit -32767<->+32768 2 bytes Amount owing at this time 8 bytes Value or total amount of orders last year 8 bytes Discount applied (if any = 5,10 or 20%) 1 byte Summary of size Field Size (in bytes) Name of company Address (line 1) Address (line 2) Town Postcode Telephone number Contact name within the 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%) ?? ?? ?? ?? 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 GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. ICT - APPLIED - Database on quesitonnaire

    Some main search engines used in the WWW: * Google * Yahoo * MSN Live Search * Ask * AltaVista * Rediff * Recruit * YouTube * TorrentSpy Firstly, I will show use of similar searching through a variety of search engines available to the users of the internet.

  2. GCSE Database Project ICT

    The receptionist and the Dentist can either have synchronised computers or have computers on a network. When the receptionist has to send reminder letters multiple criteria can be used to search and manipulate data. After she has found the results of the search she then can connect to Microsoft Word

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