I have no problem with converting ER to SQL tables, but I don't know how can I convert EER to SQL tables? as you Know that EER has "is a" specification and inheritance, but I don't know how relational databases can connect with inheritance specification
A:
I'd say look into the Hibernate storage strategies.
Hibernate is an ORM system that persists objects in an SQL database. In the link that I sent you it gives you a table schema for how the storage strategy is persisted in the SQL database.
If you use Appfuse or Groovy it can generate these relationships for you.
Then you might want to map the schema into a CASE tool of some sort to turn it into an Entity Relationship Diagram.
leeand00
2010-04-15 19:44:02
Thank for introducing me new aspect of Java programming. I will google Hibernate and get more information. But my problem is platform independent. Just I want convert EER to SQL table.
Khajavi
2010-04-15 20:02:36
@Khajavi "is-a" is inheritance right? Hibernate supports that being stored in an SQL table. All you'd have to do is create some actual classes to convert it with.
leeand00
2010-04-15 20:30:36
@Khajavi I'm not suggesting that you are required to use Hibernate. I'm suggesting that you use Hibernate to generate your SQL tables.
leeand00
2010-04-15 20:38:15