[Informatics] Query on Practice exam solution

[Joseph Papaleo]

Hi all,

I am seeking some clarity please on normalisation.

A practice exam multiple choice question asks students to identify which table has achieved FIRST normal form.  The solutions provided refer to answer D being incorrect as there are repeated records.  Isn’t this 2nd normal form?

Thanks
Joseph








Joseph Papaleo

Member of Staff

[cid:imagef19c29.JPG at 00ee06e6.43b718a3]
[Ave Maria College]<http://www.avemaria.vic.edu.au>



DISCLAIMER: This e-mail and any attachments may be confidential. You must not disclose or use the information in this e-mail if you are not the intended recipient. If you have received this e-mail in error, please notify us immediately and delete the e-mail and all copies. Ave Maria College does not guarantee that this e-mail 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 e-mail are not necessarily those of Ave Maria College.

[cid:imagece1eef.JPG at f93ef3c1.439cd2b3] Please consider the environment, before printing this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20161027/87b376ac/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagef19c29.JPG
Type: image/jpeg
Size: 8968 bytes
Desc: imagef19c29.JPG
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20161027/87b376ac/imagef19c29-0001.JPG 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imageaf86e2.JPG
Type: image/jpeg
Size: 616824 bytes
Desc: imageaf86e2.JPG
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20161027/87b376ac/imageaf86e2-0001.JPG 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagece1eef.JPG
Type: image/jpeg
Size: 825 bytes
Desc: imagece1eef.JPG
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20161027/87b376ac/imagece1eef-0001.JPG