[Informatics] ERD policy

Mark mark at vceit.com
Mon Apr 18 12:17:12 AEST 2016


G'day Lucas

On 18 April 2016 at 12:07, Garth, Lucas A <garth.lucas.a at edumail.vic.gov.au>
wrote:

>
>
> I imagine N stands for “a number of records” rather than many records.
> (Then why don’t we use N:N?)
>


I think it's because the numbers n and m can be different at each end.


> Maybe it’s best to just always use crows feet and be done with it.
>


Just remember that the document gives the examiners a licence to use any of
the styles described in the end of year exam, so kids should be trained to
use those formats in their other work as well.


>
>
> Lucas
>
>
>
>
>
> *From:* informatics-bounces at edulists.com.au [mailto:
> informatics-bounces at edulists.com.au] *On Behalf Of *Heath, Natalie
> *Sent:* Monday, 18 April 2016 11:35 AM
> *To:* Year 12 VCE Informatics Teachers' Mailing List
> *Subject:* Re: [Informatics] ERD policy
>
>
>
> Thanks Mark. I wish I’d had this when I was actually teaching it…. Last
> term….
>
>
>
> Quick question. On page 3 the sample has 1:N library member borrows book….
> Shouldn’t this be 1:M? Or am I missing something? 1:N isn’t in the list
> above it so I’m nicely confused.
>
>
>
> Natalie
>
>
>
> *Mrs Natalie Heath*
>
> ICT Learning Coordinator
>
>
>
> [image: Description: Marcellin_College_Logo_RGB_HR]
>
>
>
> Marcellin College
>
> 160 Bulleen Road
>
> Bulleen VIC 3105 Australia
>
>
>
> T +61 3 9851 1698
>
> ABN 77 413 001 496
>
>
>
> *marcellin.vic.edu.au* <http://www.marcellin.vic.edu.au/>
>
> *twitter.com/Marcellin* <http://twitter.com/MCBulleen>
>
>
>
> *From:* informatics-bounces at edulists.com.au [
> mailto:informatics-bounces at edulists.com.au
> <informatics-bounces at edulists.com.au>] *On Behalf Of *Mark
> *Sent:* Monday, 18 April 2016 11:12 AM
> *To:* Year 12 VCE Informatics Teachers' Mailing List
> *Subject:* [Informatics] ERD policy
>
>
>
> Hi folks. The long-awaited VCAA Entity Relationship Diagram policy
> <http://www.vcaa.vic.edu.au/Documents/vce/computing/Informatics_examination_ER_Conventions.docx>
> is out.
>
>
>
> And it includes cardinality with both Chen "1/M/N" and crowsfeet notations!
>
>
>
> Finally!
>
>
>
> --
>
>
>
> Mark Kelly
>
>
>
> mark at vceit.com
>
> http://vceit.com
>
>
>
> *Natalie Heath *
>
> Marcellin Staff
>
> [image: Marcellin College Logo]
>
> MARCELLIN COLLEGE
>
> 160 Bulleen Road
> Bulleen VIC 3105 Australia
> T +61 3 9851 1698
> F +61 3 9851 1555
> ABN 77 413 001 496
>
> *marcellin.vic.edu.au* <http://marcellin.vic.edu.au>
> *twitter.com/Marcellin* <http://twitter.com/Marcellin>
>
>
>
-- 

Mark Kelly

mark at vceit.com
http://vceit.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20160418/87537fe1/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3933 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20160418/87537fe1/image001.jpg 


More information about the informatics mailing list