[Year 12 IPM] Exam Short Answer Question 2

[Geoff Moss]

MessageRon

I find it difficult to follow a thread I have been following on the lists if you do not use top posts.  

I find it dfficult to follow your responses to Mark.  (Yeah - I may be an old fuddy duddy - but I thnk we have successfully survied over the years with top posting.)

The question also arises where to place the response if the person replying is replying to an email that has multiple email entries within them, as happens regularly on the list.  (I don't object to this as the thread can be followed).

Geoff Moss
RMIT
  ----- Original Message ----- 
  From: Lel, Ronald A 
  To: Year 12 Information Technology Processing and Management Teachers'MailingList 
  Sent: Thursday, November 17, 2005 12:38 PM
  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 



    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 

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

  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 - FAQ, resources, subscribe, unsubscribe 
  IPM Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and 
  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/26ba512f/attachment.html