[Year 12 IPM] Exam Short Answer Question 2

[Murray O.]

Regards,

Oliver Murray

Web Developer

Westbourne Grammar School

www.westbournegrammar.com

  _____  

From: Lel, Ronald A [mailto:lel.ronald.a at edumail.vic.gov.au] 
Sent: Thursday, 17 November 2005 12:39 PM
To: Year 12 Information Technology Processing and Management
Teachers'Mailing List
Subject: RE: [Year 12 IPM] Exam Short Answer Question 2

 

 

-----Original Message-----
From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au] On
Behalf Of Murray O.
Sent: Thursday, 17 November 2005 12:28 PM
To: Year 12 Information Technology Processing and Management
Teachers'Mailing List
Subject: [Year 12 IPM] Exam Short Answer Question 2

Hi all

Just a question re SA Q2:

If my memory serves me well ;-), Mark's solution stated

"Split the name field and sort alphabetically" ... is this any more
efficient than just sorting the customer field alphabetically and matching
first name then surname etc...

 

Also how will splitting the address field or having a standard phone field
make looking up customer details more efficient? 

 

Regards,

Oliver Murray

Web Developer

Westbourne Grammar School

www.westbournegrammar.com <http://www.westbournegrammar.com>  

 

Hello Oliver,

 

Splitting the address field in a database allows you to search for
particular suburbs far more efficiently, (eg how many customers do I have in
Balwyn?) It also allows indexing on these fields to speed searching.

 

I don't understand your question re names. Are you suggesting sorting the
custId field? Mark's solution allows a far more efficient and elegant way of
using your db as a source for mail merges?

 

Ron Lel 

 

Thanks Ron

I made 2 assumptions

1. "wanting to look up customer details" meant find a customer and 

2. an electronic file could be from a database, spreadsheet, word processing
etc...

 

BTW I agree with your answer re atomic attributes (1NF)

 

Oliver Murray

*******************************************

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 &
Training._______________________________________________ 
http://www.edulists.com.au  <http://www.edulists.com.au> - FAQ, resources,
subscribe, unsubscribe 
IPM Mailing List kindly supported by 
http://www.vcaa.vic.edu.au  <http://www.vcaa.vic.edu.au> - Victorian
Curriculum and Assessment Authority and 
http://www.vitta.org.au  <http://www.vitta.org.au> - VITTA Victorian
Information Technology Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/ipm/attachments/20051117/860f2c29/attachment-0001.html