complexity/details of ERD

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks k_murli_krishna for the detailed points.

*Just by looking at an ERD, will you be able to tell if it is a OLTP or OLAP db?
*Is Visio a simple or advanced tool compared to ERWIN?

SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

k_murli_krishna, is "crows feet notation" apply to OLAP also or only to OLTP?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

k_murli_krishna, can you pl take a look at the attached ERD. You don't see any notation/feet in it, do you? I made this from visio. Is it OK design for OLAP model?

erd.jpg

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.