[Informatics] Data normalisation

Mark mark at vceit.com
Tue Oct 4 20:44:19 AEDT 2016


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> 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
> <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 *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
> <javascript:_e(%7B%7D,'cvml','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
http://vceit.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20161004/633b13da/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/633b13da/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/633b13da/ppt27-0001.jpg 


More information about the informatics mailing list