[Informatics] Data normalisation

[Mark]

Hi Robert.  Thanks for the message.

I have no worries about criticism of my materials.

The status of message recalls has never come up before, so I thought it
timely to establish a policy for the future.

Regards
Mark

On Tuesday, 4 October 2016, Robert Hind <robert at yinnar.com> wrote:

> Sorry Mark.
> And sorry that I ended up criticising one of your PowerPoint presentations
> which is freely available on your own vceit website.
>
> Robert Hind
> Ex Traralgon and Ashwood
> Retired
>
> ------------------------------
> *From:* informatics-bounces at edulists.com.au
> <javascript:_e(%7B%7D,'cvml','informatics-bounces at edulists.com.au');>
> [mailto:informatics-bounces at edulists.com.au
> <javascript:_e(%7B%7D,'cvml','informatics-bounces at edulists.com.au');>] *On
> Behalf Of *Mark
> *Sent:* Tuesday, 4 October 2016 7:25 PM
> *To:* Year 12 VCE Informatics Teachers' Mailing List
> *Subject:* Re: [Informatics] Data normalisation
>
> I would have thought that if the sender of a message said that the post
> was not intended for the list, recipients would delete it, and
> certainly not respond to its contents.
>
> On Tuesday, 4 October 2016, Robert Hind <robert at yinnar.com
> <javascript:_e(%7B%7D,'cvml','robert at yinnar.com');>> wrote:
>
>> Well Litsa you did send the ppt files to all of us and I was interested
>> enough to have a look at the example file.
>>
>> Now I must take exception to slides 26 and 27 - pics below
>>
>> Both the statements on yellow background are false. The HouseColor
>> depends only on the HouseName (or vice versa), not directly on the
>> StudentID.
>>
>> As almost noted in slide 28 " These two non-key fields are more
>> dependent on each other than they are on the primary key"
>>
>> The key 3NF rule here is: *"remove to a new table any non-key attributes
>> that are more dependent on other non-key attributes than the table key"*
>>
>> So we move HouseName and HouseColor to a new table and leave just
>> HouseName in the Student table.
>>
>> Robert Hind
>> Ex Traralgon and Ashwood
>> Retired
>>
>>
>> ------------------------------
>> *From:* informatics-bounces at edulists.com.au [mailto:
>> informatics-bounces at edulists.com.au] *On Behalf Of *Litsa Tzelepis
>> *Sent:* Tuesday, 4 October 2016 2:54 PM
>> *To:* Year 12 VCE Informatics Teachers' Mailing List
>> *Subject:* [Informatics] Data normalisation
>>
>>
>>
>> --
>> Litsa Tzelepis
>> Mount St. Joseph Girls' College
>> 133 Maidstone Street, Altona, VIC. 3018
>> htzelepis at msj.vic.edu.au
>> P:8398 2000 | F:9398 3498
>>
>> This Email and any attachments may be confidential and, if you are not
>> the intended recipient, you must not disclose or use the information in
>> this email. If received in error, please notify the sender and Mount St.
>> Joseph Girls' College immediately and delete the Email and all copies.
>> Mount St. Joseph Girls' College does not guarantee that this email is virus
>> or error free. The attached files are provided and may 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 Mount St. Joseph
>> Girls' College. Please consider the environment before printing this email.
>>
>> IMPORTANT! This email and any attachments may be confidential. If
>> received in error, please contact us and delete all copies. Mount St Joseph
>> Girls' College does not represent or warrant that the attached files are
>> free from computer viruses or other defects. The attached files are
>> provided, and may 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 liability of Mount St Joseph Girls'
>> College is limited in any event to either the resupply of the attached
>> files or the cost of having the attached files resupplied. Any
>> representations or opinions expressed in this email are those of the
>> individual sender, and not necessarily those of Mount St Joseph Girls'
>> College.
>> ------------------------------
>>
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2016.0.7797 / Virus Database: 4656/13141 - Release Date: 10/03/16
>>
>
>
> --
>
> Mark Kelly
>
> mark at vceit.com <javascript:_e(%7B%7D,'cvml','mark at vceit.com');>
> http://vceit.com
>
> ------------------------------
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7797 / Virus Database: 4656/13141 - Release Date: 10/03/16
>


-- 

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/20161004/b2b0748e/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ppt26.jpg
Type: image/jpeg
Size: 43151 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20161004/b2b0748e/ppt26-0001.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ppt27.jpg
Type: image/jpeg
Size: 43254 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20161004/b2b0748e/ppt27-0001.jpg