[Year 12 IT Apps] Database size question

Quentin Lydall qly at beaconhills.vic.edu.au
Tue Oct 14 08:52:31 EST 2008


Hello everyone,

 

The VITTA 2008 trial exam 3 has this question in the multiple-choice
section:

 

Question 7 A database for an online marketing company keeps records of
all customers who have requested coupons and notifications of sales in
their local area. They currently have a dedicated customer base of
around 5000 customers, but wish to grow this to 20,000 customers within
the next 5 years. How much storage capacity will be required to store
20,000 customer records for the entire 5 year period, given the
following information: 
First Name - 50 characters 
Last Name - 50 characters 
Address - 100 characters 
Suburb - 50 characters 
Phone number - 10 characters each (2 phone numbers per customer) 
Email address - 50 characters 
Postcode - 4 characters 
Number of coupons received - 32-bit number 

 

A. 34,200,000 bytes 

 

B. 32,400,000 bytes 

 

C. 35,600,000 bytes 

 

D. 32,800,000 bytes 

 

The solution gives D with the explanation 

50+50+100+50+10+10+50+4+4 = 328 328 x 20000 x 5 = 32,800,000 

Why multiply by 5?  Would the company recreate the entire records each
year?  I'd design it differently..

 

Appreciate your help.

 

Quentin Lydall

Head of ICT

Beaconhills College Valley Campus

30-34 Toomuc Valley Road,

Pakenham

3810

Phone: 1300 002 225 Extn 3016

P Please consider the environment before printing my email

 


#####################################################################################
This email is confidential and intended solely for the use of the individual to whom 
it is addressed. Any views or opinions presented are solely those of the author and 
do not necessarily represent those of Beaconhills College. If you are not the 
intended recipient, be advised that you have received this email in error and that 
any use, dissemination, forwarding, printing, or copying of this email is strictly 
prohibited.
If you have received this email in error please notify Beaconhills College 
by telephone on (+61 3)  1300 002 225.
#####################################################################################
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20081014/cc490f60/attachment.html


More information about the itapps mailing list