<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:"Franklin Gothic Medium";
panose-1:2 11 6 3 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
p.Default, li.Default, div.Default
{mso-style-name:Default;
margin:0cm;
margin-bottom:.0001pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hello everyone,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>The VITTA 2008 trial exam 3 has this question in the
multiple-choice section:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=Default><b><span style='font-size:11.5pt'>Question 7 <o:p></o:p></span></b></p>
<p class=Default><span style='font-size:11.5pt'>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: <br>
First Name – 50 characters <br>
Last Name – 50 characters <br>
Address – 100 characters <br>
Suburb – 50 characters <br>
Phone number – 10 characters each (2 phone numbers per customer) <br>
Email address – 50 characters <br>
Postcode – 4 characters <br>
Number of coupons received – 32-bit number <o:p></o:p></span></p>
<p class=Default><span style='font-size:11.5pt'><o:p> </o:p></span></p>
<p class=Default><b><span style='font-size:11.5pt'>A. </span></b><span
style='font-size:11.5pt'>34,200,000 bytes <o:p></o:p></span></p>
<p class=Default><b><span style='font-size:11.5pt'>B. </span></b><span
style='font-size:11.5pt'>32,400,000 bytes <o:p></o:p></span></p>
<p class=Default><b><span style='font-size:11.5pt'>C. </span></b><span
style='font-size:11.5pt'>35,600,000 bytes <o:p></o:p></span></p>
<p class=Default><b><span style='font-size:11.5pt'>D. </span></b><span
style='font-size:11.5pt'>32,800,000 bytes <o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=Default>The solution gives D with the explanation <br>
<br>
<o:p></o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:38.5pt'>
<td width=249 valign=top style='width:186.7pt;padding:0cm 5.4pt 0cm 5.4pt;
height:38.5pt'>
<p class=Default><span style='font-size:11.5pt'>50+50+100+50+10+10+50+4+4 = <o:p></o:p></span></p>
<p class=Default><span style='font-size:11.5pt'>328 <br>
328 x 20000 x 5 = 32,800,000 <br>
<br>
<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal>Why multiply by 5? Would the company recreate the
entire records each year? I’d design it differently..<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Appreciate your help.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-family:"Franklin Gothic Medium","sans-serif";
color:#365F91'>Quentin Lydall<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#365F91'>Head of ICT<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#365F91'>Beaconhills College Valley
Campus<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:8.0pt;color:#365F91'>30-34
Toomuc Valley Road,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:8.0pt;color:#365F91'>Pakenham<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:8.0pt;color:#365F91'>3810<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#365F91'>Phone: 1300 002
225 Extn 3016<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:18.0pt;font-family:Webdings;
color:green'>P</span><i><span style='color:navy'> </span></i><i><span
style='color:green'>Please consider the environment before printing my email</span></i><span
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<HR>
<DIV>This email is confidential and intended solely for the use of the
<BR>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 <A
href="http://www.beaconhills.vic.edu.au ">Beaconhills College</A> by telephone
on (+61 3) <STRONG>1300 002 225</STRONG>.<BR></DIV>
<DIV></DIV>
<HR>
</body>
</html>