[Year 12 IPM] Exam Short Answer Question 2

[Lel, Ronald A]

	-----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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/ipm/attachments/20051117/6db813eb/attachment-0001.html