Tags: access, advice, arena, changing, database, databases, design, microsoft, models, mysql, oracle, relatively, sql, table, uml

Table Design issues - need some advice

On Database » Microsoft Access

719 words with 0 Comments; publish: Fri, 07 Dec 2007 16:11:00 GMT; (25046.88, « »)


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:


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


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!


All Comments

Leave a comment...