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, « »)

Hi,

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.php?attachmentid=5652&stc=1&d=1137479412

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

http://www.dbforums.com/attachment.php?attachmentid=5653&stc=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

All Comments

Leave a comment...

  • 0 Comments