[Year 12 IT Apps] Databse Normalisation

[Davies, Brett]

Jenny,

U don't sound like a know it all at all. Many of us are struggling with this area.

Mark works his ring off and puts himself out there for all of us and while it's not always perfect it always puts us in the right direction

I know I would and I'm sure Mark would appreciate it if you edited the ppt so it was correct as you see it. If nothing else it would further the discussion

Cheers

On the Road again!
Brett Davies
Woodleigh 

On 18/04/2011, at 12:57 PM, "JennyG" <j1 at imaginethis.biz> wrote:

> Hi Mark,
> I'm afraid to say your 3rd Normal form example in your Powerpoint is not normalized.
> It would have 3 tables and look like this:
> 
> Tournaments table
> TournamentCode
> TournamentName
> TournamentYear
> 
> Players table
> PlayerCode - unique key
> PlayerName
> PlayerDOB
> 
> TournamentWinners table
> TournamentCode
> PlayerCode - both fields making the unique key
> 
> Also, repeating data does not mean repeating within one record. It means repeating customer details each time they buy something, or repeating it in a few tables, i.e if they order something then buy it. I hope I don't sound too much like a know it all but I am a bit of a database expert. I have been working with databases since 1981 and have only been teaching for the last few years.
> 
> Jenny Gielb
> VCE IT Teacher
> Chisholm Institute of TAFE
> Dandenong Campus
> 
> 
> _______________________________________________
> 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