[Year 12 IT Apps] RE: pigs galore...
Mark Scott
msc at luther.vic.edu.au
Fri Jul 25 07:09:20 EST 2008
48 50 minute lessons to go before I lose my Yr12s
Mark Scott
Luther College
"If you don't change direction, you will probably end up where you are heading." Sara Felder
________________________________
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Kent Beveridge
Sent: Thursday, 24 July 2008 10:12 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] pigs galore...
Pigs galore, what a load of perky porkers! Holy cow what is this list coming to.....(hehehe)???
Peter pipers perky porkers oh, ok..I'm stopping now! (it is getting late in the year you know...)
KB.
Kent Beveridge,
I.T. co-ordinator
St. Brigids Catholic Sec. College
Horsham
email.. kbeveridge at stbc.vic.edu.au<mailto:kbeveridge at stbc.vic.edu.au>
|<3|\|7 b3\/3r1D93 ? ;-)
PARTY..PARTEE,..PARTIE,...PARTAY!!
"This email and any attachments may be confidential. You must not disclose or use the information in this email if you are not the intended recipient. If you have received this email in error, please notify us immediately and delete the email and all copies. The School does not guarantee that this email is virus or error free. 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. The content and opinions in this email are not necessarily those of the School."
________________________________
From: itapps-bounces at edulists.com.au on behalf of Anderson, Stuart L
Sent: Thu 7/24/2008 10:22 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Re: itapps Digest, Vol 41, Issue 16
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20080725/e4a97be0/attachment-0001.html
More information about the itapps
mailing list