[Year 12 SofDev] Database question
Quentin Lydall
qly at beaconhills.vic.edu.au
Tue Oct 14 09:01:03 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/sofdev/attachments/20081014/95eabdd1/attachment.html
More information about the sofdev
mailing list