[Year 12 IT Apps] Table Normalisation

[Mark KELLY]

I looked up normalisation levels 1-3 and had to have a Bex and a good lie
down.

It's funny because normally I love discussing things like how NF2 aims to
ensure that no non-prime attribute in the table is functionally dependent on
a proper subset of a candidate key.

:-o

On 31 March 2011 13:02, Robert Hind <robert at yinnar.com> wrote:

>  You might like to look at
>
> http://databases.about.com/od/specificproducts/a/normalization.htm
>
> Robert Hind (Semi-retired) OOF, GOM
> Ashwood and Traralgon
> robert at yinnar.com
>
>
>
> ----- Original Message -----
> *From:* Laura Fihelly <fihl at crcsydenham.net>
> *To:* Year 12 IT Applications Teachers' Mailing List<itapps at edulists.com.au>
> *Sent:* Thursday, March 31, 2011 10:59 AM
> *Subject:* [Year 12 IT Apps] Table Normalisation
>
>  Hi everyone,
>
>
>
> Can someone please help me with this Sample Exam question. I am trying to
> understand table normalization. I have a general understanding of what it
> means, but I’m not really sure about the actual differences in this
> particular question between the second and third normal forms. As a class we
> have been going through the textbook definition, but I’m struggling to apply
> it to this particular sample question.
>
>
>
> Also if anyone has some good resources on a simple (not so technical way)
> of how to explain this easier it would be greatly appreciated.
>
>
>
> Thanks**
>
> *Question 1*
>
> Below is a table from a yacht club’s relational database.
>
> *Name***
>
> *Boat Name***
>
> *Address_Suburb***
>
> *State***
>
> *memType***
>
> *Fees $***
>
> *Gender***
>
> *Boat Storage Fees $***
>
> *Total Fees Due $***
>
> Sue Trowsdale
>
> Suzy
>
> 21 Mountain Rd Rosebud
>
> VIC
>
> Senior
>
> 250.00
>
> F
>
> 125.00
>
> 375.00
>
> Jon Ross
>
> Wahoo
>
> 64 View Rd McCrae
>
> VIC
>
> Junior
>
> 140.00
>
> M
>
> –
>
> 140.00
>
> Harry Wilson
>
> Victor
>
> 35 Shady Ln Rosebud
>
> VIC
>
> Life
>
> –
>
> M
>
> 125.00
>
> 125.00
>
>
>
> 2 marks
>
> *a.     *Describe what would happen when you apply *one *of the First,
> Second or Third Normal Forms to data in the table. Refer to the table in
> your answer.
>
>
>
> Tick the box to indicate which normal form you are describing.
>
>    First o   or       Second  o     or         Third o
>
>
> ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
>
>
> ____________________________________________________________________________________
>
>
>
> Laura Fihelly
>
> Teacher of Business Management & Information Technologies
>
> Catholic Regional College Sydenham
>
> 380 Sydenham Road
>
> Sydenham 3037
>
> email: fihl at crcsydenham.net
>
> web: www.crcsydenham.net
>
>
>
> ------------------------------
>
> _______________________________________________
> 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  - VITTA Victorian Information Technology Teachers
> Association Inc
>
>
> _______________________________________________
> 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  - VITTA Victorian Information Technology Teachers
> Association Inc
>



-- 
Mark Kelly
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist

All generalisations are false, except this one.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110331/b841a997/attachment-0001.html