Table design and normalization

[tradewise]

I want to display skill codes. The codes must be applicable to multiple Trainee types, Locations, Rooms and Trainers eg

Code - A1
Code Applies To - Archery
Description - Do This
Reference Material - Book A
Trainee - Men, Women, Children
Skill Level - Novice
Location - Here, There, Everywhere
Room - 1, 2, 3 (the room is a part of the Location - Here 1, There 2 etc)
Trainer - Tom, Dick, Harry
Trainer's Location - London

Code - B1
Code Applies To - Basket-Weaving
Description - Do That
Reference Material - Book B
Trainee - Men, Children
Skill Level - Intermediate
Location - Here, There
Room - 1, 2
Trainer - Tom, Harry
Trainer's Location - New York

Code - C1
Code Applies To - Cleaning
Description - Do The Other
Reference Material - Book C
Trainee - Children
Skill Level - Advanced
Location - Here, There
Room - 3, 4, 5
Trainer - Dick
Trainer's Location - Paris



I've looked at several articles, on-line and in books, which are good but are just too generic. I would really like some assistance in the specifics of my example.

 

[BNPMike]

Read An Introduction to Data Base Systems by C J Date.

It's expensive but - hell - this bloke was half the team that invented the N-ary Relational Database we all use today.

Presumably that's why he's allowed to mis-spell "Database".

 

[lespaul]

Check out the developers section of:

http://www.alphabetcitydataworks.com/

(Thanks to JeremyNYC for this invaluable link)

there's an article there that will help you through the normalization process.



Leslie