[Informatics] DB Normalisation

[Laurie Savage]

1NF should have one table with unique, simplified fields. It will contain a
lot of redundancy and each field will contain only piece of data.

Laurie Savage
PVGC

Laurie Savage
https://sites.google.com/a/pvgc.vic.edu.au/mr-savage/home

On 16 February 2016 at 21:00, McCleary Scott <McCS at jpc.vic.edu.au> wrote:

> Good evening everyone,
>
>
>
> Just trying to get my head around the normalisation process and comparing
> what the text book says (well, the online version of chapter 1) with
> examples found on various websites.
>
>
>
> The book has First Normal Form (1NF) as being a single table with a
> (possibly) concatenated primary key.  This is on page 31.  Most of the
> examples I have seen on the web seem to have split their original table at
> this stage if it has repeating groups.  See
> https://www.youtube.com/watch?v=x9BuWCUQawY as an example.
>
>
>
> Is it ok to split tables and have multiples at this stage of the
> normalisation process or should we only have one table at 1NF?  Don’t want
> to present contradictory info to my students is all.
>
>
>
> Cheers,
>
>
>
> Scott McCleary
>
> John Paul College
> This email and any attachments may be confidential. You must not disclose
> or use the information in this email if you are not the intended recipient.
> If you have received this email in error, please notify us immediately and
> delete the email and all copies. The 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 the
> College.
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20160217/88f3eb61/attachment.html