Hi,

I actually posted this on "Microsoft Access" forum but after some consideration i thought this would be more appropriate as its more of a "design issue". Sorry for the double post! So here it goes:

I'm relatively new to the database arena and have been looking at changing UML models into databases. My teacher gave me this simple UML diagram shown below:

http://www.dbforums.com/attachment.p...1&d=1137479412

My tasks is to transform it into Microsoft accesss tables and here is my solution:

http://www.dbforums.com/attachment.p...1&d=1137479412

I created an associative table to manage the "part of" relationship between A and B. Am i correct? Would this solution work?

Tell me what you think,

SOrry i dunno how to upload them pictures so you can view them...

Thanks for your help!
Jack