[Year 12 SofDev] Database question

Tue Oct 14 10:13:48 EST 2008

Hi Quentin,

Yes - quite correct.  My students spotted this as well.  The x5 is not
required.

Cheers,

Adrian

Adrian Janson, 

VITTA President

Director of ICT, 

Melbourne High School, 

Forrest Hill, South Yarra 3141 Australia.

Phone: 03 9826 0711 International: +61 3 9826 0711

Fax: 03 9826 8767 International: +61 3 9826 8767

E-mail:  <mailto:janson.adrian.a at edumail.vic.gov.au>
janson.adrian.a at edumail.vic.gov.au

Website:  <http://www.mhs.vic.edu.au> http://www.mhs.vic.edu.au

Blog:  <http://jansona.edublogs.org/> http://jansona.edublogs.org

From: sofdev-bounces at edulists.com.au [mailto:sofdev-bounces at edulists.com.au]
On Behalf Of Quentin Lydall
Sent: Tuesday, 14 October 2008 10:01 AM
To: Year 12 Software Development Teachers' Mailing List
Subject: [Year 12 SofDev] Database question

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
<http://www.beaconhills.vic.edu.au%20>  College by telephone on (+61 3)
1300 002 225.

  _____  

_______________________________________________ 
http://www.edulists.com.au  <http://www.edulists.com.au> IT Software
Development Mailing List kindly supported by 
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html
<http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20>
- Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au  <http://www.vitta.org.au> - VITTA Victorian
Information Technology Teachers Association Inc

Important - 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/sofdev/attachments/20081014/c6866568/attachment.html