[Year 12 IT Apps] Re: itapps Digest, Vol 41, Issue 16

Thu Jul 24 10:22:40 EST 2008

hope this helps.

- Stuart Anderson

________________________________

From: itapps-bounces at edulists.com.au on behalf of Margaret McArthur
Sent: Thu 24/07/2008 10:02 AM
To: itapps at edulists.com.au
Subject: [Year 12 IT Apps] Re: itapps Digest, Vol 41, Issue 16

Does anyone know where to find the pigs galore practice outcome for
Unit 4 Outcome 1. 

I have checked on  the VITTA site and the VITTA cd and can not find
it.

Margaret McArthur
The GEELONG College

>>> itapps-request at edulists.com.au 24/07/2008 9:11 am >>>
Send itapps mailing list submissions to
        itapps at edulists.com.au

To subscribe or unsubscribe via the World Wide Web, visit
        http://www.edulists.com.au/mailman/listinfo/itapps
or, via email, send a message with subject or body 'help' to
        itapps-request at edulists.com.au

You can reach the person managing the list at
        itapps-owner at edulists.com.au

When replying, please edit your Subject line so it is more specific
than "Re: Contents of itapps digest..."

Today's Topics:

   1. Re: Database relationships (Mia Alexiou)
   2. RE: Database relationships (Russo, Frank R)

----------------------------------------------------------------------

Message: 1
Date: Wed, 23 Jul 2008 21:59:01 +1000
From: "Mia Alexiou" <efthimia at gmail.com>
Subject: Re: [Year 12 IT Apps] Database relationships
To: "Year 12 IT Applications Teachers' Mailing List"
        <itapps at edulists.com.au>
Message-ID:
        <e5f512420807230459r4a81be7m2a81e1095e561581 at mail.gmail.com>
Content-Type: text/plain; charset="windows-1252"

Sorry when I wrote "0 or 1 to many" at the end there  I really meant "0
or 1
to 1".  Big apology for confusing things further.

I suggest anyone reading this skips my prior long-winded discussion and
just
refers to Allan's example - it captures the idea nicely.

Mia

On Wed, Jul 23, 2008 at 9:14 PM, Allan Barnes <abarnes at aiet.com.au>
wrote:

>  An example of a one-to-one relationship would be something like a
> 'person' entity and a 'medicare card' entity * one person can only
have one
> medicare card, and one medicare card can only belong to one person.
>
>
>
>
>
>
>
>
>
>
>
> Kind regards
>
>
>
> Allan Barnes, CEO
>
> Australian Institute of Education and Training
>
> P.O. Box 171
>
> Brunswick West 3055
>
> Ph: (03) 9387 2051
>
> FAX: (03) 9387 3470
>
> Mobile: 0409 428 221
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Mia Alexiou
> *Sent:* Wednesday, 23 July 2008 9:05 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Database relationships
>
>
>
> Hi all,
>
> I'm an intruder here (I tech year 11 not year 12) but I thought I
could
> share my somewhat rusty knowledge of databases.
>
> In response to Lisa's question the employee/department relationship
is
> one-to-many.   As for "true" one-to-one relationships I've never seen
one in
> action and so doubt they are common at a small database level.  That
being
> said, I can think of a couple of situations where they might be
useful such
> as splitting commonly needed data from that which is rarely needed,
to
> reduce the time it takes to run queries over a huge table.  Another
reason
> might be security, with highly sensitive data being stored in a
separate
> table.
>
> A 0 or 1 to-many relationship is much more common and is what most
people
> (even in industry) usually mean when they talk about one-to-one
> relationships.  These are explained nicely (under the one-to-one
heading!)
> at http://www.onlamp.com/pub/a/onlamp/2001/03/20/aboutSQL.html.
>
> I hope this was helpful
>
> Mia Alexiou
> RMIT TAFE
> Information Technology
> Sessional Teacher
>
>  On Wed, Jul 23, 2008 at 6:10 PM, Lisa Imms <lisimms at copticvic.org>
wrote:
>
> Hi Mark,
>
> Firstly, thanks for the resource :-)
>
> I hate to even contemplate disagreeing with you as my ITA class and
I
> regard you as the ITA font-of-all-knowledge, but I will try this
anyway.....
>
> Your example for one-to-one: "E.g. an employee's department data in
one
> table matches a corresponding department in another table, allowing
data
> relating to that department to be fetched."
>
> Wouldn't this be a one to many relationship? Even the line you have
joining
> them has the 'many feathers' at the employees table? Although each
employee
> can belong to only one department, each department can (and will)
have
> multiple employees? So it is actually a one to many relationship?
>
> Am I correct in assuming that a well organised database would not
have any
> one-to-one relationships? The two tables in a one-to-one
relationship
> could/should just be merged into one table?
>
> Lisa Bairstow
> St Mary's Coptic Orthodox College
>
> ________________________________
>
> From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
> Sent: Wed 7/23/2008 2:24 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: [Year 12 IT Apps] Database relationships
>
>
>
>
> Hi all.  It's been mighty quiet here for a while.  To perk things
up,
> here's a little revision for database relationships (1-1, 1-many,
> many-many) that may or may not be useful.
>
> Cheers
> Mark
>
> --
> Mark Kelly
> Manager - Information Systems
> McKinnon Secondary College
> McKinnon Rd McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: 8520 9085
> School Phone +613 8520 9000
> School Fax +613 95789253
> kel AT mckinnonsc.vic.edu.au
>
> Webmaster - http://www.mckinnonsc.vic.edu.au <http://www.mckinnonsc.vic.edu.au/>  <
> http://www.mckinnonsc.vic.edu.au/>
> IT Lecture notes: http://vceit.com <http://vceit.com/>  <http://vceit.com/>
>
> Moderator: IT Applications Mailing List
>
> If you Declare War - is it integer or boolean?
> _______________________________________________
>
> http://www.edulists.com.au <http://www.edulists.com.au/>  <http://www.edulists.com.au/>  - FAQ,
> resources, subscribe, unsubscribe
>
> IT Applications Mailing List kindly supported by
>
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html
-
> Victorian Curriculum and Assessment Authority and
>
> http://www.vitta.org.au <http://www.vitta.org.au/>  <http://www.vitta.org.au/>   - VITTA
Victorian
> Information Technology Teachers Association Inc
>
>
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
>
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html
-
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Information Technology
Teachers
> Association Inc
>
>
>
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
>
<http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20>-
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/>  - VITTA Victorian Information Technology
Teachers
> Association Inc
>
>
>  ------------------------------
>
> Message protected by MailGuard: e-mail anti-virus, anti-spam and
content
> filtering.
> http://www.mailguard.com.au/mg
>
> Report this message as
spam<https://login.mailguard.com.au/report/1vuYjlI9hA/408s2xedFO3BSztpPnlZPi/0.004>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com <http://www.avg.com/> 
> Version: 8.0.138 / Virus Database: 270.5.4/1567 - Release Date:
7/22/2008
> 4:05 PM
>  _______________________________________________
>  http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
>  http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
>
<http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html>
-
> 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/itapps/attachments/20080723/7aa971dc/attachment-0001.html

------------------------------

Message: 2
Date: Thu, 24 Jul 2008 08:33:16 +1000
From: "Russo, Frank R" <Russo.Frank.R at edumail.vic.gov.au>
Subject: RE: [Year 12 IT Apps] Database relationships
To: "Year 12 IT Applications Teachers' Mailing List"
        <itapps at edulists.com.au>
Message-ID:
        <85DA2549FD1E954FAC20769096D681560248E2B6 at edusm01.education.vic.gov.au>

Content-Type: text/plain; charset="us-ascii"

Skipped content of type multipart/alternative-------------- next part
--------------
A non-text attachment was scrubbed...
Name: Russo, Frank R.vcf
Type: text/x-vcard
Size: 524 bytes
Desc: Russo, Frank R.vcf
Url :
http://www.edulists.com.au/pipermail/itapps/attachments/20080724/ea88133d/RussoFrankR.vcf

------------------------------

_______________________________________________
itapps mailing list
itapps at edulists.com.au
http://www.edulists.com.au/mailman/listinfo/itapps

End of itapps Digest, Vol 41, Issue 16
**************************************
--
Message  protected by MailGuard: e-mail anti-virus, anti-spam and
content filtering.
http://www.mailguard.com.au/tt

Click here to report this message as spam:
https://login.mailguard.com.au/report/1vvbaBXKyC/76CoOc62Xhtf8RHOht3Wc3/0.6

_______________________________________________
http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - 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 --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 84407 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080724/958045d9/attachment-0001.bin