Designer and tables with the name in plural
572010Oct 10 2007 — edited Oct 11 2007Hi,
I'm working in a small applications team and alot of us are a bit new to the whole design the system from scratch thing. I've got a really basic question to ask.
One of the guys is using Designer (his first time) to build the data model and table creation scripts. The tables in the data model that has been produced out of designer is not exactly the same as the tables in the database, e.g on the diagram it will have APPLICATION while in the database it will have a table called APPLICATIONS. He said it's because they are entities in the diagram.
Well I don't know much about database concepts and such but is there any way for designer to produce a data model with names the same as in the database? It's annoying looking at this diagram knowing it's "not correct".
Or is there any tool/method I can use to generate a data model from the tables set up in an Oracle database.
Thanks in advance. Sorry about any mangling of database concepts here.