[Year 12 IT Apps] Excellent Normalisation example

[Ciotti, George W]

Hi,



after spending some time looking for a simple and relative Normalisation example for my ITA class I found this one. It's very good and it starts off in Excel and then ports the finished tables into Access in a way I never knew you could. It's a great starting point and my kids are actually beginning to understand how it all fits together.



http://office.microsoft.com/en-us/excel-help/move-data-from-excel-to-access-HA010342703.aspx?CTT=1#_Toc297903648



I have attached the excel spreadsheet (Microsoft Example_norm_to_Access.xlsx) that I copied from the site plus the developed excel and associated access files - (MS_Access_ex1.zip).



Firstly, I got the students to follow the procedure outlined in the article, and you really only need to view the 4 associated videos, and once they finish this I will get them to do it again using another 0NF spreadsheet. The one I am using is from the VITTA PD at the start of the year.(Normalisation_Nat.zip).



The process provides a great foundation for discussion regarding primary and foreign keys as well as whether and how to set up a database using imported IDs or setting up autonumbered IDs.



Hope this is useful.



cheers

George



Uuniversity High School

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20120503/d8a2c20c/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Microsoft Example_norm_to_Access.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 11142 bytes
Desc: Microsoft Example_norm_to_Access.xlsx
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20120503/d8a2c20c/MicrosoftExample_norm_to_Access-0001.xlsx 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: MS_Access_ex1.zip
Type: application/x-zip-compressed
Size: 41429 bytes
Desc: MS_Access_ex1.zip
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20120503/d8a2c20c/MS_Access_ex1-0001.zip 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Normalisation_Nat.zip
Type: application/x-zip-compressed
Size: 40682 bytes
Desc: Normalisation_Nat.zip
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20120503/d8a2c20c/Normalisation_Nat-0001.zip