How to build a datamodel

tudaykumar · #1 (**permalink**) 12-01-07, 16:11

Hi all,in

I have the database but there is no datamodel, so using the database I have to build one. Can any one help me out in how to do this please? I have the DDL but not knowing from where to start.

Thanks to you all in advance.

r937 · #2 (**permalink**) 12-01-07, 16:55

u have teh ddl?

tudaykumar · #3 (**permalink**) 12-02-07, 12:49

Yes we have the DDL, now as we are migrating to Oracle from DB2 they need the datamodel, not knowing how to do the reverse engineering can anyone help me out please

r937 · #4 (**permalink**) 12-02-07, 21:13

take the ddl, run it into an empty database to create the tables, then use a data modelling tool to do the reverse engineer

there are lots to choose from here: http://databaseanswers.org/modelling_tools.htm

rahul_s80 · #5 (**permalink**) 12-02-07, 23:48

microsoft visio

Internet Services

Web Development

Digital Marketing

Consumer Tech