Messages

1

General Board / Re: java String, Integer, Double etc

« on: November 07, 2005, 02:17:52 pm »

Sorry for such a simple question. I cannot find the answer in Help.

How do a get attribute types of String, Integer, Double etc, to show up when I create attributes for a class? (Obviously I can type in the word String, but I do not get the full capabilities of a real type.)

I looked at Import Binary (a jar) but this deos not seem the right way to add something so widely used?

Thanks.

Alex

Hi.

If yu want to assign data types to attributes, (I think) you have to set the language (C#, Java,...) for the class _before_ you can use data types.

But after you "assigned" a programming language to a specific class, you will be able to set the data type for each attribute via the "type" dropdown-menu (in the attribute form).

Julian

EDIT:
More easily:

Draw a class, double-click, select the language in the language dropdown menu.
then go on to detail - attributes. You will notice, that you can choose from more data types now

2

General Board / Re: Help! Lost my Project Browser!

« on: November 07, 2005, 02:30:33 pm »

Hi dserodio,
Another think you can try is setting EA's visual layouts back to default, this will bring all windows back to their native position. To do this simply go to View | Visual Layouts | Default Layout.

All the best.

Hi TomO,

thanks for the input!
That would be easier than my method, wouldn't it ?

Julian

3

General Board / Re: Help! Lost my Project Browser!

« on: November 07, 2005, 02:23:53 pm »

In my previous job, I had a second monitor plugged in to my notebook, so I detached the Project Browser toolbar and put it on the secondary monitor.

Now I don't have a secondary monitor anymore and the Project Browser can't be found! Clicking on the "Project Browser" option in the "View" menu doesn't do anything (it even stays checked), neither does clicking the "Resource Browser" option. How can I bring this toolbar back?

Thanks!

Hi.

This is no "problem" caused by EA, but by yout monitor settings. I also had this problem with other software tools and the only way to get the hidden toolboxes back, was pluggin in the 2nd monitor again and move the toolboxes (which appeared on the 2nd monitor) to my notebook monitor.

Maybe this software http://www.realtimesoft.com/ultramon/ will help you. I'm not sure, but a lot of people recommended it to me some time ago.

Julian

4

General Board / Re: Logical View - Hide Data Type?

« on: November 06, 2005, 12:31:37 pm »

Hi Julian,

I think you are right, this probably can't be done with the current version of EA. Definitely worth submitting as a feature request though!

Bruno

Hi Bruno. Yes, this would be fine. It can't be a big deal for the developers to implement this feature. But I think it would be a great advance for all of the users, because sometimes everybody needs this feature
(i guess)
Julian

5

General Board / Re: Logical View - Hide Data Type?

« on: November 06, 2005, 10:18:22 am »

That won't help, Julian does not want to hide the attributes altogether, only their data types. I think there was a discussionabout this a while back with the conclusion that that was not possible, but that has a been a while back and EA has evolved since then. Not sure if it can do this though :-)

Bruno

Hi Bruno.

I didn't find a menu entry that can do that. Maybe I didn't look that much, but there was no feature that could hide the "Attribute Domains".

Julian

6

General Board / Re: Logical View - Hide Data Type?

« on: November 06, 2005, 05:45:39 am »

Julian;
Right click on the diagram element representing the table.  Select Features -> Feature Visibility Then in the Attribute Visibility panel, uncheck "all".

Hope this is what you wanted.

Hi jeshaw2.

It's not exactly what I wanted.

I will explain it more in detail:

- I have a table (lets say: City)
- There are attributes (lets say: Name, PostalCode, ..)
- This attributes have data types (Name has NVARCHAR2, PostalCode ..lets say LONG).

-->

CITY
-----
Name: NVARCHAR2
Postal Code : LONG
......

^--- that's what the table looks right now.

I want the table to look like this:

CITY
-----
NAME
Postal Code
......


See the difference? There should be no more data types I don't want to delete the data types for every attribute manually, because I need them afterwards. But I want to exclude them from being shown Is there a chance to do so?

Julian

7

General Board / Logical View - Hide Data Type?

« on: November 06, 2005, 01:39:22 am »

Hi There. I'm currently modelling a database wirh EA. Actually, right now, I'm modelling an ERD with the Logical View "Feature".

I always inserted a data type with every attribute in a table, but now I want the chance to hide the data types (so that there are only the names of the attribute in every table visible - I don't need any data type in an erd - that's overhead ) I mean, I want the data types stored for every attribute, but I don't want them visible in the model.

How can I do this?

Julian

8

General Board / Re: Database Modelling with EA - Howto?

« on: November 06, 2005, 02:44:59 pm »

Just out of curiousity, what other DB modeling tools do you use?

Bruno

Hi Bruno.

Normally I use ERWin, because I like this "logical and physical model in one" - concept. It's quite a good tool and I use it for serious DB work .

Sometimes - to type in some ideas or to present db models in an user-friendlier way - I also use MS Visio. But that's only for "presentation use", because I don't like the "forward/reverse engineer" feature of it.

Julian

9

General Board / Re: Database Modelling with EA - Howto?

« on: November 06, 2005, 01:46:50 pm »

{snip}

Hope this helps!
Bruno

Hi Bruno.

Thanks for the help. I always kept in mind, that EA is an UML Tool and not an "Database Design" Tool.
I realized that it could be easy to model the physical view of data in EA, but I've also seen that it can be difficult to "hold" 2 layers (logical and physical) of one database. Nevertheless, I will use EA parallel to my other DB Tools and sometimes, who knows, I will only use EA at all

Julian
PS: Do you model databases in EA as well?

10

General Board / Database Modelling with EA - Howto?

« on: November 06, 2005, 10:31:47 am »

Hi there.

I have a big question.
(Please correct me whenever I talk bulls#it).

It's about the overall database modelling cycle. How can I do this in EA?

I mean, there is the logical model view (this must be the "conceptual model", right?)
and there is the data model view (the way the db is implemented, the physical view, right?).


==
FIRST of all: LOGICAL MODEL
==
When I start modelling a db in the logical view, I concentrate on

-the important, essential Tables (Entities),
-relations and
-the keys (primary / foreign key) as well as on
-the other attributes (that are not pk or fk or both).

After that I have a model, "everybody" can understand.

It will tell me, how many rows of the one table are related with how many rows of the other table... (1:n, n:m,......) and I will see any important tables (entities). There will be more (especially when I create the association tables for m:n relationships...), but with the logical view I will be able to get "the big picture" of the db.

Another question would be: Is EA able to import foreign keys into another tables?

-> If I have a table
   COUNTRY
  -------------
   CName (PK)

and a table

   CITY
   ------
   CityName (PK)

and when I try to connect them via association (I want the CName of Country as part of the PK and as FK for table City)... how can I realize this? (I don't mean via the foreign keys... feature in the menu of the connection, but I think of a way like in ERWin [you connect two tables an ERWin imports the needed Keys in the relevant table])

==
SECONDLY: THE DATA Model
===

But now I want to create the particular implementation, the physical view, where I also have a special db system in mind (oracle, for example).

How can I move all my data from the logical model designing process to the data model? Is there a chance without losing information from the logic design process?

===
THIRDLY: Generating DDL for use in DBMS
===
And after all I can generate DLL-Code for use in my DBMS.



Maybe you can help me and try to explain how I can realize this "workflow"

Thanks

Julian