<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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Franklin Gothic Medium";
panose-1:2 11 6 3 2 1 2 2 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* 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;}
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;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:12.0pt;color:#1F497D'>Agree.
Question needed to specify that backups or archives needed to be stored
annually and retained on the hard drive.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;color:#1F497D'>Just drop the
x5<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>====================================================<br>
Stephen Digby, Learning Technology Manager<br>
mailto: </span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:#1F497D'><a href="mailto:digby.stephen.p@edumail.vic.gov.au"><span
style='font-family:"Arial","sans-serif"'>digby.stephen.p@edumail.vic.gov.au</span></a></span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'> <br>
Cheltenham Secondary College </span><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:#1F497D'><a href="http://www.cheltsec.vic.edu.au"><span
style='font-family:"Arial","sans-serif"'>www.cheltsec.vic.edu.au</span></a><br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Ph: 613 955 55 955 Fx: 9555 8617 Mb: 0431-701-028<br>
====================================================</span><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D'><br>
Brain cells come and brain cells go, but fat cells live forever. Steven Wright </span><span
style='font-size:12.0pt;color:#1F497D'><o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Quentin Lydall<br>
<b>Sent:</b> Tuesday, 14 October 2008 9:53 AM<br>
<b>To:</b> itapps@edulists.com.au<br>
<b>Subject:</b> [Year 12 IT Apps] Database size question<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US>Hello everyone,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>The VITTA 2008 trial exam 3 has this
question in the multiple-choice section:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=Default><b><span lang=EN-US style='font-size:11.5pt'>Question 7 </span></b><span
lang=EN-US 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 lang=EN-US style='font-size:11.5pt'><o:p> </o:p></span></p>
<p class=Default><b><span lang=EN-US style='font-size:11.5pt'>A. </span></b><span
lang=EN-US style='font-size:11.5pt'>34,200,000 bytes <o:p></o:p></span></p>
<p class=Default><span lang=EN-US style='font-size:11.5pt'><o:p> </o:p></span></p>
<p class=Default><b><span lang=EN-US style='font-size:11.5pt'>B. </span></b><span
lang=EN-US style='font-size:11.5pt'>32,400,000 bytes <o:p></o:p></span></p>
<p class=Default><span lang=EN-US style='font-size:11.5pt'><o:p> </o:p></span></p>
<p class=Default><b><span lang=EN-US style='font-size:11.5pt'>C. </span></b><span
lang=EN-US style='font-size:11.5pt'>35,600,000 bytes <o:p></o:p></span></p>
<p class=Default><span lang=EN-US style='font-size:11.5pt'><o:p> </o:p></span></p>
<p class=Default><b><span lang=EN-US style='font-size:11.5pt'>D. </span></b><span
lang=EN-US style='font-size:11.5pt'>32,800,000 bytes <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=Default><span lang=EN-US>The solution gives D with the explanation <o:p></o:p></span></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 =
328 328 x 20000 x 5 = 32,800,000 <o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN-US>Why multiply by 5? Would the company
recreate the entire records each year? I’d design it differently..<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Appreciate your help.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Franklin Gothic Medium","sans-serif";
color:#365F91'>Quentin Lydall<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#365F91'>Head of ICT<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#365F91'>Beaconhills College
Valley Campus<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#365F91'>30-34 Toomuc
Valley Road,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#365F91'>Pakenham<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#365F91'>3810<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;color:#365F91'>Phone:
1300 002 225 Extn 3016<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:18.0pt;font-family:Webdings;
color:green'>P</span><i><span lang=EN-US style='color:navy'> </span></i><i><span
lang=EN-US style='color:green'>Please consider the environment before printing
my email</span></i><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-US
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif"'>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%20">Beaconhills College</a> by
telephone on (+61 3) <strong>1300 002 225</strong>.<o:p></o:p></span></p>
</div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-US
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></p>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.</p>
</body>
</html>