Jump to content


Photo

Entity relation in mysql


  • Please log in to reply
2 replies to this topic

#1 javaid

javaid
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 24 April 2003 - 12:48 PM

I am using MySQL 3.23.47-max the problem i ahve is that i want to creat ER diagram through reverce enginering, for which i am using
Enterprise Architectv but whn i impoart tthe data base i dont get the relation between each table.

:roll:

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 24 April 2003 - 02:23 PM

i\'m not aware if this is the case with max, but mysql does not do relationships for you. you can specify foreign keys and such, but this is merely for documentation/reference.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 24 April 2003 - 02:52 PM

Mysql is doesnt provide u the structyre or the ER diagram as Microsoft SQL.

I am not sure whether there is any toold available for u to do that and if u happen to find one do letus know :lol:
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users