[Informatics] DB Normalisation

[McCleary Scott]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20160216/e5a1c53b/attachment.html