<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: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:Consolas;
panose-1:2 11 6 9 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;}
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-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Hi Quentin,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Yes – quite correct. My
students spotted this as well. The x5 is not required.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Cheers,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Adrian<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'> <o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Adrian Janson, <o:p></o:p></span></b></p>
<p class=MsoNormal><b><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>VITTA President<o:p></o:p></span></b></p>
<p class=MsoNormal><b><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Director of ICT, <o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Melbourne High School, <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Forrest Hill, South Yarra 3141 Australia.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Phone: 03 9826 0711 International: +61 3 9826 0711<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Fax: 03 9826 8767 International: +61 3 9826 8767<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>E-mail: <a href="mailto:janson.adrian.a@edumail.vic.gov.au"><span
style='color:blue'>janson.adrian.a@edumail.vic.gov.au</span></a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Website: <a href="http://www.mhs.vic.edu.au"><span
style='color:blue'>http://www.mhs.vic.edu.au</span></a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;
color:#1F497D'>Blog: <a href="http://jansona.edublogs.org/"><span
style='color:blue'>http://jansona.edublogs.org</span></a><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='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 style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
sofdev-bounces@edulists.com.au [mailto:sofdev-bounces@edulists.com.au] <b>On
Behalf Of </b>Quentin Lydall<br>
<b>Sent:</b> Tuesday, 14 October 2008 10:01 AM<br>
<b>To:</b> Year 12 Software Development Teachers' Mailing List<br>
<b>Subject:</b> [Year 12 SofDev] Database question<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<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 style='margin-bottom:12.0pt'>The solution gives D with the
explanation <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 style='margin-bottom:12.0pt'><span style='font-size:11.5pt'>328
<br>
328 x 20000 x 5 = 32,800,000 <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><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 class=MsoNormal align=center style='text-align:center'><span
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 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
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><span 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>IT Software
Development Mailing List kindly supported by <br>
<a href="http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20">http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.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>