Structuring Table Relations!!

[tflett]

Hi all,

I built a database and I was wondering if anyone has any suggestions on how to normalize my DB. I think my table relations are wrong.

I'll post my DB for you people to view.
View attachment PPT-Trainee DB.zip

Any Help will be appreciated

 

[ajetrumpet]

I don't see anything wrong with this actually. What don't you like about it??

Your one-to-many's are set up just fine. What exactly are you looking to change?? Are you having trouble with specific tasks right now??

I didn't look through everything....not all the queries anyway...

 

[miltiadis21]

It needs normalization especially the Primary training or the secondary training it has redundant data Start date until costperstu needs normalization and to be enterer in a new table and differentiate costs also

 

[tflett]

do you have any suggestions that may make this DB Normalized?

 

[Rabbie]

Yiu have already asked this question in this thread http://www.access-programmers.co.uk/forums/showthread.php?t=133428.

See the answers you were given then. Basically you need to merge the primary and secondary training tables. You can add a field to say which level the training is at.

 

[tflett]

Thanks Rabbie.