<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML
dir=ltr><HEAD><TITLE>[Year 12 IT Apps] Re: itapps Digest, Vol 41, Issue 16</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.13" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=759310821-24072008>48 50 minute lessons to
go before I lose my Yr12s</SPAN></DIV>
<DIV> </DIV>
<DIV><A name=_MailAutoSig><SPAN
style="COLOR: black; mso-bidi-font-weight: bold; mso-no-proof: yes">Mark
Scott</SPAN></A><BR><SPAN class=759310821-24072008></SPAN>L<SPAN
class=759310821-24072008>uther College</SPAN><BR><SPAN
style="mso-bookmark: _MailAutoSig"><SPAN
style="COLOR: black; mso-bidi-font-weight: bold; mso-no-proof: yes">“</SPAN><SPAN
style="mso-no-proof: yes">If you don't change direction, you will probably end
up where you are heading.” <SPAN style="mso-bidi-font-weight: bold">Sara
Felder</SPAN><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></SPAN></DIV><SPAN
style="mso-bookmark: _MailAutoSig"></SPAN>
<P class=MsoNormal align=left><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal align=left><o:p> </o:p></P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>Kent
Beveridge<BR><B>Sent:</B> Thursday, 24 July 2008 10:12 PM<BR><B>To:</B> Year 12
IT Applications Teachers' Mailing List<BR><B>Subject:</B> [Year 12 IT Apps] pigs
galore...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText91494 dir=ltr>
<DIV dir=ltr><FONT face=Arial size=2>Pigs galore, what a load of perky
porkers! Holy cow what is this list coming to.....(hehehe)???</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>Peter pipers perky porkers oh, ok..I'm
stopping now! (it is getting late in the year you know...)</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>KB.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV></DIV>
<DIV id=idSignature79598 dir=ltr>
<DIV><FONT face=Arial color=#000000 size=2>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT face="Times New Roman" color=#0000ff><STRONG>Kent
Beveridge</STRONG>,</FONT></SPAN></I></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT face="Times New Roman" color=#0000ff>I.T.
co-ordinator</FONT></SPAN></I></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT face="Times New Roman" color=#0000ff>St. Brigids
Catholic Sec. College</FONT></SPAN></I></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT face="Times New Roman"
color=#0000ff>Horsham</FONT></SPAN></I></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT face="Times New Roman">email.. <A
href="mailto:kbeveridge@stbc.vic.edu.au">kbeveridge@stbc.vic.edu.au</A></FONT></SPAN></I></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT
face="Times New Roman"></FONT></SPAN></I> </DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><STRONG>|<3|\|7 b3\/3r1D93 ?
;-)</STRONG><BR></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT face="Times New Roman"
color=#800080>PARTY..PARTEE,..PARTIE,...PARTAY!!</FONT></SPAN></I></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42.55pt"><I><SPAN lang=EN-AU
style="FONT-SIZE: 12pt"><FONT face="Times New Roman" color=#800080>“This email
and any attachments may be confidential.<SPAN> </SPAN>You must not
disclose or use the information in this email if you are not the intended
recipient.<SPAN> </SPAN>If you have received this email in error, please
notify us immediately and delete the email and all copies.<SPAN>
</SPAN>The School does not guarantee that this email is virus or error
free.<SPAN> </SPAN>The attached files are provided and my only be used on
the basis that the user assumes all responsibility for any loss, damage or
consequence resulting directly or indirectly from the use of the attached files,
whether caused by the negligence of the sender or not.<SPAN> </SPAN>The
content and opinions in this email are not necessarily those of the
School.”</FONT></SPAN></I></DIV></FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au on behalf
of Anderson, Stuart L<BR><B>Sent:</B> Thu 7/24/2008 10:22 AM<BR><B>To:</B> Year
12 IT Applications Teachers' Mailing List<BR><B>Subject:</B> RE: [Year 12 IT
Apps] Re: itapps Digest, Vol 41, Issue 16<BR></FONT><BR></DIV>
<DIV dir=ltr>
<DIV id=idOWAReplyText91168 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>hope this helps.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>- Stuart Anderson</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au on behalf
of Margaret McArthur<BR><B>Sent:</B> Thu 24/07/2008 10:02 AM<BR><B>To:</B>
itapps@edulists.com.au<BR><B>Subject:</B> [Year 12 IT Apps] Re: itapps Digest,
Vol 41, Issue 16<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>Does anyone know where to find the pigs galore practice outcome
for<BR>Unit 4 Outcome 1. <BR><BR>I have checked on the VITTA site and
the VITTA cd and can not find<BR>it.<BR><BR>Margaret McArthur<BR>The GEELONG
College<BR><BR>>>> itapps-request@edulists.com.au 24/07/2008 9:11 am
>>><BR>Send itapps mailing list submissions
to<BR>
itapps@edulists.com.au<BR><BR>To subscribe or unsubscribe via the World Wide
Web, visit<BR> <A
href="http://www.edulists.com.au/mailman/listinfo/itapps">http://www.edulists.com.au/mailman/listinfo/itapps</A><BR>or,
via email, send a message with subject or body 'help'
to<BR>
itapps-request@edulists.com.au<BR><BR>You can reach the person managing the list
at<BR>
itapps-owner@edulists.com.au<BR><BR>When replying, please edit your Subject line
so it is more specific<BR>than "Re: Contents of itapps
digest..."<BR><BR><BR>Today's Topics:<BR><BR> 1. Re: Database
relationships (Mia Alexiou)<BR> 2. RE: Database relationships
(Russo, Frank
R)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message:
1<BR>Date: Wed, 23 Jul 2008 21:59:01 +1000<BR>From: "Mia Alexiou"
<efthimia@gmail.com><BR>Subject: Re: [Year 12 IT Apps] Database
relationships<BR>To: "Year 12 IT Applications Teachers' Mailing
List"<BR>
<itapps@edulists.com.au><BR>Message-ID:<BR>
<e5f512420807230459r4a81be7m2a81e1095e561581@mail.gmail.com><BR>Content-Type:
text/plain; charset="windows-1252"<BR><BR>Sorry when I wrote "0 or 1 to many" at
the end there I really meant "0<BR>or 1<BR>to 1". Big apology for
confusing things further.<BR><BR>I suggest anyone reading this skips my prior
long-winded discussion and<BR>just<BR>refers to Allan's example - it captures
the idea nicely.<BR><BR>Mia<BR><BR><BR>On Wed, Jul 23, 2008 at 9:14 PM, Allan
Barnes <abarnes@aiet.com.au><BR>wrote:<BR><BR>> An example of a
one-to-one relationship would be something like a<BR>> 'person' entity and a
'medicare card' entity * one person can only<BR>have one<BR>> medicare card,
and one medicare card can only belong to one
person.<BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>>
Kind regards<BR>><BR>><BR>><BR>> Allan Barnes, CEO<BR>><BR>>
Australian Institute of Education and Training<BR>><BR>> P.O. Box
171<BR>><BR>> Brunswick West 3055<BR>><BR>> Ph: (03) 9387
2051<BR>><BR>> FAX: (03) 9387 3470<BR>><BR>> Mobile: 0409 428
221<BR>><BR>> *From:* itapps-bounces@edulists.com.au [mailto:<BR>>
itapps-bounces@edulists.com.au] *On Behalf Of *Mia Alexiou<BR>> *Sent:*
Wednesday, 23 July 2008 9:05 PM<BR>> *To:* Year 12 IT Applications Teachers'
Mailing List<BR>> *Subject:* Re: [Year 12 IT Apps] Database
relationships<BR>><BR>><BR>><BR>> Hi all,<BR>><BR>> I'm an
intruder here (I tech year 11 not year 12) but I thought I<BR>could<BR>>
share my somewhat rusty knowledge of databases.<BR>><BR>> In response to
Lisa's question the employee/department relationship<BR>is<BR>>
one-to-many. As for "true" one-to-one relationships I've never
seen<BR>one in<BR>> action and so doubt they are common at a small database
level. That<BR>being<BR>> said, I can think of a couple of situations
where they might be<BR>useful such<BR>> as splitting commonly needed data
from that which is rarely needed,<BR>to<BR>> reduce the time it takes to run
queries over a huge table. Another<BR>reason<BR>> might be security,
with highly sensitive data being stored in a<BR>separate<BR>>
table.<BR>><BR>> A 0 or 1 to-many relationship is much more common and is
what most<BR>people<BR>> (even in industry) usually mean when they talk about
one-to-one<BR>> relationships. These are explained nicely (under the
one-to-one<BR>heading!)<BR>> at <A
href="http://www.onlamp.com/pub/a/onlamp/2001/03/20/aboutSQL.html">http://www.onlamp.com/pub/a/onlamp/2001/03/20/aboutSQL.html</A>.<BR>><BR>>
I hope this was helpful<BR>><BR>> Mia Alexiou<BR>> RMIT TAFE<BR>>
Information Technology<BR>> Sessional Teacher<BR>><BR>> On Wed,
Jul 23, 2008 at 6:10 PM, Lisa Imms
<lisimms@copticvic.org><BR>wrote:<BR>><BR>> Hi Mark,<BR>><BR>>
Firstly, thanks for the resource :-)<BR>><BR>> I hate to even contemplate
disagreeing with you as my ITA class and<BR>I<BR>> regard you as the ITA
font-of-all-knowledge, but I will try this<BR>anyway.....<BR>><BR>> Your
example for one-to-one: "E.g. an employee's department data in<BR>one<BR>>
table matches a corresponding department in another table,
allowing<BR>data<BR>> relating to that department to be
fetched."<BR>><BR>> Wouldn't this be a one to many relationship? Even the
line you have<BR>joining<BR>> them has the 'many feathers' at the employees
table? Although each<BR>employee<BR>> can belong to only one department, each
department can (and will)<BR>have<BR>> multiple employees? So it is actually
a one to many relationship?<BR>><BR>> Am I correct in assuming that a well
organised database would not<BR>have any<BR>> one-to-one relationships? The
two tables in a one-to-one<BR>relationship<BR>> could/should just be merged
into one table?<BR>><BR>> Lisa Bairstow<BR>> St Mary's Coptic Orthodox
College<BR>><BR>> ________________________________<BR>><BR>> From:
itapps-bounces@edulists.com.au on behalf of Mark Kelly<BR>> Sent: Wed
7/23/2008 2:24 PM<BR>> To: Year 12 IT Applications Teachers' Mailing
List<BR>> Subject: [Year 12 IT Apps] Database
relationships<BR>><BR>><BR>><BR>><BR>> Hi all. It's been
mighty quiet here for a while. To perk things<BR>up,<BR>> here's a
little revision for database relationships (1-1, 1-many,<BR>> many-many) that
may or may not be useful.<BR>><BR>> Cheers<BR>> Mark<BR>><BR>>
--<BR>> Mark Kelly<BR>> Manager - Information Systems<BR>> McKinnon
Secondary College<BR>> McKinnon Rd McKinnon 3204, Victoria, Australia<BR>>
Direct line / Voicemail: 8520 9085<BR>> School Phone +613 8520 9000<BR>>
School Fax +613 95789253<BR>> kel AT mckinnonsc.vic.edu.au<BR>><BR>>
Webmaster - <A
href="http://www.mckinnonsc.vic.edu.au/">http://www.mckinnonsc.vic.edu.au</A>
<<BR>> <A
href="http://www.mckinnonsc.vic.edu.au/">http://www.mckinnonsc.vic.edu.au/</A>><BR>>
IT Lecture notes: <A href="http://vceit.com/">http://vceit.com</A> <<A
href="http://vceit.com/">http://vceit.com/</A>><BR>><BR>> Moderator: IT
Applications Mailing List<BR>><BR>> If you Declare War - is it integer or
boolean?<BR>> _______________________________________________<BR>><BR>>
<A href="http://www.edulists.com.au/">http://www.edulists.com.au</A> <<A
href="http://www.edulists.com.au/">http://www.edulists.com.au/</A>> -
FAQ,<BR>> resources, subscribe, unsubscribe<BR>><BR>> IT Applications
Mailing List kindly supported by<BR>><BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A><BR>-<BR>>
Victorian Curriculum and Assessment Authority and<BR>><BR>> <A
href="http://www.vitta.org.au/">http://www.vitta.org.au</A> <<A
href="http://www.vitta.org.au/">http://www.vitta.org.au/</A>> -
VITTA<BR>Victorian<BR>> Information Technology Teachers Association
Inc<BR>><BR>><BR>>
_______________________________________________<BR>> <A
href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ,
resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly
supported by<BR>><BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A><BR>-<BR>>
Victorian Curriculum and Assessment Authority and<BR>> <A
href="http://www.vitta.org.au/">http://www.vitta.org.au</A> - VITTA
Victorian Information Technology<BR>Teachers<BR>> Association
Inc<BR>><BR>><BR>><BR>>
_______________________________________________<BR>> <A
href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ,
resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly
supported by<BR>> <A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</A><BR>><BR><<A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20</A>>-<BR>>
Victorian Curriculum and Assessment Authority and<BR>> <A
href="http://www.vitta.org.au/">http://www.vitta.org.au</A> - VITTA Victorian
Information Technology<BR>Teachers<BR>> Association
Inc<BR>><BR>><BR>> ------------------------------<BR>><BR>>
Message protected by MailGuard: e-mail anti-virus, anti-spam
and<BR>content<BR>> filtering.<BR>> <A
href="http://www.mailguard.com.au/mg">http://www.mailguard.com.au/mg</A><BR>><BR>>
Report this message as<BR>spam<<A
href="https://login.mailguard.com.au/report/1vuYjlI9hA/408s2xedFO3BSztpPnlZPi/0.004">https://login.mailguard.com.au/report/1vuYjlI9hA/408s2xedFO3BSztpPnlZPi/0.004</A>><BR>><BR>><BR>>
No virus found in this incoming message.<BR>> Checked by AVG - <A
href="http://www.avg.com/">http://www.avg.com</A><BR>> Version: 8.0.138 /
Virus Database: 270.5.4/1567 - Release Date:<BR>7/22/2008<BR>> 4:05
PM<BR>> _______________________________________________<BR>>
<A href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ,
resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly
supported by<BR>> <A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</A><BR>><BR><<A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>><BR>-<BR>>
Victorian Curriculum and Assessment Authority and<BR>> <A
href="http://www.vitta.org.au/">http://www.vitta.org.au</A> - VITTA Victorian
Information Technology<BR>Teachers<BR>> Association
Inc<BR>><BR>-------------- next part --------------<BR>An HTML attachment was
scrubbed...<BR>URL:<BR><A
href="http://www.edulists.com.au/pipermail/itapps/attachments/20080723/7aa971dc/attachment-0001.html">http://www.edulists.com.au/pipermail/itapps/attachments/20080723/7aa971dc/attachment-0001.html</A><BR><BR><BR>------------------------------<BR><BR>Message:
2<BR>Date: Thu, 24 Jul 2008 08:33:16 +1000<BR>From: "Russo, Frank R"
<Russo.Frank.R@edumail.vic.gov.au><BR>Subject: RE: [Year 12 IT Apps]
Database relationships<BR>To: "Year 12 IT Applications Teachers' Mailing
List"<BR>
<itapps@edulists.com.au><BR>Message-ID:<BR>
<85DA2549FD1E954FAC20769096D681560248E2B6@edusm01.education.vic.gov.au><BR> <BR>Content-Type:
text/plain; charset="us-ascii"<BR><BR>Skipped content of type
multipart/alternative-------------- next part<BR>--------------<BR>A non-text
attachment was scrubbed...<BR>Name: Russo, Frank R.vcf<BR>Type:
text/x-vcard<BR>Size: 524 bytes<BR>Desc: Russo, Frank R.vcf<BR>Url :<BR><A
href="http://www.edulists.com.au/pipermail/itapps/attachments/20080724/ea88133d/RussoFrankR.vcf">http://www.edulists.com.au/pipermail/itapps/attachments/20080724/ea88133d/RussoFrankR.vcf</A><BR><BR><BR>------------------------------<BR><BR>_______________________________________________<BR>itapps
mailing list<BR>itapps@edulists.com.au<BR><A
href="http://www.edulists.com.au/mailman/listinfo/itapps">http://www.edulists.com.au/mailman/listinfo/itapps</A><BR><BR><BR>End
of itapps Digest, Vol 41, Issue
16<BR>**************************************<BR>--<BR>Message protected by
MailGuard: e-mail anti-virus, anti-spam and<BR>content filtering.<BR><A
href="http://www.mailguard.com.au/tt">http://www.mailguard.com.au/tt</A><BR><BR>Click
here to report this message as spam:<BR><A
href="https://login.mailguard.com.au/report/1vvbaBXKyC/76CoOc62Xhtf8RHOht3Wc3/0.6">https://login.mailguard.com.au/report/1vvbaBXKyC/76CoOc62Xhtf8RHOht3Wc3/0.6</A><BR><BR><BR>_______________________________________________<BR><A
href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ,
resources, subscribe, unsubscribe<BR>IT Applications Mailing List kindly
supported by<BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-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<BR></FONT></P></DIV></DIV></BODY></HTML>