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

Thu Jul 24 10:02:44 EST 2008

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/>
> IT Lecture notes: 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/>  - 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 - 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  - VITTA Victorian Information Technology
Teachers
> Association Inc
>
>
>
> _______________________________________________
> 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 - 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 
> Version: 8.0.138 / Virus Database: 270.5.4/1567 - Release Date:
7/22/2008
> 4:05 PM
>  _______________________________________________
>  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 - 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