• 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. Organising the database at Costsloadsless.

    Over due loans This is very important to have just in case a worker forgets to look up a customer or forget to check if all the DVD'S are back Set up a query to search for all members that have overdue videos/DVD.

  2. GCSE Database Project ICT

    The user needs to search for specific patient's details to be able to add, edit or delete the information for the one record and to be able to search the patient's details easily. 3. The user wishes to do a search for all children suitable and eligible for braces

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