[Informatics] ERD policy

[Heath, Natalie]

Thanks again Mark. I’ll add this to the guide and hope it doesn’t scare them ☺

Natalie

Mrs Natalie Heath
ICT Learning Coordinator

[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] On Behalf Of Mark
Sent: Monday, 18 April 2016 11:57 AM
To: Year 12 VCE Informatics Teachers' Mailing List
Subject: Re: [Informatics] ERD policy

Hi Natalie

When I first saw "1:n" and "n:m" I also thought it must be a typo. I assumed 'm' was short for 'many'.

Research revealed that for 'both m and n refer to 'many' in the sense of "m" items on one side are related to  "n" items on the other side, and "1:n" means 1 item on one side is related to n items on the other side.

People explain it at http://stackoverflow.com/questions/3397349/meaning-of-nm-and-1n-in-database-design

Cheers
Mark

On 18 April 2016 at 11:34, Heath, Natalie <Natalie.Heath at marcellin.vic.edu.au<mailto:Natalie.Heath at marcellin.vic.edu.au>> wrote:
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

[Description: Marcellin_College_Logo_RGB_HR]

Marcellin College
160 Bulleen Road
Bulleen VIC 3105 Australia

T +61 3 9851 1698<tel:%2B61%203%209851%201698>
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> [mailto:informatics-bounces at edulists.com.au<mailto: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<mailto:mark at vceit.com>
http://vceit.com

Natalie Heath
Marcellin Staff
[Image removed by sender. Marcellin College Logo]
MARCELLIN COLLEGE
160 Bulleen Road
Bulleen VIC 3105 Australia
T +61 3 9851 1698<tel:%2B61%203%209851%201698>
F +61 3 9851 1555<tel:%2B61%203%209851%201555>
ABN 77 413 001 496
marcellin.vic.edu.au<http://marcellin.vic.edu.au>
twitter.com/Marcellin<http://twitter.com/Marcellin>
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the sender immediately by reply email and delete the email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Marcellin College. Marcellin College does not guarantee that this email is virus or error free and accepts no liability for any damage caused by any virus transmitted by this email.

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
VCE Informatics Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
http://www.swinburne.edu.au/ict/schools - Swinburne University



--

Mark Kelly

mark at vceit.com<mailto:mark at vceit.com>
http://vceit.com

Natalie Heath
Marcellin Staff

[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>
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the sender immediately by reply email and delete the email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Marcellin College. Marcellin College does not guarantee that this email is virus or error free and accepts no liability for any damage caused by any virus transmitted by this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20160418/7521e6ab/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ~WRD000.jpg
Type: image/jpeg
Size: 823 bytes
Desc: ~WRD000.jpg
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20160418/7521e6ab/WRD000-0001.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3933 bytes
Desc: image001.jpg
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20160418/7521e6ab/image001-0001.jpg